Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

Entire calculate column greater than- Set analysis

Hi All,

 

I create measure (its work fine) that check if the calc in the range of 0-25 %:

 

count(Aggr(if(Avg(Aggr(count(distinct if(Upper(Trim(ACTION_TYPE))='CLICKED',ISSUE_ID))
/
count(distinct if(Upper(Trim(ACTION_TYPE))='DELIVERED',ISSUE_ID)),ID))>=0 and
Avg(Aggr(count(distinct if(Upper(Trim(ACTION_TYPE))='CLICKED',ISSUE_ID))
/
count(distinct if(Upper(Trim(ACTION_TYPE))='DELIVERED',ISSUE_ID)),ID))<0.25,1),ID))

Due to performance issue , I want to change the calc to set analysis but I don't know how we can check the range..

 

Could you please advise?

Thanks 

1 Reply
GregoireVG
Contributor II
Contributor II

Hi RutiTaumanRubin,

What would greatly help, performance-wise, would be to create a new field in the loading script.
Something like : " Upper(Trim(ACTION_TYPE)) AS UpTrimActionType "

Then you can replace all your " count(distinct if(Upper(Trim(ACTION_TYPE))='DELIVERED',ISSUE_ID) "
 by count( distinct {< UpTrimActionType = {'DELIVERED'} >} ISSUE_ID)

And your measure will gain a lot in readability!