Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to show top 5 Assessment Names using the rank function in the expression. It is working fine.
Can any one guide me how to show least 5 values using the below expression:
1-(aggr(sum({<Date,
[Assessment Name] = {"=rank(1-(aggr(sum({<Date = {'$(vCurMonthYear)'}>}[Total Number of Failing Records]),Date, [Assessment Name])
/
aggr(sum({<Date = {'$(vCurMonthYear)'}>}[Total Number of Records]),Date,[Assessment Name])))<=5"}
>}[Total Number of Failing Records]),Date,[Assessment Name])
/
aggr(sum({<Date>}[Total Number of Records]),Date,[Assessment Name]))
Thanks In advance!
Cheers,
Varun Reddy
Hi,
Have you tried putting "-" in front of Sum() functions?
"=rank(1-(aggr(-sum({<Date = {'$(vCurMonthYear)'}>}[Total Number of Failing Records]),Date, [Assessment Name])
/
aggr(-sum({<Date = {'$(vCurMonthYear)'}>}[Total Number of Records]),Date,[Assessment Name])))<=5"}
>}[Total Number of Failing Records]),Date,[Assessment Name])
Thanks
Hi Sizan,
I tried this. But it is displaying all Assessment Names
It might be possible that all bottom 5's are 0?
Sunny,
I have unchecked Suppress Zeros
I am using line graph. When I hover over 0, I am seeing top 5, but in legend I am seeing all the Assessment Names.