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
A data table in a dimensions, metrics, and calculated metrics. Select at least one dimension and one metric to create a table.
is created fromConfiguring a data table allows you to then achieve the following goals:
-
Add the data table to a dashboard as a table .
-
Use the data table as the basis for creating a visualization
. -
Export the data in a data table in CSV format to analyze it in other tools.
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
-
Select the workspace you work with in Adverity and then, in the , click Data Explorer.
-
At the top of the page, select the View tab that contains the .
Configuring the table
To configure the data table, follow these steps to adjust the data table settings to suit your needs:
-
Configure the settings for the fields displayed in the data table. For more information, see Configuring fields in data tables.
-
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.
-
-
Click to add a total row to the data table. For more information, see Adding total rows to table widgets.
-
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.
-
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
-
-
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 , follow these steps:
-
In the top right of the page, click Add to dashboard.
-
Click Add as table.
-
(Optional) In Widget name, rename the .
-
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.
-
-
Click Add.
As a result, the data table has been added to a dashboard as a table .
Exporting data from a data table
To export the data displayed in a data table in CSV format, follow these steps:
-
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:
-
Create and configure a visualization. For more information, see Creating visualizations.
-
Use the table dashboard. For more information, see Introduction to the Dashboards page.
in a