Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
AssumeI have 3 columns in my source table:
Test Performed | Patient Name | Healthcare Number Exists |
---|---|---|
X-Ray | John | Y |
Histology | Nancy | N |
X-Ray | Nancy | N |
X-Ray | Bob | N |
Blood Sample | Dan | Y |
I want to count on the pie chart the number of people who have the Healthcare Number and who don't but only for distinct values of Patient's Name to avoid double-counting. So the output should be 2 Patients without Healthcare Number/2 Patients with Healthcare Number and not 3 Patients with Healthcare Number/2 Patients with Healthcare Number.
How can I make this work?
I was think using set expressions but I am not sure how the syntax works in this situation. Something like this makes sense but doesn't work: =count( { < distinct [Patient Name] > } [Healthcare Number Exists] )
Please help..
May be this:
Dimesnion:
[Healthcare Number Exists]
Expression:
Count(DISTINCT [Patient Name])
May be this:
Dimesnion:
[Healthcare Number Exists]
Expression:
Count(DISTINCT [Patient Name])
Thanks so much for a lightening response, silly of me to not have figured it out.