Set Analysis

[pratham39]

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

[agigliotti · Accepted solution]

Hi @pratham39 ,

Maybe this:

count( {< ID = {"=Count(Status)=1"}, Status = {'3'} >} Distinct ID )

I hope it can help.

Best Regards

[pratham39]

Thanks 

it worked!