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 displays each original row of data without aggregating, and has limitations. For example, notifications, calculated measures and formulas are not available for these kinds of metric sets.

You can change the data retrieval format of a metric set by using the Data Analysis 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, and aggregations and totals will not be available.

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

Note
When the Data Retrieval Format is set to Raw, data will ignore the data cube storage type and be retrieved from the original database.

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 the table visualization and select Data Analysis Panel from the menu.

Select Data Analysis Panel
Select Data Analysis Panel

In the Data Analysis Panel, click Edit.

Click Edit
Click Edit

Scroll down in the Metric Set Binding Configuration dialog and look for the Data Retrieval Format drop-down.

Metric Set Binding Configuration dialog
Metric Set Binding Configuration dialog

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

4. Changing the format when editing a metric set full-screen

If you are editing a metric set full-screen, you can change the data retrieval format from the toolbar.

Change the format in the metric set editor
Change the format in the metric set editor

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