set modifier issues - trying to do a simple function

[jmalenfant]

Hi all,

I'm sure this it very simple and that I'm missing something small, but can't find any posts or info that helping.

I'm trying to make a KPI for # of hospital visits.

enc_type: column in data that has"hospitalization information" as an option

I've tried various approaches ( think i need count and not sum)

Here's the closes I got, the syntax works but getting 0 results when I know there is data and I selected all years in the app using a filter for admit_date

Would love any feedback - i know i'm close but just missing something

count({$<encounterid = {"P({1<enc_type={'Hostpitalization Information'"}>}encounterid)

Thanks! !

[OmarBenSalem · Accepted solution]

What happens if you just use:

count({1<enc_type={'Hostpitalization Information'"}>}encounterid

[jmalenfant]

Thanks -I got an error when I typed what you suggested so modified to count({1<enc_type={'Hostpitalization Information'}>}encounterid)

still getting "0" when I know there is data.

[OmarBenSalem]

Can you share a sample application?

To directly test on it?

That would be much easier !

Thanks

[jmalenfant]

Hi - here's the app. The 4th sheet is where I've been trying things out.

I'd like a KPI for # encounterid with enc_type = "Hosptitalization Information" as well as a similar KPI that counts patid (i.e. patients) instead of encounterid (i.e.visits)

I'm wondering if it has something to do w/ all of the synthetic keys and links? I couldn't figure out how to remove them. the data shouldn't require any additional keys, the database seems to be set up correctly

thanks!

[jmalenfant]

in the data manager, the links and associations aren't appearing even though the data are loaded. Do you have any suggestions on how to see and remove the synthetic links created by Sense?

[jmalenfant]

Apparently I just can't spell - this worked thanks!