3 Replies Latest reply on Nov 27, 2018 7:52 AM by Don Wise

    Count of the rows after filtering

    data Lake

      Hi tableau Guys,

       

      Had a scenario like

       

       

      PatientE.IDVisitIP/Ed
      1AMSSLIP
      1bMSHSIP
      2cABCDED
      3cMSSLED
      3dMSSLED
      4eMSSLED
      4fMSHSED
      4gABCDIP
      4hMSSLED

      should get output like

       

       

      MSSL
      patient ID#encounterIP                       ED
      1220
      3202
      4413
      Total83

      5

      Explanation:

       

      The 2nd table shows output for a selected Visit Filter Like 'MSSL'we need to find # of Encounters, sum of  IP's and sum of ED's.

      for example IF visit is MSSL they is count of 2 IP's (Considering the encounters,IP,ED for both visits)