Dear All Tableau savvy,
Could anyone please help me with my calculation? I was playing around with my FIXED formula but looks like nothing is working so far.
IDGroupYesNo1A1 2B113C 14C 15A116A 17A1 8B 19C 110D1 11A 12B1
Group A, for example, has 3 YES (id no 1,5,7) and 2 NO (id no 5,6). Basically, I wanted to get a distinct count of all columns where value = 1. if there is overlapping, they should be 1 only, but my formula returns 2 so it looks like i have more records. For group a, the total count should be 4 (distinct ids) and not 5).
Can you please guide me with the correct formula. Thanks so much.
3 answers
Hi,
Is that what you wanted?
{FIXED [Group]:SUM(IIF(NOT ISNULL([Yes]) OR NOT ISNULL([No]),1,0))}
Let us know if this help.
Mahfooj
