A highlight table is a visualization that uses color to identify values of interest. In this video, learn how to create a highlight table.
[Instructor] - You can create many different types of visualization in Tableau but what I wanted to do in this movie, was show you a specific type of Viz that you might not use that much. That vizualization type is the highlight table. And it uses color to display the relative proportion of values that appear in the cells of a table. I'll demonstrate how to create this type of visualization using the 10-05 highlight workbook. You can find that in the chapter ten folder of the exercise files collection. The basis of a highlight table is a regular text table. So I'll go ahead and create one now. I'll start by dragging a product category to the rows shelf. And then let's use order total as our data. So there I have a standard text table. To change it to a highlight table, I'll go to the show me task pane and then over on the right side of the top level, there is the highlight table button. I'll go ahead and click that and click show me to close that. And you can see that the visualization uses a color scale to indicate the relative value within each cell. The largest has the darkest blue color here, it's almost two and a half million and the lightest color, this sort of light greenish blue, just over ninety thousand is at the top. You can see the color scale that's used over on the right side here. And this shows the minimum and maximum values and the color that is used within the range between them. You can add other dementions, for example, if I wanted to use order date, by column. Then I could drag order date to the column shelf and there we have the values broken down. And you can see that they are still ranked by color except that the scale has changed from 18,000 to 1.27 million but the color range is still the same. If you want to change the colors you can go to the marks card. Click color, then click edit colors. In here you can select from a number of built in pallets. So click the pallet buttons control, and lets say we want to go to green. So we are now based on green instead of blue. I'll click OK and there are the values. I use highlight tables in my own presentations but I especially use them in dashboards. The difference in shading highlights the differences in values within the body of the table.
- Explain where a user would navigate to seek specific help in Tableau.
- Determine the best approach for using Excel in Tableau.
- Interpret how to use the features and functions of Tableau when creating charts.
- Describe how best to manage data in a worksheet or visualization.
- Explain how to create a selection filter for certain values.
- Explain how to manage data for different chart formats.
Skill Level Beginner
1. Introducing Tableau
2. Managing Data Sources and Visualizations
3. Managing Tableau Worksheets and Workbooks
4. Creating Custom Calculations and Fields
5. Analyzing Data
6. Sorting and Filtering Tableau Data
7. Defining Groups and Sets
8. Creating and Pivoting Crosstabs
9. Creating Basic Visualizations
10. Formatting Tableau Visualizations
11. Annotating and Formatting Visualizations
12. Mapping Geographic Data
13. Creating Dashboards and Actions
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.