I'm not exactly sure if I understand your question but when I am looking to forecast a bit using Tableau I do a trick where I extend the date axis into a time in the future and then turn on trend lines. If my trends are fairly significant I can get a general idea of how my sales will be in the future if things continued.
It's not very sophisticated, but it works for getting a general idea.
Can you be more specific about the type of analysis you are looking to do? Maybe some more specific questions you are trying answer? I'm not sure what you mean by an annualized field and the type of forecast you want that is not based on historical trends.
Thanks SW, but how do you extend the data axis? I'm using a dataset created on a SQL server. Any ideas are appreciated!
Hi Erin -
As part of our demand & inventory management planning, the businesses have been asked to closely watch demand and inventory levels to help manage
cash and earnings.
I have been asked to create a "velocity" metric using the last 3 months data annualized to the rolling 12 month sales. They will look at the recent trend and
compare it to the 12 month trend.
Further, they want to see each value in a side by side bar graph for each segment.Any ideas?? thanks in advance for your help!
You can extend the date axis by right-clicking the axis and choosing Edit Axis. Then you can set a manual range using the slider on the General tab.
You could also create two calculated measures based upon rolling 3 and 12 month sales volume.
Latest 3 months
IF DATEDIFF('month',[date],today()) <= 3
Latest 12 months
IF DATEDIFF('month',[date],today()) <= 12
Thanks so much. That may be exactly what this business needs. Appreciate you writing out the calculation - I wasn't sure how it should look.