PA - trying to get duration within an Indicator - need some help

[Tom Sienkiewicz]

Hi All,

I'm trying to collect values from a table where each user has a specific duration per day. Table looks like this:

I created an automated indicator with Aggregation: SUM and Unit: Minutes. I was expecting to see the scores being 480 minutes for each day per Agent, based on above data.

What it did instead, is it summed all the durations from all the days per Agent, like below:

e.g. Barbara Hindley had 3 entries with availability for 3 different days, so it summed 3x480 = 1440.

How do it get it to just use the existing value PER DAY and not sum everything up? There is no option to not aggregate by anything in the indicator...

Many thanks!

[Uncle Rob]

We need to see the Indicator Definition before we can tell you what went wrong.

[AndersBGS]

Hi @Tom Sienkiewicz ,

Please share your automated indicator definition together with the conditions utilized both on the automated indicator and on the indicator source. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Tom Sienkiewicz]

@Uncle Rob @AndersBGS pls find below the details of the indicator and indicator source. Should it not be summing up the values per each day separately?

Thanks for any suggestions!

[Tai Vu · Accepted solution]

Hi @Tom Sienkiewicz 

Let's add the date condition into your Indicator Source. Sample:

1. Daily Frequency: Date on Today
2. Weekly Frequency: Date on This Week
3. Monthly Frequency: Date on This Month

Then, re-execute the Data Collection Jobs and observe the result. The Collection Job will bring the conditions and apply to each day for all the period.

Let me know if it works for you.

Cheers,

Tai Vu