Bottom 5

[varunreddy]

Hi All,

I am trying to display top 5 Assessment Names and Bottom 5 Assessment Names as of Latest Date Available.

Expression used for Top 5:

Only({<Date>} aggr(sum({<Date,

[Assessment Name] = {"=rank(sum({<Date= {'$(vCurMonthYear)'}>}1-([Total Number of Failing Records]/[Total Number of Records])))<=5"}

>}1-([Total Number of Failing Records]/[Total Number of Records])),Date,[Assessment Name]))

This is working fine

Expression for Bottom 5:

Only({<Date>} aggr(sum({<Date,

[Assessment Name] = {"=rank(-sum({<Date= {'$(vCurMonthYear)'}>}1-([Total Number of Failing Records]/[Total Number of Records])))<=5"}

>}1-([Total Number of Failing Records]/[Total Number of Records])),Date,[Assessment Name]))

This is not displaying any data.

I need to see bottom 5 values.

Thanks in advance!

Regards,

Varun

[sunny_talwar · Accepted solution]

Is it possible that bottom 5 have all 0 values for some reason?

[varunreddy]

Sunny,

Please find the numbers

[varunreddy]

Sunny,

You are right. I have 0 values for bottom 5

Thanks,

Varun Reddy

[varunreddy]

Hi Sunny,

Bottom 5 values are 0's. When I try to uncheck Suppress Zeros from presentation tab, I should see bottom 5 "Assessment Names". But it is showing error meaasge "No data to display".

Can you help me with this?

Thanks in advance!

Regards,

Varun

[sunny_talwar]

Would it be possible to share a sample to look at the issue?