Why table calculations compute across the view in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify how table calculations compute across the view in Tableau.

Tableau

WINDOW_SUM(SUM([Sales])) [1]

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

AOVER()

BPARTITION BY [Region]

CORDER BY [Date]

DINCLUDE [Category]

Attempts:

3 left

💡 Hint

Common Mistakes

Using PARTITION BY which segments data instead of computing across the whole view.

Using ORDER BY which sorts data but does not define the computation scope.

In Tableau, table calculations compute across the view by default using the OVER() function, which means they consider the entire partition or view.

2fill in blank

medium

Complete the code to calculate a running total that computes across the view.

Tableau

RUNNING_SUM(SUM([Profit])) [1]

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

AOVER()

BPARTITION BY [Category]

CORDER BY [Region]

DWINDOW_AVG([Profit])

Attempts:

3 left

💡 Hint

Common Mistakes

Using PARTITION BY which limits the calculation to segments.

Using WINDOW_AVG which calculates average, not running total.

The OVER() function allows the running total to compute across the entire view without partitioning.

3fill in blank

hard

Fix the error in the table calculation to compute percent of total across the view.

Tableau

SUM([Sales]) / [1]

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

ATOTAL(SUM([Sales]))

BRUNNING_SUM(SUM([Sales]))

CWINDOW_SUM(SUM([Sales]))

DSUM([Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using TOTAL which is a quick table calculation but may not work in all contexts.

Dividing by SUM([Sales]) which is the current row's value, not the total.

The WINDOW_SUM(SUM([Sales])) computes the total sales across the view, which is needed to calculate percent of total.

4fill in blank

hard

Fill both blanks to compute the moving average across the view ordered by date.

Tableau

WINDOW_AVG(SUM([Sales]), [1], [2])

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

A-2

B0

C2

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using only positive numbers which limits the window to future rows.

Using zero for both start and end which computes only the current row.

The moving average window is set from 2 rows before (-2) to 2 rows after (2) the current row, computing across the view ordered by date.

5fill in blank

hard

Fill all three blanks to compute the rank of sales across the view partitioned by region and ordered descending.

Tableau

RANK_UNIQUE(SUM([Sales]), [1], [2], [3])

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

A'desc'

B'asc'

C'region'

D'table'

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'asc' when descending order is needed.

Not partitioning by region which ranks all data together.

Using wrong scope like 'cell' instead of 'table'.

The rank is computed descending ('desc'), partitioned by 'region', and computed across the entire table ('table').