I'm trying to count in the expression number of different values for my field.
Lets say I have this values:
I want the expression to return 2 for ID - 1 and 1 for ID 2
Please don't tell me to put it as expression of count(distinct Value) and id as dimension.
my final expression should be something like:
sum(if (count(distinct aggr(only(My_Field1),My_Field1)) = count(distinct aggr(only(My_Field2),My_Field2)),1)