Ungroup Table Data Using the Table Settings Sidebar

You can ungroup table data using the Table Settings sidebar.

To ungroup table data using the Table Settings sidebar:

  1. If you are editing the visual in a dashboard, select Edit Visual from the visual drop-down menu. The sidebar menu for the visual appears.

    If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

  2. Select on the sidebar menu. The Table Settings sidebar for the visual appears.

  3. You can remove a field from grouping in several ways:

    1. Select and drag the field from the Groups section of the Table Settings sidebar to the Columns section.

    2. In the Groups section of the sidebar, select corresponding to the field you want removed from grouping.

    3. Select next to Edit Groups on the sidebar. The Table Settings sidebar changes and only the fields selected are listed. Then clear the checkbox next to the field you want to remove from grouping. Note that this also removes the field from the table and it must be manually added back if you want its column shown in the table.

  4. Select Apply to apply your changes to the table.

  5. Save the dashboard and visual.