Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone ,
I have 3 sets They includes mutual values in both sets
I want to count values for each set at only that sets
For example
a--> 1,2,3
b--> 2,5
c--> 1,6,7
I want distinct values belong to only that sets
count(a) = one value (3)
count(b) = one value (5)
count (c)= two values (6,7)
Say your field name is DataField(With values 1,2,3,4,5,6,7). Now,
Count(a) Expression: =Count({<DataField={1,2,3}>} Distinct DataField)
Count(b) Expression: =Count({<DataField={2,5}>} Distinct DataField)
Count(c) Expression: =Count({<DataField={1,6,7}>} Distinct DataField)