call compare report

[CBob]

Hello,

I need help with building a graphical report in excel. Basically i have an employee data from 2 states(SC & MA). The employees have went through some training between March 1st to March 16th to improve their performance and I need to show difference in improvement before(Mar1st - 16th) and after.

Essentially looking to see if there is a difference in calls made before and after training and did it got better or worse? If they got better what percent of improvement calls ? Meaning 15% of employees are making more than 5% of calls before training and 20% employees are making less than 10% calls before training and so on...



Below is the partial data:

EmpID	State	avg_calls_b4_traning	avg_calls_aft_training
220​	SC	160	189
442​	SC	282	255
334​	SC	181	197
223​	SC	258	223
556​	SC	193	232
789​	SC	326	376
676​	MA	250	298
333​	MA	130	183
689​	MA	225	258
129​	MA	162	236
279​	MA	236	279
248​	MA	142	100
180​	MA	170	220

Here what i am thinking in a tabular form(mock data) but wondering if there is a way to illustrate this in a graphical view to show the difference related to calls?

Thanks in advance for your time and help!!

 

[HighAndWilder]

I would set up a helper column containing the percentage difference between the two values.

In the results table I would use the COUNTIFS function with three conditions -:
1: Checking the value of the State column.
2. The minimum value that the helper column value needs to be.
3. The maximum value that the helper column value needs to be.

Let me know if you need any more help.