Set Analysis or If Statement?

[#1]

Hello,

I have the below if statement that gets me the expected result however I don't think it's the best way to do the query. I want to count the number of customers who have used only one TRANSCODE, the other query would be counting customers who use more than one TRANSCODE (so just change = to >).

Would anyone be able to try and get this into set analysis?

count(aggr(if(count(distinct TRANSCODE) =1,1), Customer))

Thanks,

Ralph

[MayilVahanan]

HI

     Try like this,

Use Customer as dimension:

     =Count({<Customer = {"=count(Transcode)=1"}>}Transcode) .

     =Count({<Customer = {"=count(Transcode)>1"}>}Transcode)

Hope it helps