Applications	Calls Answered	Calls Ans After Threshold	Calls Abn After Threshold	GOS Calculation	Note
A	6	3	4	(6-3)/(6+4) =                  3/10= 10%
B	8	2	1	(8-2)/(8+1) =                   6/9=67%
Summary	14	5	5	(6-3+8-2)/(6+4+8+1)= 9/19=47%	Actual average GOS for A& B should be (10%+67%)/2= 38.5%

 

I ‘d like to create a graph to capture each day’s average GOS. For example, the table above represent one day’s data. I ‘d like to show this date’s average GOS- 38.5%  in the line graph. (The line graph need to show such data from the first working day of this month to current day.)

To get this 38.5%, it’s grouped by “Application”.

 

However the graph is grouped by  (on change of ) “Date” – so as to show the X Axis as the “Date” .

In the line graph, “show value” –  I put a formula as:  ( the result is GOS 47% which is wrong)

(sum({CallsAnswered}, {Application})-sum({CallsAnsAfterThreshold},{Application}))/sum({CallsAnswered}, {Application})+sum({CallsAbnAfterThreshold}, {Application})

 

Can any expert help me out and advise how to show each day’s average GOS  in line graph?

 

Thank you very much.