Tooltip customization in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to insert a field value into the tooltip.

Tableau

<Tooltip>
  <p>Sales: [1]</p>
</Tooltip>

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

ASUM(Sales)

BAGG(Sales)

CSUM([Sales])

D[Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Using angle brackets incorrectly

Omitting square brackets around field names

Using AGG instead of SUM

In Tableau, to show the sum of Sales in a tooltip, you use SUM([Sales]).

2fill in blank

medium

Complete the code to add a calculated field to the tooltip showing profit ratio.

Tableau

<Tooltip>
  <p>Profit Ratio: [1]</p>
</Tooltip>

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

AAVG([Profit]) / AVG([Sales])

BSUM([Profit]) / SUM([Sales])

C[Profit] / [Sales]

DSUM([Sales]) / SUM([Profit])

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing numerator and denominator

Using averages instead of sums

Not aggregating fields

The profit ratio is calculated as total profit divided by total sales, so use SUM([Profit]) / SUM([Sales]).

3fill in blank

hard

Fix the error in the tooltip calculation to show average discount percentage.

Tableau

<Tooltip>
  <p>Avg Discount: [1]%</p>
</Tooltip>

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

ASUM([Discount%])

BSUM([Discount]) / COUNT([Discount]) * 100

CAVG([Discount%])

DAVG([Discount]) * 100

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG

Using a non-existent field with % in the name

Not multiplying by 100

To show average discount as a percentage, multiply the average discount by 100 using AVG([Discount]) * 100.

4fill in blank

hard

Fill both blanks to create a tooltip that shows sales and profit with currency formatting.

Tableau

<Tooltip>
  <p>Sales: [1]</p>
  <p>Profit: [2]</p>
</Tooltip>

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

ASTR(SUM([Sales]))

BFORMAT(SUM([Profit]), '$#,##0')

CFORMAT(SUM([Sales]), '$#,##0')

DSTR(SUM([Profit]))

Attempts:

3 left

💡 Hint

Common Mistakes

Using STR instead of FORMAT

Formatting only one field

Omitting currency symbol

Use FORMAT to display sums with currency symbols and commas: FORMAT(SUM([Sales]), '$#,##0') and FORMAT(SUM([Profit]), '$#,##0').

5fill in blank

hard

Fill all three blanks to create a tooltip showing category, total sales, and average profit margin.

Tableau

<Tooltip>
  <p>Category: [1]</p>
  <p>Total Sales: [2]</p>
  <p>Avg Profit Margin: [3]%</p>
</Tooltip>

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

A[Category]

BSUM([Sales])

CAVG([Profit Margin])

DCOUNT([Category])

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT for category

Not aggregating sales or profit margin

Using wrong field names

Show the category field as is, total sales as sum, and average profit margin as average: [Category], SUM([Sales]), AVG([Profit Margin]).