Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a straight table. The figures don't look like right, until I click on one of the lines and then the values show exactly what I want it to show! The expression I am using is as follows:
=Num(avg({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Aggr(count({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Event_Key),Financial_Year_Week)),'#,###.')
This is showing the average weekly demand, for financial year FY19/20, using demand only and counting using Event Key (unique identifier).
The table looks, as per attached (pic 01) at first (wrong figures). But when I click on, say XR, it shows the result in pic02 attached which is the correct figures!!??. Can anyone shed any light on this??
Many thanks.
hi
actually it's not that complicated ,
aggr function is unique because it disregards the table dimensions , so i your case it doesn't consider modality dimension
so you get wrong figures
you need to modify your expression
=Num(avg({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Aggr(count({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Event_Key),Financial_Year_Week,Modality)),'#,###.')
hi
actually it's not that complicated ,
aggr function is unique because it disregards the table dimensions , so i your case it doesn't consider modality dimension
so you get wrong figures
you need to modify your expression
=Num(avg({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Aggr(count({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Event_Key),Financial_Year_Week,Modality)),'#,###.')
Thanks very much! Best regards