How to calculate percent of count of UNIQUE values?

Q&A
,
2

Hi Eleri! You could create a calculation like this to get A=2/4=50%.

A= countIf(Symptom,Symptom=‘A’)/distinct_count(Person)

I used a sample dataset with this format:

Person Symptom
1 A
1 B
2 B
2 C
2 D
3 None
4 A