Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have been trying to follow a very useful post from Erica Whalley at
I have run into a problem though.
this expressions requires an average, which I want to be dynamic.
=if(RowNo()=1 or count(Key)>([Average]),0,above(R2CUM)+(count(Key)<=(Average]))
I have tried using the average expression
avg(aggr(Count(Key),Week))
but of course this just returns the count(Key) because it is averaging and aggregating it over the one week in the chart.
the only way around this I can find is to calculate the average manually as below
=if(RowNo()=1 or count(Key)>(count(total Key)/NoOfRows()),0,above(R2CUM)+(count(Key)<=(count(total Key)/NoOfRows())))
which is fine for highlighting points above/below the mean but I also want to highlight above or below the UCL and LCL.
so is there a way around this problem please?
thanks once again for your time.
Kind Regards
Steve
It does.... TOTAL is used to get the Avg regardless of the dimension... same is true for Stdev
Many thanks