Configuring data tables

This guide explains how to configure a data table in order to add it to a dashboard, use it to create visualizations, and export the data.

Introduction

Configuring a data table allows you to then achieve the following goals:

  • Add the data table to a dashboard as a table widget.

  • Use the data table as the basis for creating a visualization widget.

  • Export the data in a data table in CSV format to analyze it in other tools.

A data table is created from dimensions, metrics, and calculated metrics. Select at least one dimension and one metric to create a table.

Prerequisites

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

The dimensions and metrics you have selected are shown in the data table.

Procedure

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Data Explorer.

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

Configuring the table

To configure the data table, follow these steps to adjust the data table settings to suit your needs:

  1. Configure the settings for the fields displayed in the data table. For more information, see Configuring fields in data tables.

  2. Click to enable or disable the tree structure for the data table.

    The tree structure is built based on the order of the dimensions in the Dimensions section.

    For example, you add the following dimensions in order:

    • Datasource

    • Campaign State

    • Campaign

    The fields in the data table will be in the following tree structure:

    • Datasource

      • Campaign State

        • Campaign

    For more information, see Reordering fields in a table.

  3. Click to add a total row to the data table. For more information, see Adding total rows to table widgets.

  4. Click to limit the number of rows displayed for the first dimension. For an example of limiting the number of rows, see Creating pie chart widgets.

  5. Click to add empty rows to fill the time gaps within the selected date range. To do so, click Fill time gaps with empty rows and select one or more of the following options:

    • Before existing data

    • Between existing data

    • After existing data

    • Limit until today

  6. Click to add an Exclude filter for undefined rows of the first dimension.

Adding the data table to a dashboard

To add the data table to a dashboard as a table widget, follow these steps:

  1. In the top right of the page, click Add to dashboard.

  2. Click Add as table.

  3. (Optional) In Widget name, rename the widget.

  4. Choose one of the following options:

    • Click Add to existing dashboard and select the dashboard to which you want to add the data table.

    • Click Add to new private dashboard and enter a name for the new dashboard to which you want to add the data table.

  5. Click Add.

As a result, the data table has been added to a dashboard as a table widget.

Exporting data from a data table

To export the data displayed in a data table in CSV format, follow these steps:

  1. Above the data table, click Download as CSV. A download will start automatically.

When exporting data from a data table, please note:

  • The CSV file is limited to 10,000 rows.

  • All filters applied to the data table when you export the data (e.g. dimension and metric filters) will also apply to the data in the CSV file.

What's next?

Once you have created a data table, continue to the following steps: