6 Replies Latest reply: Apr 17, 2017 8:20 PM by Jessica Malenfant RSS

    set modifier issues - trying to do a simple function

    Jessica Malenfant

      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! !