Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is it possible that bottom 5 have all 0 values for some reason?
Is it possible that bottom 5 have all 0 values for some reason?
Sunny,
Please find the numbers
Sunny,
You are right. I have 0 values for bottom 5
Thanks,
Varun Reddy
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
Would it be possible to share a sample to look at the issue?