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:
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
0 comments
