I have a measure that I am forecasting with monthly frequency . I am forecasting forward 12 months.
I also have points from another analysis are in the forecast horizon, that is in a time period passed the actuals.
I would like to have a dual axis: One with the actual and forecast and the second with the point estimates..
The article How To Show Forecast,only for one axis.,https://kb.tableau.com/articles/HowTo/showing-forecast-for-only-one-axis?_fsi=ezRl0zAp , for only one axis shows me how to have the dual axis with only one forecast.
The difficulty occurs when the points are in the same time period as the forecast estimates.
I have attached a copy of the workbook from the kb article with the data modified so that
- the dates for profit are in the forecast horizon
- the profit dates are null before 2006 and
- the margin dates are null after 12/2005
The Original
Modified version missing estimate forecast line segment and CI.
My question has some similarities to the following but they don't quite fit the same situation.
null from 2015 not answered.
null
With my actual data I have made two separate data sources one with the actuals to forecast and one with the points. There is a 6 month horizon in this example. There is an overlap in time of 2 months. The points for those months appear. Points that overlap the horizon do not.
Summary wish list:
One measure with a forecast.
A dual axis second measure plotted with points that can occur in the forecast horizon, CI interval area.
This post is very similar to what I am trying to do. How to calculate EXPECTED vs ACTUAL time-series data
However, I want to be able to compare the forecast to Budget me without saving the crosstab version of the forecasting results to Excel and modifying.
I have tried to use the Prediction Interval fields in a calculation field but when I drag it into the calculation the original measure value is displayed instead of the Upper Prediction Interval.
Is there a way to use the Upper Prediction Interval Fields in calculations.
I can include the Budget value column in the crosstab but the next step I need to perform is to see if the budget is above the Upper Prediction Interval.
