
1. Re: How can I string two dimension in one time series, for example sales for period 1 & 2 then forecast for the remaining periods.
Shawn Wallwork Jan 25, 2014 2:04 PM (in response to Tom Urzillo)Hi Tom welcome to the forums! We're going to need a wee bit more information from you to be able to help. Can you post a packaged workbook with some dummy data, or use the Superstore dataset to mock up what you're trying to do?
When you ask "Can this be done?" our response is almost always going to be yes, because you can do almost anything in Tableau. But I think your real question is "How can this be done?"
Cheers,
Shawn

2. Re: How can I string two dimension in one time series, for example sales for period 1 & 2 then forecast for the remaining periods.
Tom Urzillo Jan 25, 2014 2:20 PM (in response to Shawn Wallwork)Shawn,
If you look at the data below you can see for GL Period 7 and beyond (in the future) I do not have any actual sales values only a forecast number. For periods 1 through 5 (in the past) I want to be able to show the actual sales data and suppress the forecast as again it is in the past. For period 6 our current fiscal period I would like to show the sum of our sales + open orders. Therefore, what I am trying to accomplish is a string of data that for periods 1 through 5 display our sales value. For period 6 display our sales plus open orders and for periods 7 through 12 display my forecast number. Then as we move into period 7 it would be great to easily or automatically shift this logic as well.
Does that make sense?
Thanks,
Tom

image001.png 11.4 KB


4. Re: How can I string two dimension in one time series, for example sales for period 1 & 2 then forecast for the remaining periods.
Tom Urzillo Jan 25, 2014 3:39 PM (in response to Shawn Wallwork)Hi Shawn,
Although I do have interest in using the forecast functionality in Tableau, that is not really what my question is, let say I want to compare sales history for the last three months and open orders for the next two months. How best would this be accomplished?
Tom