Getting a distinct count based on distinct criteria if a condition is met

[richleeb2]

Hi all,

I'm wondering if there is a way to get a total count for the following.  For anything that is successful under "Status" for a unique ID, I want to get a count of the number of distinct forms (with some of them being separated by delimiter comma)

123A has successful in both rows, so it counts 2 distinct forms (form1, form2)

345F has successful in only one row, so it counts 2 (form1, form2 )

678S is 1

897R is 0 since both are unsuccessful

344P is 0

234S is 3 since both rows are successful

So the total is 8.  Any idea how to do this in alteryx?

[Luke_C · Accepted solution]

Hi @richleeb2 

Totally, that's why I suggested unioning back the records from the 'D' output of the unique tool. That way the unique records are counted and the duplicates are not included in your count but still end up in your dataset.

[richleeb2]

Thank you, I got it to work!!