Add a count measure to a metric set

Contents[Hide]

1. Overview

This article shows you how to add a count measure to display the number of records or values behind each row or column.

2. Adding a count measure

A count measure displays the number of records making up each row or column. This can be added to any metric set except those displaying data from an OLAP cube.

Under Measures in the Data Analysis Panel, click to add a measure.

Click to add a measure
Click to add a measure

In the list of available measures you can add, scroll down to the Calculated Elements section and click <Count>.

Select the Count measure
Select the Count measure

Tip
Alternatively, you can edit an existing measure and change the Aggregator field to Count.

A Count measure is added to the Data Analysis Panel and your visualization.

Next, click the Edit icon for the Count measure.

Edit the Count measure
Edit the Count measure

In the Configure Metric Set Element dialog, go to the Format field and check if its value is N0. If not, change it, then click the submit button at the bottom of the dialog.

Check the format string for the Count measure
Check the format string for the Count measure

3. Add a hierarchy count measure

A hierarchy count measure displays the number of values of a particular hierarchy in the records behind each row or column.

To add a hierarchy count measure, drag a hierarchy (or a column of data) from the Explore window to Measures in the Data Analysis Panel.

Drag Color to Measures
Drag Color to Measures

A count measure will be automatically created and named based on the name of the hierarchy, e.g., "Color Count".

By default, the aggregator for a hierarchy count is set to Distinct Count.

Note
OLAP hierarchies support only Distinct Count and not the Count aggregator.

To change the aggregator, click the Edit icon for the measure.

Edit the hierarchy count measure
Edit the hierarchy count measure

From the Aggregator drop-down, select Count and click the submit button at the bottom of the dialog.

Change the hierarchy count aggregator
Change the hierarchy count aggregator

4. Notes

  • Automatic count measures are not supported when displaying data from an OLAP cube. The hierarchy count measures described above are supported, as well as count measures created in the OLAP cube.
  • The available aggregators for both measures and hierarchy count measures can be changed in the data cube.
  • Totals are not retrieved from OLAP when using hierarchy count measures together with top/bottom settings.

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