Why advanced analytics uncovers hidden patterns in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a calculated field that finds the average sales.

Tableau

AVG([1])

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

AMIN([Sales])

BSUM([Sales])

CCOUNT([Sales])

D[Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM([Sales]) inside AVG() causes an error.

Leaving the parentheses empty.

Using COUNT instead of AVG.

The correct syntax to calculate average in Tableau is AVG([Sales]). Here, you only put the field name inside AVG().

2fill in blank

medium

Complete the code to create a calculated field that flags sales greater than 1000.

Tableau

IF [1] > 1000 THEN 'High' ELSE 'Low' END

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

A[Sales]

BSUM([Sales])

CAVG([Sales])

DCOUNT([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM([Sales]) causes the condition to compare total sales, not individual sales.

Using COUNT([Sales]) is incorrect for numeric comparison.

To compare individual sales values, use the field [Sales] directly in the IF statement.

3fill in blank

hard

Fix the error in this calculated field to correctly compute the running total of sales.

Tableau

RUNNING_SUM([1])

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

ACOUNT([Sales])

B[Sales]

CSUM([Sales])

DAVG([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using [Sales] without aggregation inside RUNNING_SUM.

Using AVG or COUNT instead of SUM.

RUNNING_SUM requires an aggregation like SUM([Sales]) inside its parentheses.

4fill in blank

hard

Fill both blanks to create a calculated field that segments sales into 'High' and 'Low' based on average sales.

Tableau

IF [1] > [2] THEN 'High' ELSE 'Low' END

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

A[Sales]

BAVG([Sales])

CSUM([Sales])

DCOUNT([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM([Sales]) instead of AVG([Sales]) for average.

Comparing aggregated sales to aggregated sales.

Compare each sale [Sales] to the average sales AVG([Sales]) to segment data.

5fill in blank

hard

Fill both blanks to create a calculated field that calculates percentage difference from average sales.

Tableau

([Sales] - [1]) / [2] * 100 

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

AAVG([Sales])

DABS

Attempts:

3 left

💡 Hint

Common Mistakes

Adding ABS() unnecessarily changes the meaning.

Leaving the last blank with a function causes syntax errors.

Subtract average sales AVG([Sales]) from [Sales], divide by AVG([Sales]), multiply by 100. No extra function needed at the end.