Change the data retrieval format for a metric set

Contents[Hide]

1. Overview

When you drag an entire database table (as opposed to a single column) from the EXPLORE window to the dashboard canvas, a metric set will be automatically generated with its data retrieval format set to Raw Data.

A metric set with the Raw Data format has limitations. For example, notifications, calculated measures and formulas are not available for these kinds of metric sets. Basically, this type of metric set is only used to preview data.

You can change the data retrieval format of a metric set by using the Data Binding Panel.

2. Raw Data versus Standard format

When the data retrieval format is Raw Data, the data is retrieved exactly as it is in the native data source. In this case, you may see duplicate rows and row numbers. However, aggregations and totals will not be available.

When the data retrieval format is Standard, measures are aggregated and totals are available. However, the data may not look exactly like the native data source.

3. Changing the data retrieval format

First, create a new dashboard. Go to the EXPLORE window, expand your data connector, and then drag a database table to the canvas.

Drag database table to canvas
Drag database table to canvas

The resulting table visualization lets you preview the data from the database table, nothing more.

Next, right click over the table visualization and select Data Binding Panel from the menu.

Select Data Binding Panel
Select Data Binding Panel

In the Data Binding Panel, click Edit.

Click Edit
Click Edit

Scroll down in the Configure Metric Set Binding dialog and look for the Data Retrieval Format dropdown.

Configure Metric Set Binding dialog
Configure Metric Set Binding dialog

Change the dropdown from Raw Data to Standard, and then click Submit.

Change the data retrieval format to Standard
Change the data retrieval format to Standard

4. Changing the format using the Metric Set Designer

If you are editing a metric set from the Metric Set Designer screen, you can change the data retrieval format from the toolbar.

Change the format from the Metric Set Designer
Change the format from the Metric Set Designer

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri