Trend lines in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a trend line in Tableau?

A trend line is a line added to a chart that shows the general direction or pattern of data points over time or categories. It helps to see if values are increasing, decreasing, or staying steady.

beginner

How do you add a trend line in Tableau?

You right-click on the visualization, select 'Trend Lines', then choose 'Show Trend Lines'. Tableau will automatically calculate and draw the line based on your data.

intermediate

What types of trend lines can Tableau create?

Tableau can create linear, logarithmic, exponential, and polynomial trend lines depending on the data pattern you want to analyze.

beginner

Why use a trend line in a business report?

Trend lines help to quickly understand if sales, costs, or other metrics are going up or down over time, making it easier to make decisions.

intermediate

What does the R-squared value tell you in a Tableau trend line?

R-squared shows how well the trend line fits the data. A value close to 1 means the line explains the data well; close to 0 means it does not.

How do you enable trend lines in Tableau?

A Use the 'Add Calculated Field' option

B Drag a trend line from the toolbar

C Right-click the chart and select 'Show Trend Lines'

D Trend lines are added automatically and cannot be enabled

You enable trend lines by right-clicking the visualization and selecting 'Show Trend Lines'.

Which trend line type is NOT available in Tableau?

A Linear

B Logarithmic

C Polynomial

D Quadratic

Tableau offers polynomial trend lines but does not specifically label any as 'Quadratic'. Quadratic is a type of polynomial but not a separate option.

What does a high R-squared value indicate about a trend line?

A The trend line fits the data well

B The trend line is inaccurate

C The data has no pattern

D The trend line is curved

A high R-squared means the trend line explains the data well.

Why might you add a trend line to a sales chart?

A To see the general sales direction over time

B To hide data points

C To change colors of bars

D To filter out low sales

Trend lines help visualize the overall direction or pattern in sales data.

Which of these is a correct statement about trend lines in Tableau?

A Trend lines can only be linear

B Trend lines can be customized to different models

C Trend lines replace the original data points

D Trend lines cannot be removed once added

Tableau allows different types of trend lines like linear, logarithmic, and polynomial.

Explain what a trend line is and why it is useful in data visualization.

Think about how a line can show if numbers go up or down over time.

Describe the steps to add a trend line in Tableau and how to interpret its R-squared value.

Remember the menu option and what R-squared tells about the line.