How Data is Organized in the Table Visual

Learn how the combination of time, metrics, and groups are organized in rows and columns.

What happens when you have time, metrics, and groups as rows

Rows can contain a combination of time, metrics, and groups. Rows will be arranged based on the following structure:

  1. Time
  2. Groups
  3. Metrics

This means the data will be organized in rows by time periods, attribute values, and then metrics.

Example: Table with metrics and groups as rows

You have a Table showing Open Requisitions and Headcount with the following structure:

  • Time as columns
  • Groups as rows in the following order:
    1. Organization
  • Metrics as rows in the following order:
    1. Open Requisitions
    2. Current Applicants
  Q1 2016
Marketing  
Open Requisitions 76
Current Applicants 324
Product  
Open Requisitions 18
Current Applicants 406

Using a nested table structure

You can add up to 4 groups as rows to create a table with different levels or nested data that you can expand or collapse.

The following table shows the structure when 3 groups have been added as rows:

  1. Organization
  2. Tenure
  3. Gender
  Q1 2016
Marketing  
1 to 2 yrs  
Man  
Woman  
0 to 1 yr  
Man  
Woman  
Product  
1 to 2 yrs  
Man  
Woman  
0 to 1 yr  
Man  
Woman  

As you go down each level, you'll see greater detail:

  • The first level contains data grouped by Organization (for example, Headcount for Marketing).
  • The second level contains data grouped by Organization and Tenure (for example, Headcount for employees in Marketing with 1 to 2 years of tenure.
  • The third level contains data grouped by Organization, Tenure, and Gender (for example, Headcount for employees who are women in Marketing with 1 to 2 years of tenure).

Reorder groups and metrics

  • In the Table settings panel, click the Move button  for the item you want to move and drag the item to the desired position.

Metrics and groups are arranged in the order they appear in the Table settings panel. In columns, the metric at the top of the list will appear in the leftmost column and the metric at the bottom of the list will appear in the rightmost column. In rows, the metric at the top of the list will appear at the top of the table and the metric at the bottom of the list will appear at the bottom of the table.

Note: Custom time periods are arranged in the order that they are added and cannot be reordered.

Hide zeros and null (N/A) values

You can hide rows that contain zeros or null values in the Chart settings panel by clicking the Settings button . For more information, see Show or Hide Data Items.