How can I create a Time series based on the Month Count?

[luislembertsant]

I need to create a new Time series based in the Month COUNT instead of the Month SUM.

Could someone advice me pls?

[pieter_goris]

Hi Luis,

if you want to solve this in Reporting, you have to set up a report like:

If your question is about Performance Analytics, you

A: could use timeseries aggregates when you define a widget or when in a detailed scorecard of an indicator for which scores are collected on a daily basis:

The difference between 'By month SUM' and 'By month SUM+' is that the '...+' options will also show the current running period.

or

B: want to set up an indicator source for new or closed records that is fit for monthly collection. In your conditions use something like 'last month' (1) and make sure to set the 'Valid for frequency' to Monthly (2):

(For open records you do not need to set up a separate indicator source. Just use the existing 'daily' indicator and collect it once per month on the 1st day of the month to collect the score for the day before.)

Next create a Count indicator on this source:

and schedule this on a monthly basis:

Hope this helps.

Cheers, Pieter

[luislembertsant]

Hi all,

In PA I need to create a Time Series like this :

[cid:image005.jpg@01D22DDA.BB19DB00]

To use in 2 formula Indicators in a Time Series Widget, By month SUM function return a very different value from the real one. I need By month Count.

But I can't create a new one, different from that ones already exist. Any advice will be welcome.

Thanks.

[pieter_goris]

You can use time series that you do not use and turn them into a count.

For which indicators do you need COUNT and will SUM not work?

[luislembertsant]

Hi,

I'm using formulas indicators:

For Those ones :

Adjusted SLA1

SLA %1

Note: 2- Achieved SLA came from another Formula Indicator (Total — Overdue)

Results using By Month COUNT ( RIGHT)

Results using By Month SUM ( WRONG)