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.
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.
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.
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:
Numeric fields are measured by summation or averages. The following aggregates are used for numeric fields:
- Summation - This aggregate is selected by default when adding numeric fields. This is the sum of the numeric values of the field.
- Average - This is the sum of the numeric value of the field divided by the number of fields.
- Min - This is the lowest value in the range for the measure.
- Max - This is the highest value in the range for the measure.
String fields are measured by count or count unique. The following aggregates are used for string fields:
- Count - This aggregate is selected by default when adding string fields. This is a count of all the values for the field selected. For example, if User ID is added as the measure, then the chart shows the number of users with user IDs on the Y axis in relation to the field or fields that are used to summarize the chart.
- CountUnique - This is a count of all unique values returned for a field. For example, a user creates a report to show the training status for an online course. The report output returns 100 records. The training statuses for the course are Completed, In Progress, and Not Started. The training status Count for the report is 100. The training status CountUnique is 3, which represents the total number of training statuses.
As another example, a user would like to chart the number of training hours per training type. The user adds the Training Type field as the dimension and adds the Training Hours field as the measure. The chart will be summarized by each training type, and then the training types are measured by the expected training hours for each training type.
Once the report is refreshed, the report grid adds a column that displays the aggregate data.