Knowledge Base Article

Calculate the Average for the indicator as on the pivot with the filter

Calculate the Average for the indicator as on the pivot with the filter

To calculate the average value for the indicator and get the same result as in the Pivot, we use the simple AVG formula in both cases and get the correct result.


But if we will add a filter for the Marks, the result will be different.



To fix this, you should use a formula for the indicator widget:

 

 

 

avg([student],[Average mark])

 

 

 


where, [student] is All items and [Average mark] is average for the Mark values.

The final result will be

 

Related Content:

https://docs.sisense.com/main/SisenseLinux/build-formulas.htm

 

https://academy.sisense.com/dashboard-designer

 

 

Updated 11-22-2024
No CommentsBe the first to comment