2 Replies Latest reply on Jan 5, 2017 1:05 PM by muhammad.aamir.0

    Forecast based on Same Month Previous Year with taking Week of the day into Consideration

    muhammad.aamir.0

      Hello All,

       

      Currently, I am forecasting volume per region based of (per day) % of total volume from same month last year.  I get my forecast number by dividing MTD Number by accumulated total of per day % of total from same month previous year.  I also take day of the week into consideration as the volume varies each day.  For example Mondays are heavy volume days whereas we have lower volume over the weekends.  I intentionally didn't include the entire December of last year and this year.   I just wanted to give an example of how I am currently calculating it in Excel. I hope it make sense! I need help with converting this forecast over to Tableau.

      Here is how it looks in Excel:

       

      Please let me know if you have any follow up questions.

       

      Thank you in advance.

      Muhammad