5 Replies Latest reply on May 23, 2018 9:21 AM by Bryce Larsen

    Calculation for Number of beds required to accommodate the number of patients in the data set

    Rishab Raina

      Hi,

       

      I am trying to calculate the number of bed required according to the dataset. My Idea was basically based to take the count of patients admitted and discharged per day and calculate the Maximum of cumulative frequency based on the difference of admitted and discharged. I have tried rigorously but tableau always shows 0.

      The PNG files show's how the output should look like but I don't want the exact output like that. I just want to take out the number of patients staying in the hospital. This represents my idea. I am not understanding what I am doing wrong.

      Please find the sample workbook attached.