Measures
A measure is any string or numeric field that can be measured. The measure is the Y axis of the chart. The Measure option is grayed out and not selectable until at least one field is added to the report grid.
Add Measure
Fields that are used in the Summarize by field can also be used in the Measure field. However, date fields cannot be used as a measure. Only one measure can be configured per chart.
To add a measure:
- Type the field name into the text box for the Measure field. The list of matching fields appears as a drop-down. Select the desired field from the drop-down.
- Or, click the options drop-down in the report grid for the desired field. Then, click the Add Measure (chart) option. This adds the field as the measure, if a measure is not already added. If a measure already displays in the text box, then the existing measure is replaced with the new measure.
Remove Measure
Once a field is added as a dimension or measure, it cannot be removed from the report unless it is removed from the chart. To remove the measure from the chart, click the Remove icon in the text box.
Aggregates
The drop-down to the right of the Measure field displays the aggregates. The aggregate is automatically defined by the system when selecting the field to measure, depending on the field type added to the measure option.
The following aggregates apply to each field type:
Report Grid
Once the report is refreshed, the report grid adds a column that displays the aggregate data.