How to calculate Monthly Aggregate of percentage indicator

[Community Alums]

Hi Team,

I have an indicator, which displays Percentage of calls attended by agent.

Below is formula.

[[GSDKPI_Number of calls answered]]/[[GSDKPI_Total Calls Received]]*100

Daily Number are coming correct for all the agents.

But I also want Monthly numbers for at least 3 months, so I am doing an aggregation as below. But I am not able to find "By month SUM" in Time series.

Please let me know how can I achieve this?

Regards,

Sindhuja.

[Adam Stout · Accepted solution]

If you are applying the formula to the result, it shouldn't matter.  If you do not apply it to the result, you will get a weird (probably not what you want) answer.  This shows the difference:

[jeffrubinoff]

You are explicitly not able to SUM a %. From the documentation: 

You are not allowed to put a SUM aggregation on an indicator with percentage % as the unit, because it is not meaningful to sum percentages.

Are you quite sure you want to see the sum of calculated percentages for 3 months? So if one month 85% of calls are answered, and the next month 75% of calls are answered, and in the third month 60% of calls are answered, you want the widget to display that 220% of calls were answered for those three months? Wouldn't you rather see the sum of all calls answered for those three months divided by the sum of all calls for those three months, times 100?

I'm not 100% sure how to suggest you do this, I am just a tech writer, but I think what you need is a new formula indicator to calculate the percentage from separate By quarter SUMs of GSDKPI_Number of calls answered and GSDKPI_Total Calls Received. I think this page in Formula Indicator documentation may hold the answer.

[Community Alums]

Hi Jeff,

I have made Apply time series to result as "false" for the indicator.

This will not sum a%

Rather it will sum up each component in the formula indicator separately for a month and later it will calculate percentage.

Regards,

Sindhuja.