Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am applying below formula in KRI filter but when I select KRI scores, multiple scores are getting selected. For example, if I select KRI score 3 along with 3 even 4 also get selected. If I select 6 along with 6 even 7,8,9 get selected and same result for multiple value comes in below all bar charts. How can I fix this issue. Below is the formula what I applied for KRI filter.
=Aggr(if(sum(subjects_enrolled)>=Mean_IRT,'1',if(sum(subjects_enrolled)< //Median_IRT if(len(Median_IRT)=0, Aggr($(vMaxMedianIRT),ISN),Max(Median_IRT)) ,'3','2')) + if(count({<any_aecoded_value = {'1'},ae_serious_desc = {'YES'}>} any_aecoded_value)>=mean_sae,'3', if(count({<any_aecoded_value = {'1'},ae_serious_desc = {'YES'}>} any_aecoded_value)=0,'0', if(count({<any_aecoded_value = {'1'},ae_serious_desc = {'YES'}>} any_aecoded_value)< //Median_IRT if(len(median_sae)=0, Aggr($(vMaxMedianSAE),ISN),Max(median_sae)) ,'1','2'))) + if(sum(screen_failure_rate)>=Mean_Screen_Failure_Rate,'3',if(sum(screen_failure_rate)< //Median_IRT if(len(Median_Screen_Failure_Rate)=0, Aggr($(vMaxMedianScreenFailure),ISN),Max(Median_Screen_Failure_Rate)) ,'1','2')) + if(Count({<any_aecoded_value = {'1'}>} any_aecoded_value)>=Mean_rave,'3', if(Count({<any_aecoded_value = {'1'}>} any_aecoded_value)=0,'0' ,if(Count({<any_aecoded_value = {'1'}>} any_aecoded_value)< //Median_IRT if(len(Median_rava)=0, Aggr($(vMaxMedianAE),ISN),Max(Median_rava)) ,'1','2'))) + if(Count(Deviation_ID)>=Mean_Protocal,'3', if(Count(Deviation_ID)=0,'0', if(Count(Deviation_ID)< //Median_IRT if(len(Median_Protocal)=0, Aggr($(vMaxMedianProtocol),ISN),Max(Median_Protocal)) ,'1','2'))),site)
We need to select only one KRI score but above formula is overlapping for multiple selection like it is taking all possible values