Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a question regarding using rank while ignoring filter selections.
I have 12 metrics on my app that all have different point values and these are added to create "total points" which is then being ranked by using rank([Total Points]) just referencing the column where all metrics are added together. If a user selects specific agents, I don't want the rank to change.
An example of two of the equations are below - the variables referenced are all fractile calcuations
if(Aggr((sum(TotalCallsHandled)-sum(ManualCalls))/sum(Utilization),MonthApp,AppAgent)>=vCPH90,5,
if(Aggr((sum(TotalCallsHandled)-sum(ManualCalls))/sum(Utilization),MonthApp,AppAgent>=vCPH75,4,
if(Aggr((sum(TotalCallsHandled)sum(ManualCalls))/sum(Utilization),MonthApp,AppAgent)>=vCPH49,3,
if(Aggr((sum(TotalCallsHandled)-sum(ManualCalls))/sum(Utilization),MonthApp,AppAgent)<vCPH49,2))))))
+
if(Aggr(sum(ConvFlag)/sum(CustCount),MonthApp,AppAgent)>=vConvPay90,10,
if(Aggr(sum(ConvFlag)/sum(CustCount),MonthApp,AppAgent)>=vConvPay75,8,
if(Aggr(sum(ConvFlag)/sum(CustCount),MonthApp,AppAgent)>=vConvPay49,6,
if(Aggr(sum(ConvFlag)/sum(CustCount),MonthApp,AppAgent)<vConvPay49,4,4))))
Thanks!