5 Replies Latest reply on Jan 25, 2014 4:01 PM by Shawn Wallwork

# How can I string two dimension in one time series, for example sales for period 1 & 2 then forecast for the remaining periods.

I would like to be able to have one sting of data from two different values based on the month. For example sales dollars for month 1 & 2 but then just list forecast for the remaining months.  Can this be done?

• ###### 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.

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.

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

• ###### 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.

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