2 Replies Latest reply on Jan 17, 2012 2:54 PM by Miroslav Umlauf

Blending Actuals and Forecast and display in one row

Miroslav Umlauf Jan 3, 2012 3:21 PM

Hi all, attached is self-explanatory example in excel. I have Actuals (from OLAP cube) and Forecast (XLS input). Our daily report should show for each category ( i.e. Eshop) revenue by days (in columns) - if actuals available, show actuals; if actuals n/a, show forecast.

Can do classic actuals x forecast comparison using data blending, however this 'visualization' took me this night ... and nothing.

Thank you.

daily_fcst_eshop.xlsx 14.0 KB

1. Re: Blending Actuals and Forecast and display in one row

Joe Mako Jan 3, 2012 9:09 PM (in response to Miroslav Umlauf)
How about the attached?

blend.twbx 33.4 KB
Like Show 0 Likes(0)

Actions
2. Re: Blending Actuals and Forecast and display in one row

Miroslav Umlauf Jan 17, 2012 2:54 PM (in response to Miroslav Umlauf)

Thank you Joe, it works smoothly. The only thing which causes pain is date dimension from SSAS, but we're trying to reimplement our cubes; now I have to prepare the data manually in excel to be able to use date filtering functions of tableau.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Blending Actuals and Forecast and display in one row

1. Re: Blending Actuals and Forecast and display in one row

2. Re: Blending Actuals and Forecast and display in one row

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account