Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have below table
and I want to show in KPI - count of those ID whose status is only 3 (Basically i don't want to count those ID Where status in 3 and 0)
so final count in KPI should be 3 (the green ones i.e. ID-2,4,5)
Please help me to write set expression in KPI
Thanks
#Setanalysis
Hi @pratham39 ,
Maybe this:
count( {< ID = {"=Count(Status)=1"}, Status = {'3'} >} Distinct ID )
I hope it can help.
Best Regards
Hi @pratham39 ,
Maybe this:
count( {< ID = {"=Count(Status)=1"}, Status = {'3'} >} Distinct ID )
I hope it can help.
Best Regards
Thanks
it worked!