Advance with Assist: Ungroup Column Headers That Have Concatenated

Data

Advance with Assist: Ungroup Column Headers That Have Concatenated

Advance with Assist shares quick solutions to common challenges encountered by the InterWorks Assist on-demand team.

Question: I’m building a simple report for my manager. As I add new fields into the report, the first few dimensions that I’ve added are grouping together into a single column. They are separated by commas. I’ve tried adding width to the screen, but that doesn’t help. What have I done?

Using Sample Superstore data, the image below is similar to what the client was seeing:

table layout in Tableau with concatenated headers

As you can see, the first column has three options separated by commas. Upon further investigation, the column also includes Ship Mode and Category:

column options in Tableau

If you have a report that you know will need a lengthy list of dimensions, it’s important to understand Tableau’s defaults for table layouts and how to change them. Table Layout is located in Analysis > Table Layout > Advanced:

table layout navigation in Tableau

Here, you will see a variety of settings that you can change. For this question, the key was changing the default Rows options from six to the number needed for the dimensions they wanted to display (up to the maximum of 16):

table options in Tableau

There are also options for the following:

  • When there is a vertical axis to show at the bottom of the view
  • Orientation options for labels at the bottom of the view
  • Default number formatting options
  • Aspect ratio horizontal to vertical where needed

More About the Author

Dustin Wyers

Analytics Consultant / Assist Lead - East
Advance with Assist: Connectionless Failure Error in Tableau Server Question: I’ve published my data source to Server and set the refresh schedule, but the refresh keeps failing with the error message ...
Advance with Assist: Ungroup Column Headers That Have Concatenated Question: I’m building a simple report for my manager. As I add new fields into the report, the first few dimensions that I’ve added ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK