2 Replies Latest reply on Jul 25, 2018 12:25 AM by Tricia O'Keeffe

    Using Scaffolding with Stored Procedure to produce Occupancy Heat Map?

    Tricia O'Keeffe

      Hi, hoping someone can help me.....

       

      Using Tableau Desktop V10.4 I am connecting to a Stored Procedure, which provides data relating to when a hospital patient is Admitted, and when the patient is Discharged.

       

      I need to produce a Heat Map that shows bed occupancy, for each hour of every day, in the same way described here.

       

      I have researched and found I can achieve this by using either 'Initial SQL' or 'Scaffolding', via this article

       

      I have learnt that I cannot use 'Initial SQL' with a Stored Procedure.

       

      I am trying to understand if I can use the 'Scaffolding' method with a Stored Procedure.

       

      Any feedback would be greatly appreciated.

      cheers

      Tricia

       

       

      http://vizdiff.blogspot.com/2015/09/taking-stock-with-start-and-end-dates.html#!/2015/09/taking-stock-with-start-and-end-dates.html