Bottom 5

[varunreddy]

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

[sinanozdemir]

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

[varunreddy]

Hi Sizan,

I tried this. But it is displaying all Assessment Names

[sunny_talwar]

It might be possible that all bottom 5's are 0?

[varunreddy]

Sunny,

I have unchecked Suppress Zeros

[varunreddy]

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.