Pulling counts ignoring one value

[pgloc2020]

Hi All,

I really appreciate if any one can help me on this.

I have a data set which has user(LOGIN) and call number received by those users. For ex, I have users from A-Z and every user received some number of calls. I want to calculate total calls ignoring user B. Can you guys please tell me what expression should  I use in my Multi KPI chart which can pull total counts of calls except the calls received by user B?

I have used the following expression under dimension in the multi KPI chart, but obviously it is not working-

=COUNT(LOGIN)/COUNT({<B>}TOTAL LOGIN)

[MayilVahanan]

Hi @pgloc2020 

Try like below

=COUNT(LOGIN)/COUNT({<LOGIN-={"B"}>}TOTAL LOGIN)

[pgloc2020]

Thanks Mayil Vahanan,

I used the expression as suggested by you, but I am not getting the correct counts of calls. 

There are total of 109,942 calls received by all users where only user 'B' received total of 18,542 calls. In my KPI, the expected result would be 91,400. 

Please advise.

Regards,

PG

[MayilVahanan]

HI @pgloc2020 

=COUNT(LOGIN)/COUNT({<LOGIN-={"B"}>}LOGIN)

or

=COUNT(Total LOGIN)/COUNT({<LOGIN-={"B"}>}Total LOGIN)

[pgloc2020 · Accepted solution]

Thank you for the response. It worked. 🙂