5 Replies Latest reply: Jun 22, 2018 10:11 AM by Amuktha Chakilam RSS

    Finding 40%-90% range

    Amuktha Chakilam

      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!