Modify Pivot Table Rows

This applies to: Visual Data Discovery

To modify pivot table rows:

  1. Edit the pivot table you want to modify. See Edit Visuals.

  2. If you are editing the visual in a dashboard, select Settings 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.

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

    Use this area to define row groups, column groups, metrics, totals, and display settings

  4. To modify the rows in the pivot table:

    • Select in the Rows area of the Pivot Table Settings sidebar. The sidebar changes to show all the possible rows for the table.

    • Select the rows you want to add and clear the ones you want to remove. If you want to select all the rows, select Select All.

      Use the search bar to search for a field in the table. Use the buttons under the search bar to limit the fields you see in the list.

      Select To
      See all available fields.
      Limit the field list to the available attributes.
      Limit the field list to the available numeric metrics.
      Limit the field list to the available date and time fields.

    • After all row fields are selected, select Apply.

    If the field you select is a time field, you can modify its granularity and indicate whether or not blanks (even time intervals) should be included in the time field values.

  5. If your pivot table displays a lot of data horizontally, you may need to unfreeze the horizontal scroll bar. By default, this scroll bar is frozen. To unfreeze the horizontal scroll bar, slide the Freeze Rows slider in the Rows section of the Pivot Table Settings sidebar to the left (off). The horizontal scroll bar will appear and be useable.

  6. Enable or disable Span Duplicate Rows to group repeating row groups.

  7. Select Apply to apply your changes to the pivot table.

  8. Save the dashboard.