Skip to main content Join the Agentforce Hackathon on Nov. 18-19 to compete for a $20,000 Grand Prize. Sign up now. Terms apply.

Your browser is too small

Please resize your browser to be able to continue your interactive learning. We recommend at least 900px width.

+100 points
~15 mins

Learning Objectives

After completing this unit, you’ll be able to:

  • Update mark labels to ensure appropriate colors in your viz.
  • Format numbers for straightforward communication.
  • Configure Tooltips to communicate details.

Check: Connect Your Tableau Public Account

If you haven’t already, or if the playground has timed out, log into your Tableau Public account in the Playground window to the right. If you don’t already have a Tableau Public account, sign up for one now, and be sure to activate your account before starting this interactive unit. You can find more detailed instructions in The Tableau Data Model.

Note

The playground resets if your Tableau Public login session expires or if you refresh the page before completing the unit. We recommend completing this unit in one sitting.

In the last unit, you used SUM(MyRating) on color and got the right result. This is because the rating is a single value for that mark, so the sum and average are the same. However…

Is it a good best practice to leave SUM for the color field as we explore the data?

Nope. If you change this viz in a way that changes the level of detail (for example, removing Episode from Detail to look at season-level trends), the SUM becomes an inaccurate aggregation. It’s safer to change it to AVG even when it's excessive, just to prevent mistakes down the line.

Futureproof Your Setup

Rather than change the aggregation again on a pill, let's change the default aggregation instead.

  1. Make sure you're on the Ratings Per Episode sheet.
  2. Drag SUM(My Rating) off the Marks card.
  3. Right-click the My Rating field in the Data pane and select Default Aggregation | Average. Tip: If you’re not sure what table to expand to find a field you want, try using the search bar.
  4. Drag My Rating from the Data pane to the Color shelf. Now every time you use that field, the pill is an average.
  5. But you need to reapply the purple and gold palette (because you applied it to SUM rather than AVG). Click the Color property on the Marks card.
  6. Click Edit Colors.
  7. Then, choose the Gold-Purple Diverging option from the dropdown.
  8. Finally, close the dialog.

Communicate Small Differences

While color is good for examining overall trends (and it looks good!), a gradient like this isn’t good at conveying small differences or for users with low vision. Let’s encode the specific ratings as mark labels.

  1. Drag My Rating from the Data pane to Label on the Marks card. Hmm, this is too overwhelming. Let’s format the number to only show one decimal place.
  2. Right click the AVG(My Rating) pill on the Marks card (either one works).
  3. Click Format number…
  4. Choose Number (Custom).
  5. Change the Decimal Places to 1, then click out of the formatting window.

Now you see the rating like 8.1, but the viz is still pretty busy. If you hover over a mark in the viz now, you see the default tooltip—you can keep the information there, instead. The tooltip is also a good place to put secondary information that isn't already in the viz, like Theme.

  1. Drag the AVG(My Rating) pill with the T icon off the Marks card. Tip: Make sure it’s the pill for the label, not color.
    • Use Undo in the toolbar to go back and try again if you make a mistake.
  2. Drag Theme from the Data pane to Tooltip on the Marks card Tooltip icon
    • Remember to use the search bar in the Data pane if you can't find a field.
  3. Click the Tooltip shelf on the Marks card to bring up the Edit Tooltip dialog.
  4. Delete what's there to start from scratch.
  5. Type Week and add a space after it.
  6. Click Insert and choose Episode. This inserts the field name in angle brackets, indicating it's a dynamic value that will be filled in from the data.
    • Note: Only fields used in the viz or explicitly added to the Tooltip shelf are available for inserting.
  7. Type a space, then (Season again, with a trailing space.
  8. Insert | Season, then type a closing parenthesis )
  9. Type Enter twice to start a new line.
  10. For the next line, type:
    • The theme was and add a space.
    • Then, insert ATTR(Theme) with another space after that.
    • Then, type and the average rating was and add another space.
    • Then, insert AVG(My Rating).
  11. OPTIONAL: You can play around with font, color, size, and spacing to format the appearance of the tooltip.
    • For example, make Week <Episode> size 14 and bold, and make both the inserted theme and ratings bold and italic.
    • Tip: to format an inserted value, simply click inside the brackets and make the change, such as making the text bold.
  12. Click OK.

Hover over a mark in the view to see the new tooltip.

Tooltip displaying Week 6 (Season 1); The theme was Final and the average rating was 7.7. in the formatting described above.

Resources