Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone.
I've read many posts before write mine, but I had no success in my tries.
Objective: To count how many Codes in Column 'A' have more than 1 distinct Code in Column 'B'.
So, in the example below we have codes 4850 and 4905 that have more than 1 distinct code in column 'B'.
I'd like to include this set analysis in a KPI. So it need to show '2' (for example below).
Thanks a lot!
Marcelo.
try below
=count(distinct aggr(if(count(distinct B)>1,A),A))
awesome, a answer too fast.
worked perfectly.
tks a lot
set analysis version
=count(distinct {<A={"=count(distinct B)>1"}>}A)