2 Replies Latest reply on Jan 4, 2019 1:44 AM by Jamie Hubler

    Data Scaffolding

    Jamie Hubler

      Hello all,

       

      I am in the process of trying to build a dashboard that shows Pace.  Problem is, I want pace to show beyond the sales day, for the rest of the month/quarter/year.  I have been struggling with this for a couple of months now.  I was given a suggestion to try data scaffolding.  After reviewing some how to's I realized that using data scaffolding is my answer.  I am having issues with the calculations though.  What I want is for Tableau to plot the running sum of my pace calculation on days where sales have occurred.  Then I would like to calculate the projected running sum of pace for the rest of the dates throughout the whole year.  I have attached my worksheet, however, it probably won't be much help considering I have been playing around with calculations to see if anything works.  Another wrench in the works is that January data is not yet loaded, so I can't see the functionality of those calculations I have built.

       

      Is anyone out there a scaffolding genius who could take a look?

       

      Any help/suggestions appreciated.