Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a Line Chart. I have Dimension as Date & expression =Count(ID). I need to enable a condition like A='-1' then count(ID) should reflect it.
Actual result should be 9. after selecting only i am getting the data. I need to show only exceptions team -1. this condition should be given in expression.
Can any one help to fix this.
Regards
Krishna
Try
=count(if(ExceptionsTeam = -1,ID))
Hi swuehi
Thanks a lot it working fine.
Regards
Krishna.