3 Replies Latest reply on May 16, 2018 7:29 AM by Zhouyi Zhang

# % of Total Patients using LOD for filtering capability

Hi All,

I am trying to use a calculated field that shows my % of total patients based on two different filters.

1. I have a 'Patient Id' field, so I created a calculated field for that to get a unique patient count: countd([Patient Id]).
2. To get '% of Total Patients' I use: {fixed [Clinical Class], [Clinical Class 2]: [# of Unique Patients]} / {fixed: [# of Unique Patients]} so that the numerator focuses on whatever I have checked for those two fields as filters.

My first obvious issue is that when I have 'All' selected for both filters, it says the correct total # of patients = 77, but % of total patients is 124.68%, which makes zero sense - shouldn't that be 100%?

My second issue is that when I filter on 'Clinical Class', the # of patients = 12, but the % of total patients is 16.88%, and if I do 12/77 = 15.58%, those don't match up.

I have a feeling I'm messing up something in my LOD expression, but I'm not sure what. Or is the fact that one of the my filters is in a hierarchy that is causing issues?

• ###### 1. Re: % of Total Patients using LOD for filtering capability

Hi, Beatrix

Please find my solution attached as well as below screenshot

Hope this helps

ZZ

1 of 1 people found this helpful
• ###### 2. Re: % of Total Patients using LOD for filtering capability

Thanks so much ZZ!

Is the 'INCLUDE' portion also a level of detail expression like 'FIXED'? I'm going to have to do a bit of research so I can fully understand them because it works but I don't understand how yet.

• ###### 3. Re: % of Total Patients using LOD for filtering capability

you are welcome, Beatrix

Yes, Include/Exclude/Fixed, they all LOD, the different for first two is they come into the calculation after filter applied, while fixed is calculate before filter applied.

ZZ