Forum Discussion

prashanth0626's avatar
prashanth0626
Frequent Visitor
6 years ago

Daily Forecasting based on monthly Budget

I have a monthly sales budget which i need to break down by day based on last 6 months seasonality. I need to consider weekday trend too as we have higher sales on weekend and towards month end.   ...
Need Help
prashanth0626's avatar
prashanth0626
Frequent Visitor
6 years ago

Fowmy amitchandak 

 

Thanks for the suggestion, but all of those actually don't serve my purpouse. I am not looking for a average split by day.

For eg, IF a month budget is 1000 i basically want to split the 1000 into day target by looking at my last 6 month sales pattern. I need two patterns to be utilized 1. As we go towards month end our sales increases so that should reflect in my forecast 2. We usually have higher sales on weekends (Thu-Sun). [Both of those looking at my last 6 month sales]

 

Thanks

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi prashanth0626 ,

     

    You may go to Analytics pane, add forecasting on the current visualization under Forecast section.

     

     

     

     

    Or you may share expected output in snapshot. Do mask sensitive data before uploading.

     

    How to Get Your Question Answered Quickly

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.