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.

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.