3 Replies Latest reply on May 21, 2018 6:44 PM by Don Wise

    Calculate No. of Patient Admitted and Discharged on each Day by Admission Date and Discharged Date

    Ebad Ali

      Hi,

       

      I am working on a Hospital data set where I need to  calculate the Number of beds required to house the patient per year. In order to do this, I am trying to calculating the no. of patients admitted each day and no. of patients discharged each day. By calculating both fields I can calculate the no. of beds required for that day but the issue I can't figure out how can I count no of patients that were admitted and discharged each day. It would be really helpful if someone could explain or guide me about how can I achieve this. I have attached the Tableau Packaged File and Sample data set below.


      Thanks