Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following data:
And my problem is the following:
As you can see I have a client ID with two closed dates. The issue is that I need to count only the "Promoter" category for August, but the count is giving me the total of 5, instead of 2... how can I fix this?
As you can see in the second chart I have a column that uses Aggr() to get the max closed date, but I don't know to make the column "count" to count only those and ignore the data from January.
Thanks a lot for your help on the same.
Regards,
Hi, whenever I have this issue, I just use a simple "Sum(if", e.g.
Sum(if(NPS_Category='Promoter',1,0) and it worked fine for me:
Thanks a lot sunindia.... it seems to be working and giving me the number I need. Thanks for you help, now I will try to apply the same logic to fullfil the need we have.
Really appreciate it!!