In this article we will learn how to highlights the table in tableau worksheet to do further operations.
Tableau – a brief note
Tableau could also be a really powerful data visualization tool which can be used by data analysts, scientists, statisticians, etc. to ascertain the data and acquire a transparent opinion supported the data analysis. Tableau is extremely famous because it can absorb data and produce the required data visualization output during a really short time.
Highlight Tables
- The highlight table allows us to use conditional formatting to a view of a normal table.
- Tableau will automatically apply a color scheme in either endless or stepped array of colors from highest to lowest.
- It’s great for comparing a field’s values within a row or column.
- Use highlight tables to match categorical data using color.
- Highlight tables are often outstanding as they help users quickly spot the foremost interesting values during a table of numbers.
- In cases where multiple variables are displayed, Measure Values are often used to apply one color scheme to all or any of the values in a table.
- Unless the variables are very similar, highlighting multiple variables is typically not helpful and can mislead.
Dataset used in the given examples is Dataset.
Procedure
Steps to import the dataset :
- Open Tableau tool and connect a dataset into it.
- Drag and drop the one sheet of the connected dataset.
- Click on sheet1 to open the tableau worksheet.
- On clicking Sheet1 you will get whole dataset attributes on the left side and a worksheet for work.
To create a highlight table you have to form a table first by selecting the minimum two attributes( one in row and one in column) by drag and drop then select the chart option as highlight tables.
Example 1:
- Drag and drop the fields in columns and rows to create a table.
- Select the highlight tables from “show me” option.
- Apply marks by color for a better view.
Example 2:
- Drag and drop the fields in columns and rows to create a table.
- Select the highlight tables from “show me” option.
- Apply marks by color for a better view.
- Change the border color by selecting another color in “Border“ option.
Example 3:
- Drag and drop the fields in columns and rows to create a table.
- Select the highlight tables from “show me” option.
- Apply marks by color for a better view.
- Apply quick table calculation as “percentage” for analysis.
