Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have an Ad-hoc report page with the following script.
AdHocDimensions:
LOAD * Inline [Dimension_1, dimension_flag
Site, 1
Direct, 2
Dept, 3
Func, 4
];
AdHocParameter:
LOAD * Inline [Parameter_1, Parameter_flag
Grid, A
];
The expression I am using is below:
=aggr(nodistinct if(count({<GRating = {'10'}>} GQuestions)>=3 and count({<Rating = {'<=6'}>}GQuestions)=0, 'Outstanding',
if(count({<GRating = {'>=7 <=9'}>}GQuestions)=count(GQuestions), 'Good',
if(count({<GRating = {'<=3'}>}GQuestions)>=3, 'Inadequate',
if(count({<GRating = {'<=6'}>}GQuestions)>=3, 'Requires Improvement',
if(count({<GRating = {'<=3'}>}GQuestions)>=2, 'Requires Improvement', 'Good'))))), Func, Domain, Direct, Site, Dept)
This works when I have selected all the 4 adhoc dimensions in List Box, but when I unselect a dimension, I am getting null values. I tried removing 'nodistinct' but it doesn't help. Looks like something simple but not sure what. Any help is appreciated.
Thanks,
Karthik
I would also suggest you palce these in order from best to worse and make sure you do not overlap
there are 2 requireed improvements and several criteria that are <=. >= 3 and your counts can only meet one of the criteria. Butting them in order will help, and add a catch all that if it is not met put 'Not Applicable' or somethin similar