Automated Indicator with Average Aggregate
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-30-2023 10:33 PM
Hello,
I hope you can help me to understand what is the expected behavior about Automated Indicator whose aggregate is Average.
My Automated Indicator is configured to show the time series of the average score of CSAT.
"Value when nil" is set to zero.
According to the Docs, the value is to be not used to calculate average.
The value that is inserted as the score when no value is collected. This value is inserted whether or not breakdowns are applied. This value is not used to calculate formulas or aggregates, such as an average. |
However the score seems include zero's.
For example, if the value is 6 on a day and no value on the other days, the score is 0.9 (≒ (6+0+0+0+0+0+0)/7), and when the value is 6, 5.6, and no value on the other days, the score is 1.7 (≒ (6+5.7+0+0+0+0+0)/7)
Do you have any PRB information on this? OR is it the correct behavior to include the value configured the "Value when nil" field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-30-2023 11:48 PM
Hi @Kohei Tominaga1 ,
If you remove the "value when nill" and leave it blank, how does the system then behave? In general what you're describing would be the expected behavior from my understanding. no matter if you utilize the "value when nill" or not the calculation would be the same based on the count of weekdays. so (6+0+0+0+0+0+0)/7) or (6/7) will give the same.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2023 12:43 AM
Value when nil is the result that we'd like to return whenever no value is collected for the specific date.
If you set value when nil as 0. The collected result will be: 6 - 0 - 0 - 0 - 0 - 0 - 0
=> By Week AVG will calculated as: 6+0+0+0+0+0+0 / 7 = 0.8571
And if you leave the value when nil as empty. The collected result will be: 6 - nil - nil - nil - nil - nil - nil
=> By Week AVG will calculated as: 6 / 1 = 6
Cheers,
Tai Vu