Measure Options for a Metric Set
This applies to: Managed Dashboards, Managed Reports
When numeric data is first added under Measures in the Data Analysis Panel, its values are grouped and normally summed, as indicated by the displayed text SUM.
To quickly change this aggregator to another one, click this indicator and choose another from the list. For example, you can see the average order quantity for each year instead of the sum.
You can add a measure multiple times: drag the same data from Explore or click to add it again under Measures. Each copy of the measure can be set to a different aggregator (you should edit their captions to distinguish between them).
To access the full set of measure options, click its green tile or pencil icon in the Data Analysis Panel to edit it.
The dialog includes settings such as:
- Caption: Determines how this measure is identified in visualizations.
- Format: Determines how numeric data is formatted and displayed as text. See Formatting text for details on formatting.
- Missing Data Rules: These settings determine if rows or columns of data should still be displayed if there is no corresponding measure value available, and whether to fill them in with replacement values. See Handling null data points for details.
- Hidden: If you don't want to display the measure but only use it for a formula, sorting, or other metric set features, check this box to prevent the measure's values from being seen directly or exported.
Changing settings such as Caption and Format here take effect everywhere at once as long as you haven't customized a visualization setting on top of them. For example, changing the caption affects column headers and tooltips, and changing the format affects the cells of a table, chart labels, and tooltips. They will also take effect if you re-visualize the metric set.