Rank Help again

[#1]

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

[perumal_41 · Accepted solution]

Hi,

use this expression

max( Total aggr(rank(sum({<AGENT_ID={"=sum([EG_Agent_Talk_Time])<>0"}>}[EG_Agent_Talk_Time])),AGENT_ID))

[swuehl]

Just count the number of agents with TALKTIME > 0:

=count( TOTAL {<AGENT_ID = {"=sum([EG_Agent_Talk_Time])>0"}>} AGENT_ID)