Add a count measure to a metric set
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.
In the list of available measures you can add, scroll down to the Calculated Elements section and click <Count>.
A Count measure is added to the Data Analysis Panel and your visualization.
Next, click the Edit icon for the Count measure.
In the Configure Metric Set Element dialog, go to Configure format and check if its format is N0. If not, change it, then click the submit button at the bottom of the dialog.
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.
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.
To change the aggregator, click the Edit icon for the measure.
From the Aggregator drop-down, select Count and click the submit button at the bottom of the dialog.
- 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.