Hello everyone, hope you'll be able to help me
I have everyday sales data of this month and I need to forecast daily sales till the end of this month. I have to take into consideration the ongoing trend and also the history sales of the same month of previous year. The solution has to be refreshable, I mean after I refresh the data and new daily sale is added in current month, the forecast should update too.
This is my chart. Blue line is current sales, red one is previous year (the same month) sales. I need blue line to be continued with for example orange line which will show forecasted everyday sales.
I tried to do it with forecast sheet (from data tab), which does the instant forecast, but it either does linear forecasting which is not correct or I have to indicate seasonality, but I don't have seasonality, it's one month and every day sales are different. It doesn't show prev year sales too. So I guess it won't be useful for me.
Could you please tell me which tool to use or any formula?
Any ideas?
please help
Thank you in advance.
I have everyday sales data of this month and I need to forecast daily sales till the end of this month. I have to take into consideration the ongoing trend and also the history sales of the same month of previous year. The solution has to be refreshable, I mean after I refresh the data and new daily sale is added in current month, the forecast should update too.
This is my chart. Blue line is current sales, red one is previous year (the same month) sales. I need blue line to be continued with for example orange line which will show forecasted everyday sales.
I tried to do it with forecast sheet (from data tab), which does the instant forecast, but it either does linear forecasting which is not correct or I have to indicate seasonality, but I don't have seasonality, it's one month and every day sales are different. It doesn't show prev year sales too. So I guess it won't be useful for me.
Could you please tell me which tool to use or any formula?
Any ideas?
please help
Thank you in advance.