Managing tables

This reference explains how to manage the columns in a table.

Introduction

Create tables from the following column types:

• Dimensions

• Metrics

• Calculated Key Performance Indicators (calculated KPIs). Calculated KPIs are also displayed in green but marked with the icon. For more information, see Creating widgets with calculated KPIs.

Find these column types in Explore on the left side of the page in the Dimensions & Metrics panel. The columns are listed below the data sources. The list of available columns is determined by the data transferred to Explore & Present. The default groups Adverity and Time contain a set of predefined columns.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

• Create a datastream. For more information, see Introduction to collecting data.

• Apply the correct Data Mapping for your datastream. For more information, see Introduction to harmonizing data.

• Transfer data from this datastream to Explore & Present.

Adding columns to a table

To add columns to a table, follow these steps:

1. In the platform navigation menu, click Explore.

2. Select the workspace you work with in Explore & Present.

3. Click a data source to see the list of available columns.

4. Click the column name to add it to the table.

The selected columns are displayed in the Dimensions (highlighted in blue) and Metrics (highlighted in green) panels in the main section of the page.

When you select more than one dimension for the table, both dimensions are displayed in a nested format. The parent-child structure is determined by the order of the dimensions in the Dimensions field. The first dimension is the parent and the following dimension is the child.

For example, you add the following dimensions in order:

• Datasource

• Campaign State

• Campaign

The columns of the table have the following nested structure:

• Datasource

  • Campaign State

    • Campaign

Rearranging columns in a table

To rearrange the columns in a table widget, follow these steps:

1. In the platform navigation menu, click Explore.

2. Select the workspace you work with in Explore & Present.

3. At the top of the page, select the View tab that contains the widget.

4. Find the column in the Dimensions field or the Metrics field.

5. Drag the column into the new position.

Removing columns from a table

To remove a column from a table widget, follow these steps:

1. In the platform navigation menu, click Explore.

2. Select the workspace you work with in Explore & Present.

3. At the top of the page, select the View tab that contains the widget.

4. Find the column in the Dimensions field or the Metrics field.

5. Click the column to see additional options.

6. Click Remove.

Transposing dimensions

Transposing a dimension converts the values within the dimension from rows into columns. Transposed dimensions are displayed as sub-columns underneath each metric.

Prerequisites

To transpose a dimension, create a table which satisfies the following:

• The table has at least two dimensions.

• The table has at least one metric.

Procedure

To transpose a dimension in a table widget, follow these steps:

1. In the platform navigation menu, click Explore.

2. Select the workspace you work with in Explore & Present.

3. At the top of the page, select the View tab that contains the widget.

4. Find the dimension in the Dimensions field.

5. Drag the dimension to the furthest right position within the Dimensions field.

6. Click the dimension to see additional options.

7. Click Transpose.