Creating and editing metrics

Create, edit, or delete metrics from the metrics page. Metrics are based on filtered table data, and you work with new or existing metrics from the same page.

Create a metric

Open the metrics page, filter the data in the table, and then configure a new metric based on the filtered data.

Navigate to the new metric

1. Open the Results app.
2. Open the collection that contains the table you want to work with.
3. For the table you want to create a metric on, click the number in the Metrics column.
4. Click New.

Filter the table data

Configure the metric

1. To open the Configure Metric panel, in the upper-right corner, click Configure .
2. In the Configure Metric panel, from the Measure Field list, select the column that the metric is based on.

   To format the display of the metric value, click Format Options and specify any of the following:

   • numeric format
   • rounding rule
   • conditional formatting
3. Complete the following fields and then at the upper right of the page, click Save:

   Field	Description
   Date/Datetime Range	Defines the temporal range of the metric calculation. By default, the field is set to Published, however you can specify an alternative date or datetime field.
   Period	Summarizes the metric into one of the following periods: daily monthly quarterly yearly
   Function	Defines the aggregate function to use in the metric calculation. Different functions are available for each data type, and you can select: an absolute measure such as Average or Blank Tip The result of the absolute calculation is previewed next to the function name. the % of Total function to measure the percentage of records that satisfy a condition that you define by selecting an operator and then entering a value to test against:
   Name	Sets the name of the metric. By default, the metric is named functionName of measureFieldName, however you can rename the metric using a custom name of your choosing.
   Type	Tags the metric as one of the following indicator types: Key Performance Indicator Key Risk Indicator Key Control Indicator Other metric
   Base Color	Sets the color of the metric when the calculation does not exceed the threshold.

Set a trigger on the metric

Once you configure a metric, set one or more triggers to monitor the metric's performance and notify key stakeholders.

For more information, see Triggering actions from metrics.

Edit an existing metric

Open the metrics page, select an existing metric, and change the configuration.

1. Open the Results app.
2. Open the collection that contains the table you want to work with.
3. For the table you want to edit metrics from, click the number in the Metrics column.
4. From the list of metrics, select the metric you want to view.
5. In the Configure Metric panel, edit the metric configuration and then on the Metrics toolbar, click Save. For more information about editing the metric, see Configure the metric.
6. When you are done editing, do one of the following:
   • To save your changes and overwrite the existing metrics configuration, click Save > Save.
   • To save your changes as a new metric:
     • Click Save > Save As.
     • Enter a name for the metric and click Save.

Rename a metric

Open the metrics page, select an existing metric, and change the name.

1. Open the Results app.
2. Open the collection that contains the table you want to work with.
3. For the table you want to edit metrics from, click the number in the Metrics column.
4. From the list of metrics, select the metric you want to rename.
5. On the Metrics toolbar, click More Actions and select Rename. Enter a new name for the metric and click Save.

Delete a metric

Open the metrics page, select an existing metric, and then delete it.

1. Open the Results app.
2. Open the collection that contains the table you want to work with.
3. For the table you want to delete metrics from, click the number in the Metrics column.
4. From the list of metrics, select the metric you want to delete.
5. On the Metrics toolbar, click More Action and select Delete.