Automated Indicator with Average Aggregate

Kohei Tominaga1
Tera Expert

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.

KoheiTominaga1_0-1698729859660.png

"Value when nil" is set to zero.

According to the Docsthe 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?

 

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

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/

Tai Vu
Kilo Patron
Kilo Patron

Hi @Kohei Tominaga1 

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