Finding 40%-90% range

[achakilam1022]

Hi all,

How can I rank the agents (top to bottom) and then find who are in 40-90%  performance range rank wise(Transfers/Billable metric) in each campaign and then find the median of all the Transfer/Billable values in this 40-90% range which would be the target for that campaign? attached is the sample data.

Thanks!

[zebhashmi]

you can use something like that I will do it for you in while

concat(Class(Aggr(Transfers/Billable*100,[Agent Name]),2), '-')

[zebhashmi]

Maybe something like that

[achakilam1022]

Hi Jahanzeb,

I appreciate your response.

I want to define a target for each campaign by ranking the agents within each campaign based on Transfer/Billable rate. If there are 10 agents in a campaign, I want to consider transfer/billable rates of agents who rank between 4 and 9 (ranked by transfer/billable rate - high to low) in that campaign and then find a median of these rates.

Sorry if my original question was unclear.

Thanks!

[zebhashmi]

Ya, I am still not getting it very well. sorry about that.

what is in your target sheet you can achieve like this but I am not getting the next step.

[achakilam1022]

Thanks for your help, Jahanzeb!