Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am continuing to struggle with a rank expression! I would like to rank agents based on the calls they have received - this is the easy part. I only want to rank those that have received >0 calls and return that as a total (highest rank) in a column. My problem is that I can return the highest rank in a column but it is ranking the agents with 0 calls also which I want to avoid. In the attached example, I am looking to return on each row in the last column the value 14 which is the highest rank for those agents that had received >0 calls. I am currently getting 25 because it is ranking on the whole population which I want to avoid.
Thanks in advance
Haider
Hi,
use this expression
max( Total aggr(rank(sum({<AGENT_ID={"=sum([EG_Agent_Talk_Time])<>0"}>}[EG_Agent_Talk_Time])),AGENT_ID))
Hi,
use this expression
max( Total aggr(rank(sum({<AGENT_ID={"=sum([EG_Agent_Talk_Time])<>0"}>}[EG_Agent_Talk_Time])),AGENT_ID))
Just count the number of agents with TALKTIME > 0:
=count( TOTAL {<AGENT_ID = {"=sum([EG_Agent_Talk_Time])>0"}>} AGENT_ID)