KNOWLEDGE BASE

How to Show Upper Prediction Interval and Lower Prediction Interval in the Same View with Actual Values


Published: 02 Dec 2021
Last Modified Date: 03 Dec 2021

Question

How to show upper prediction interval and lower prediction interval in the same view with actual values.

Environment

  • Tableau Desktop

Answer

1.  Add the second [Sales] field to Row shelf, right click on it and select [Forecast result] > [Upper Prediction Interval].

2.  Add the third [Sales] field to Row shelf, right click on it and select [Forecast result] > [Lower Prediction Interval].

3.  Add [Measure Values] to Row shelf, and drag [Upper Prediction Interval for Sum(Sales)] and  [Lower Prediction Interval for Sum(Sales)] fields to [Measure Values] cards.
Remove other measures from [Measure Values] card.

4. Right click on [Measure Values] on Row shelf and click [Dual Axis].

5. Open mark card of [Measure Values], then press on Ctrl-key and drag [Upper Prediction Interval for Sum(Sales)] and  [Lower Prediction Interval for Sum(Sales)] fields to text mark card.

Please check the attached workbook and the video for more details.

 
Did this article resolve the issue?