3 Replies Latest reply on Apr 24, 2018 1:57 PM by Stacey Schipper

    Show all values having at least one of an attribute

    Stacey Schipper

      My hospital is trying to get a handle on no-shows so they want to show a count of visits per patient that have at least one no-show. Something like this:

       

      Department     MRN     Show     No Show     %No Show

      Allergy             12345     3              1                    25%

      Allergy             13456     5              1                    20%

      GI                    23567     3               0                    0%   <---Remove this row

      GI                    45678     0               1                    100%

         

      How do I go about removing the rows without at least one no-show? I've tried a calculated field like:

      (SUM(IF [No Show Flag] = 'NOSHOW'

      THEN 1

      ELSEIF [No Show Flag] = 'SHOW'

      THEN 0

      END))

      And filtering for at least 1 but that removes all of the Show values. We don't want to penalize our sickest patients (lots of appointments with a few no-shows sprinkled in.) So, how can I do this?

       

      Thanks for your time and assistance!

        • 1. Re: Show all values having at least one of an attribute
          Jim Dehner

          Hi Stacey

          you could just use               [no Show] >0               and place it on the filter shelf and set to True

           

          Not certain if No show is aggregated or you will need to aggregate but you can play with that

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Show all values having at least one of an attribute
            Stacey Schipper

            Thank you, Jim! So, here's what I did. I created this calculation which I called No Show Count:

            (SUM(IF [No Show Flag] = 'NOSHOW'

            THEN 1

            ELSEIF [No Show Flag] = 'SHOW'

            THEN 0

            END)) > 0

             

            Then filtered

            No Show Count = True

             

            and got back

            Department     MRN         No Show     %No Show

            Allergy             12345                  1          100%

            Allergy             13456                  1          100%

            GI                     45678                  1          100%

             

            It filtered out the "Show" column completely. Any ideas?

             

            Also the field contains the strings Show, No Show and Cancelled. I've filtered out the canceled and I just need to keep the rows that contain at least one no-show.

            • 3. Re: Show all values having at least one of an attribute
              Stacey Schipper

              I also tried

               

              (IF [No Show] =  'NOSHOW' THEN 1

              END) > 0

               

              and then set Filters: No Show Count = True

               

              And then got:

              Department     MRN         No Show     %No Show

              Allergy             12345                  1          100%

              Allergy             13456                  1          100%

              GI                     45678                  1          100%