How to group rows in Tableau into bands

0 votes

I'm new to tableau and I'm having trouble with the following. Here's an example of the data I'm working with.

Count | Item
___________________
 1            A
 3            B
 2            C
 3            D
 5            E
 2            F
 5            G
 9            H

I'm attempting to combine some of them together so that I may display a stacked bar chart of these groupings, as shown below:

 Count | Item
    ___________________
     6            A-C
     10            D-F
     14            G-H

How to do this?

Mar 29, 2022 in Tableau by Vaani
• 7,020 points
1,214 views

1 answer to this question.

0 votes

Use Tableau's built-in Create Group feature

View and download the solution workbook on Tableau Public: https://public.tableau.com/profile/fosstin#!/vizhome/HowtoGroupYourDatainTableau/Dashboard-HowtoGroupYourData

1. Create a group by right-clicking the Item dimension and selecting Create > Group. The Create Group dialogue box will appear.
2. Enter a name for your grouped dimension in the Area Name text field at the top of the window, or use Tableau's default title, Item (group)
3. Click the Group button after selecting the first set of letters you want to group. Hold down the control or shift key to select several rows.
4. Press enter after giving the group a name (for example, A-C).
5. To make the D-F and G-H groupings, repeat steps 5 and 6, then click OK.
6. In the Marks card, drag the Item (group) dimension to the Rows shelf and the Count measure to Text.

7. Double-click Measure Values in the data window to add a column header to the Count column.
8. Format the Measure Values pill on the Marks card by right-clicking it. Then select Numbers > Number in the formatting box (Standard)

References:
Tableau Help: Group Your Data
https://help.tableau.com/current/pro/desktop/en-us/sortgroup_groups_creating.htm#create-a-group-from-a-field-in-the-data-pane

Tableau.com Blog: The one-click trick for create headers for single-measure tables
https://www.tableau.com/about/blog/2015/11/how-create-fast-headers-single-measure-tables-45945

answered Apr 5, 2022 by Neha
• 9,060 points

Related Questions In Tableau

0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,560 points
6,513 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 9, 2018 in Tableau by ffdfd
• 5,550 points
4,407 views
0 votes
1 answer

How to combine rows with same information in Tableau

@Ghost, Tableau has a function RANK_UNIQUE which you ...READ MORE

answered May 25, 2018 in Tableau by Atul
• 10,240 points
7,205 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,393 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
323 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
336 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
406 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
394 views
0 votes
1 answer

How to combine 3 histograms into 1 graph in Tableau?

For combining all the 3 histograms, when ...READ MORE

answered Apr 12, 2022 in Tableau by Neha
• 9,060 points
1,112 views
0 votes
1 answer

How to upload data to Tableau Server in Python

Then install the tableau-api-lib utility for Python ...READ MORE

answered Mar 4, 2022 in Tableau by Neha
• 9,060 points
1,797 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP