Compute using (table across, down) in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to compute the running total across the table.

Tableau

RUNNING_SUM(SUM([Sales])) [1] 'Table Across'

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

ACOMPUTE USING

BCOMPUTE

CWINDOW_SUM

DTOTAL

Attempts:

3 left

💡 Hint

Common Mistakes

Using WINDOW_SUM instead of COMPUTE USING

Omitting the direction phrase

Using TOTAL which is an aggregation, not a direction

In Tableau, COMPUTE USING specifies the direction for table calculations like running total.

2fill in blank

medium

Complete the code to compute the percent difference down the table.

Tableau

ZN(SUM([Profit])) [1] 'Table Down'

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

AWINDOW_AVG

BTOTAL

CWINDOW_SUM

DCOMPUTE USING

Attempts:

3 left

💡 Hint

Common Mistakes

Using WINDOW_AVG instead of COMPUTE USING

Not specifying the direction

Using TOTAL which is not for direction

COMPUTE USING is used to specify the direction for table calculations like percent difference.

3fill in blank

hard

Fix the error in the code to compute the moving average across the table.

Tableau

WINDOW_AVG(SUM([Sales])) [1] 'Table Across'

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

ACOMPUTE

BCOMPUTE USING

CWINDOW_SUM

DTOTAL

Attempts:

3 left

💡 Hint

Common Mistakes

Using COMPUTE without USING

Using WINDOW_SUM instead of WINDOW_AVG

Omitting the direction phrase

The correct syntax uses COMPUTE USING to specify the direction for the window average.

4fill in blank

hard

Fill both blanks to compute the running total down the table with correct syntax.

Tableau

RUNNING_SUM(SUM([Sales])) [1] [2]

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

ACOMPUTE USING

B'Table Down'

C'Table Across'

DWINDOW_SUM

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping 'Table Across' and 'Table Down'

Using WINDOW_SUM instead of COMPUTE USING

Omitting one of the phrases

Use COMPUTE USING followed by 'Table Down' to specify the direction for running total down the table.

5fill in blank

hard

Fill all three blanks to compute percent difference across the table with correct syntax.

Tableau

ZN(SUM([Profit])) [1] [2] [3]

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

ACOMPUTE USING

B'Table Across'

CPERCENT_DIFFERENCE

D'Table Down'

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up 'Table Across' and 'Table Down'

Omitting the calculation type

Using WINDOW_SUM instead of PERCENT_DIFFERENCE

The syntax requires COMPUTE USING to specify direction, 'Table Across' for direction, and PERCENT_DIFFERENCE as the calculation type.