What is Tableau Group?

A Tableau Group is a set of multiple members combined in a single dimension to create a higher category of the dimension. Tableau allows the grouping of single-dimensional members and automatically creates a new dimension adding the group at the end of the name. Tableau does not do anything with the original dimension of the members.

In this tutorial, you will learn-

Sort data:

Data present in the visualization and worksheet can be sort based on the requirement. It can sort the data based on data source order, ascending, descending or depend on any measured value.

The procedure for sorting is given as follows.

Step 1) Go to a Worksheet and drag a dimension and measure as given in the image.

How to sort data in Tableau

It creates a bar chart by default. Category Present in the visual is sorted based on data source order by default. We can change the sort order by following the below procedure.

Step 2)

  1. Right click on Category.
  2. Select 'Sort' option.

Sorting data in Tableau

It opens the Sort window. The options present inside the sort window is explained as follows.

How to sort data in Tableau

Sort Order:

  • Ascending: It sorts the order of selected dimension in ascending order.
  • Descending: It sorts the order of selected dimension in descending order.

Sort by:

The field can be sorted by different types of methods. It is explained as follows.

Data Source order It sorts the field based on data source order.
Alphabetic It sorts the field based on the alphabetic order.
Field It sorts the field based on other dimension or measure values.
Manual The user can manually sort the data using this option.

In this example, the category is sorted based on another field namely 'Sales.'

Step 1: In this window,

  1. Click on 'Field' radio button.
  2. Select the field on which the category is to be filtered.
  3. Select the aggregation type.
  4. Click on OK.

Sorting data in Tableau

The above example filters the category field based on the sum of sales in ascending order.

It sorts the data as shown in the figure.

How to sort data in Tableau

Create Groups:

Group is used to combine members present in a field. For example, aggregated values of 'Furniture' and 'Office Supplies' can be obtained by using group. Once the grouping data in Tableau is done, aggregated value of 'Furniture' and 'Office Supplies' can be shown in the visuals. The procedure to Group Data in Tableau is given as follows.

Step 1)

  1. Right-click on the dimension 'Category'.
  2. Click on 'Create' option.
  3. Select 'Group' option.

How to create Groups in Tableau

Step 2) It opens the 'Create group' window.

  1. Type the name of the group data in Tableau.
  2. Select the members to be grouped.
  3. Click on 'Group 'button.

Creating Groups in Tableau

Step 3) In Edit Group Window,

1. It creates groups in Tableau of 'Furniture' and 'Office supplies'.

2. Click on Ok to create the group.

How to create Groups in Tableau

It created a group in Tableau with the name of Category (Group) and added in the dimension list. This can be used for visualizing the group by in Tableau method for members present in a field.

The following image explains the functionality of Tableau create group. The sum of sales is visualized for both furniture and office supplies for grouping in Tableau.

Creating Groups in Tableau

Create Hierarchy:

Hierarchies can be building in Tableau to visualize the data in granular level. Tableau hierarchies can be created by following the given steps.

Step 1) Go to a worksheet.

  1. Select a dimension to create a hierarchy. Right-click on the dimension.
  2. Select 'Hierarchy' option.
  3. Click on 'Create hierarchy' option.

How to Create Hierarchy in Tableau

Step 2) It opens the 'Create Hierarchy' Window.

  1. Enter a name for hierarchy.
  2. Click on OK.

Creating Hierarchy in Tableau

It creates a Hierarchy as shown in the image.

How to Create Hierarchy in Tableau

You can add another field to the box and create the hierarchy. In this example, the city is added into a country hierarchy.

Creating Hierarchy in Tableau

Build Sets:

Sets create a set of members out of the field present in a data set. It acts as a separated field or dimension. The procedure to build sets is given as follows.

Step 1) Go to a Worksheet.

  1. Right-click on a dimension.
  2. Select 'Create' option.
  3. Click on 'Set' option.

How to Build Sets in Tableau

Step 2) It opens 'Create Set' Window.

  1. Name the set to be created.
  2. Select the members needs to be added in the set.
  3. Click on OK.

Building Sets in Tableau

This creates a set of the given name.

Summary:

  • Users can sort the fields present in the data set.
  • Tableau groups can be built to group the members present in a dimension.
  • Users can build hierarchy to show the granularity level present in the dataset.
  • Sets can be created to select or exclude one or more members from a field. A set can be added as a separate dimension in Tableau.

 

YOU MIGHT LIKE: