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.

[Tushar Hirpurk1]

Hi Sindhu,

Has data present in your instance for months?

           Because a time series that does not include data from partial periods must have data from the beginning and the end of the period. For example, a By month SUM time series aggregation requires scores from the start and the end of the month to be present. Otherwise that month is not included. A time series aggregation that includes data from partial periods, such as By month SUM+, needs only data from one day in the period.

Regards,

Tushar

[Community Alums]

Hi Tushar, 

Yes data is present in month for the system.

Also numbers are coming and working fine for one month if I select "Pivot Scorecard" in Visualization and selecting indicator below. But I need numbers for 3 months.

Regards,

Sindhuja.

[Tushar Hirpurk1]

What condition have you put in data collection job?

the relative start will be 3 months ago.

Please mark correct if it helps.

Regards,

Tushar

[Community Alums]

It is 2 months ago.

Does it make a difference if it is not 3?

I should be able to configure it and data should be displayed for 2 months right?

Regards,

Sindhuja.