Why performance ensures usability in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the dashboard to refresh every 5 minutes for better performance.

Tableau

Dashboard.RefreshInterval = [1]

Drag options to blanks, or click blank then click option'

A60

B30

C300

D1000

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing too low a value causes frequent refresh and slows performance.

Choosing too high a value causes stale data.

Setting the refresh interval to 300 seconds (5 minutes) balances performance and usability by updating data regularly without overloading the system.

2fill in blank

medium

Complete the calculation to optimize the measure by limiting data aggregation to the current year.

Tableau

SUM(IF YEAR([Order Date]) = [1] THEN [Sales] ELSE 0 END)

Drag options to blanks, or click blank then click option'

AYEAR(TODAY())

B2020

C2022

DMAX([Order Date])

Attempts:

3 left

💡 Hint

Common Mistakes

Using a fixed year makes the dashboard outdated.

Using MAX([Order Date]) is not a year value.

Using YEAR(TODAY()) dynamically filters data to the current year, improving performance by reducing unnecessary data processing.

3fill in blank

hard

Fix the error in the filter expression to improve dashboard load time.

Tableau

[Region] = [1]

Drag options to blanks, or click blank then click option'

AEast'

BEast

C"East"

D'East'

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting quotes causes syntax errors.

Using mismatched quotes causes errors.

String values in Tableau filters must be enclosed in single quotes to be valid.

4fill in blank

hard

Fill both blanks to create a calculated field that only sums sales for the last 6 months.

Tableau

IF DATEDIFF('month', [Order Date], TODAY()) [1] 6 THEN SUM([Sales]) ELSE 0 [2]

Drag options to blanks, or click blank then click option'

A<=

BEND

CTHEN

D>=

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong comparison operators.

Forgetting to close IF with END.

The condition checks if the order date is within the last 6 months using <= 6, and the IF statement ends with END.

5fill in blank

hard

Fill all three blanks to create a calculated field that returns average sales per customer only for customers with sales above 1000.

Tableau

IF AVG([Sales]) [1] [2] THEN AVG([Sales]) [3] NULL END

Drag options to blanks, or click blank then click option'

A>

B1000

CELSE

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' causes wrong filtering.

Omitting ELSE causes syntax errors.

The condition checks if average sales is greater than 1000, then returns average sales, otherwise NULL.