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!

[AndersBGS]

Hi @Tom Sienkiewicz ,

I agree with the solution @Tai Vu has mentioned. For a daily indicator you need to add in "date on today". By doing this,  you will only capture the data where date is todays date. 

Right now you have no condition in your indicator source / automated indicator, so it will just fetch all data entries from the table and sum it up according to minutes.

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

Best regards

Anders