Knowledge + Science

5/8/2021
Tableau Suggestions – Quantity 21: Forecast Suggestions

Right here comes the primary Tableau Tip quantity in 2021- Quantity 21. On this brief put up, I’ll share seven ideas targeted on forecast perform in Tableau.

#7 – Present N Months and Forecast all Future Values.

Have you ever ever received right into a case if you simply wish to have a look at your actuals information for the final two or three months however view a forecast primarily based in your full actuals? This can be a tough one, as a result of in the event you filter out your actuals to a only some months, then Tableau will solely use these months in its forecast calculation. Yuri Fal has a slick tip for this one. Thanks Yuri!

There are a number of little tips on this one. Yuri used a parameter to calculate the distinction in every date to the max date within the information. Then he makes use of that calculation as an Attribute to create a brand new actuals line and hides the total actuals line earlier than utilizing « Present Forecast ». You may view his full tip within the discussion board here.

#6 – Take away the Hole in a Forecast.

After you Proper-Click on and « Present Forecast » on a chart, change the Forecast Capsule on Coloration from a Dimension to an Attribute. This may join the precise information to the forecast.

#5 – Take away the Mild Coloration from the Forecast.

Merely take away the Forecast Capsule from Coloration and the Forecast traces and bands will darken primarily based on the specific colours.

#4 – Set the Forecast to a Single Coloration.

Double-Click on the colour legend, then multi-select the Forecast classes and set the colour to single coloration. This may change the traces and the prediction intervals.

#3 – Take away the Forecast Prediction Interval from the Forecast.

Proper-Click on and choose « Forecast Choices » and uncheck « Present Prediction Intervals ». Mix with the earlier tip on a single coloration forecast.

#2 – Exhibiting the Forecast on Measurement.

Utilizing the CTRL key to tug and duplicate the Forecast Capsule on Measurement on the Marks card to point out the forecast utilizing measurement of the road.

#1 – Use Forecast to Lengthen the X-Axis.

In case your labels in your line chart do not have sufficient room, you should use the Forecast to increase. Add Forecast, uncheck « Present Prediction Intervals », set the forecast to background coloration and size to # of months.