Trend lines in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Trend Line Types in Tableau

Which type of trend line in Tableau best fits data that shows a consistent percentage growth over time?

A Linear trend line

B Exponential trend line

C Polynomial trend line

D Logarithmic trend line

💡 Hint

Think about which trend line models growth that accelerates or decelerates exponentially.

An exponential trend line fits data that grows or decays at a consistent percentage rate, which is common in percentage growth scenarios.

❓ visualization

intermediate

Interpreting a Polynomial Trend Line

You added a polynomial trend line of order 3 to a sales over time chart in Tableau. What does this trend line help you understand?

A A curve that can capture multiple changes in sales direction

B A line that only fits exponential growth

C A straight line showing average sales growth

D A flat line showing no change in sales

💡 Hint

Polynomial trend lines can curve up and down multiple times.

Polynomial trend lines of higher order can model data with multiple rises and falls, capturing complex patterns.

❓ dax_lod_result

advanced

Calculating Residuals for Trend Line Analysis

In Tableau, you want to calculate the residual (difference) between actual sales and predicted sales from a linear trend line. Which calculated field formula correctly computes this residual?

A [Sales] - (WINDOW_INTERCEPT([Sales], [Date]) + WINDOW_SLOPE([Sales], [Date]) * [Date])

B [Sales] - (INTERCEPT([Sales], [Date]) + SLOPE([Sales], [Date]) * [Date])

C [Sales] - WINDOW_AVG([Sales])

D WINDOW_SUM([Sales]) - [Sales]

💡 Hint

Use WINDOW functions to get slope and intercept over the partition.

WINDOW_INTERCEPT and WINDOW_SLOPE compute the linear trend line parameters over the current partition, allowing calculation of predicted values for residuals.

🎯 Scenario

advanced

Choosing the Right Trend Line for Seasonal Data

Your sales data shows clear seasonal peaks and troughs every year. You want to add a trend line in Tableau to understand the overall sales trend ignoring seasonality. Which approach is best?

A Add a linear trend line directly on the raw sales data

B Add a polynomial trend line of order 2 on the raw sales data

C Add an exponential trend line directly on the raw sales data

D Create a calculated field to remove seasonality, then add a linear trend line on that field

💡 Hint

Think about removing repeating seasonal effects before fitting a trend line.

Removing seasonality first helps the trend line reflect the true underlying trend without seasonal noise.

🔧 Formula Fix

expert

Debugging a Trend Line Calculation Error

You created a calculated field in Tableau to predict sales using a linear trend line formula: INTERCEPT([Sales], [Date]) + SLOPE([Sales], [Date]) * [Date]. However, Tableau shows an error. What is the cause?

Tableau

INTERCEPT([Sales], [Date]) + SLOPE([Sales], [Date]) * [Date]

A The multiplication operator * is not allowed in calculated fields

B Date cannot be used in calculations with sales

C The formula is missing a WINDOW_ prefix for aggregation

D INTERCEPT and SLOPE functions require aggregation and cannot be used directly on dimensions

💡 Hint

Check if the functions need to be aggregated over a partition.

INTERCEPT and SLOPE require WINDOW_ prefix to compute over the current partition in Tableau calculations.