Custom table calculation scope in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the scope of the table calculation to the entire table.

Tableau

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

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

AFIRST()

BLAST()

C0, 0

D0, LAST()

Attempts:

3 left

💡 Hint

Common Mistakes

Using only FIRST() or LAST() without a range.

Using incorrect syntax like a single number.

The correct syntax to specify the scope from the first to the last row is 0, LAST(). This tells Tableau to compute the sum over the entire table.

2fill in blank

medium

Complete the code to set the partitioning of the table calculation by the [Region] field.

Tableau

WINDOW_AVG(SUM([Profit])) [1] [Region]

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

APARTITION BY

BORDER BY

CGROUP BY

DFILTER BY

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing partitioning with ordering or grouping.

Using SQL keywords that don't apply here.

In Tableau, PARTITION BY is used to define the scope or partition for table calculations, such as by [Region].

3fill in blank

hard

Fix the error in the table calculation to correctly compute the running total across [Category].

Tableau

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

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

AORDER BY [Category]

BPARTITION BY [Category]

CGROUP BY [Category]

DFILTER BY [Category]

Attempts:

3 left

💡 Hint

Common Mistakes

Using PARTITION BY instead of ORDER BY for running totals.

Using GROUP BY or FILTER BY which are invalid here.

For running totals, you need to order the data by the field, so ORDER BY [Category] is correct.

4fill in blank

hard

Fill both blanks to calculate the percent of total sales within each [Region] partition.

Tableau

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

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

APARTITION BY

BORDER BY

C0, LAST()

DFIRST(), LAST()

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing ORDER BY with partitioning.

Using incorrect window range values.

The calculation partitions by [Region] and sums over the full window from the first to last row (0, LAST()) to get the total sales per region.

5fill in blank

hard

Fill all three blanks to compute the difference from the previous row in [Sales] ordered by [Date] within each [Category].

Tableau

SUM([Sales]) - LOOKUP(SUM([Sales]), [1]) [2] [Date] [3] [Category]

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

A-1

BORDER BY

CPARTITION BY

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using offset 0 instead of -1.

Confusing ORDER BY and PARTITION BY placement.

The LOOKUP function uses offset -1 to get the previous row. The calculation orders by [Date] and partitions by [Category] to compute the difference correctly.