Your standard calculated metrics in Explore are dynamic. They can recalculate based on the attributes used, date periods specified, and filters applied (see Standard calculated metrics). However, if you are comparing across categories or benchmarking, you might want the calculation to remain constant. To achieve this, you can use *fixed calculated metrics*.

## Creating a fixed calculated metric

At the most simple level fixed calculated metrics can be used to produce unchanging metric results. For information on more complex uses, see Creating a constant average using fixed calculated metrics.

**To create a fixed calculated metrics**

- Open the Calculation engine menu in the Query Builder.
- Select
**Fixed calculated metric**. - Enter a name for the metric.
- Select either the Simple or Advanced option for creating a calculated metric.
The Advanced option enables you to type a formula in the same way as a standard calculated metric (see Standard calculated metrics and attributes). The Simple option does not require you to enter any formulas.

- Select a metric from the
**Will always return the value of this metric**drop-down list. For example, to compare the number of tickets tagged support, select # Tickets. - Check any computing options to apply. There are two available:
**Computer according to the filters in the query**restricts results to your applied filters. If you do not select this, the fixed calculated metric will not be affected by your result manipulations.**Restricted for the values of an attribute**restricts results to a specific attribute's values. If you do not select this, the fixed metric will not be divided by any attribute.

- Click
**Save**when you are finished.

## Creating a constant average using fixed calculated metrics

### Creating your fixed calculated metrics

You will need to create two fixed calculated metrics to use in your average calculation. The first calculated metric will return a fixed number of replies and the second will return the fixed number of month values.

**To create a fixed replies calculation**

- Select the
**Fixed calculated metric**option in the Calculation engine menu. - Enter a name for your metric. This example uses Fix Replies.
- Select the metric you would like in your fixed average from the
**Will always return the value of this metric**drop-down list. This example uses the Replies metric. - Click
**Save**.

**To create your fixed number of months metric**

- Select the
**Fixed calculated metric**option in the Calculation engine menu. - Click on the
**Advanced**button. - Enter the name for your second fixed metric. This example uses Fix n Month.
- In the Formula box enter DCOUNT_VALUES.
- Select the attribute to use in your constant average from the
**Fields**drop-down list. This example uses the attribute MONTH(Ticket Created At).Note: You must manually select your elements from either the**Fields**drop-down list or select Explore's auto-correct results. - Click
**Save**.

### Creating your standard calculated metric

After you have created your fixed calculated metric, you can create your average metric. This example uses a standard calculated metric.

**To create your constant average comparison**

- Select the
**Standard calculated metric**option in the Calculation engine menu. - Enter a name for your average. This example uses Monthly Average Replies.
- Select your first fixed calculated metric from the
**Fields**drop-down list. - Type the division / sign.
- Select your second fixed calculated metric from the
**Fields**drop-down list. - Click
**Save**. - Add your standard calculated metric to your report as a trend line (see Adding metrics as trend lines).

You will now be able to see how your monthly replies compare against the average. Your report should resemble the image below:

## Comments

0 comments

Please sign in to leave a comment.