- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
set modifier issues - trying to do a simple function
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! !
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What happens if you just use:
count({1<enc_type={'Hostpitalization Information'"}>}encounterid
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What happens if you just use:
count({1<enc_type={'Hostpitalization Information'"}>}encounterid
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share a sample application?
To directly test on it?
That would be much easier !
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apparently I just can't spell - this worked thanks!