1 Reply Latest reply on Nov 30, 2016 8:57 AM by Christina Davis

    Vizual for OR Cases

    Dan Gordon

      Hello all,

       

      Starting to get the hang of this.  However, I have a request that I don't know how to do in Tableau.

       

      I have a data file that is an excel workbook with the following data columns

       

      Patient_ID

      Sched_Start_Datetime

      Sched_Stop_Datetime

      Surg_Start _Datetime

      Surg_Stop_Datetime

       

      I can calculate the scheduled Case length and the actual OR case length.  With all that, I have been asked to create a viz that has hours on the x-axis and Days Of Week (DOW) on the y axis for each week of the data (filter on the week desired).  The result would be a Gantt chart looking something like this:

       

      and so forth.  I have no idea how to do this.  I have attached a reference sample data file in excel format.  The actual data sources are Tableau Server DB (SQL Server).

       

      Any help is greatly appreciated.

       

      Thanks so much!

       

      Dan Gordon

      Frederick Memorial Hospital

      DGordon@FMH.org