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





      Surg_Start _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