TABLE OF CONTENTS
- What is a metric?
- How to create custom metrics?
- Custom metrics functions
- How to access the metrics you create?
- Sample Metrics
Freshdesk Analytics has an extensive list of general helpdesk metrics as default, and custom metrics are here to create a much more curated experience for your organization. As an enterprise business, you can now create custom metrics using single arithmetic operations or even complex functions to stay on top of the metrics most relevant to your business.
Here is a brief guide to all the functions and operators you can use to get started and build your own metrics:
What is a metric?
A metric is a number property that you can measure or operate on.
Example: Tickets reopened is a metric that measures the number of times a ticket was reopened
How to create custom metrics?
- Goto Analytics tab from your left pane and click on the Settings icon on the top-right corner
- Select “Custom Metrics” from the side menu
- Click on “Create Metric” to start creating your custom metrics by using a combination of functions or operators.
- Once you come up with your formula, you can test it by clicking on 'Check syntax'. If your formula is correct, there will be a green 'Valid' that will appear to the left of the 'Check syntax' button. You can also see a preview of your result in the 'Preview' window.
- Click “Save Metric” once done
- Use this custom metric for creating widgets or wherever required
Note: Only users with edit and export access can create and modify the custom metrics.
Custom metrics functions:
You can use all the functions shown below to create and customize your existing metrics.
Function - Number
Returns the least integer greater than or equal to X
CEIL (2.5) is 3
Returns the largest integer lesser than or equal to X
FLOOR (2.5) is 2
Round the number up to nearest integer value.
ROUND (2.5) is 3
Returns the value of e (Euler's number) to the power of X
EXP (2) is 7.38906
Returns greatest value among all fields
GREATEST (1, 2, 3) returns 3
Returns least value among all fields
LEAST (1, 2, 3) returns 1
Returns the value of the natural logarithm function of X (base e logarithm of X)
LN (2) is 0.6931471805599453
Returns the value of X to the power of Y
POWER (2, 3) will return 8
Returns the value of the square root of X.
SQRT (4) will return 2
|Function - Aggregator|
Returns the average value of a numeric expression X
AVG ( Number )
Returns the maximum value of a numeric expression X
MAX ( Number )
Returns the minimum value of a numeric expression X
MIN ( Number )
Returns the sum value of a numeric expression X
SUM ( Number )
Function - Operators
How to access the metrics you create?
- Go to the Analytics Tab and select your report.
- Click on edit in the top right corner
- Search for the metric from the right pane. Choose the respective metric from the dropdown and click on Apply and add it to the widget.
- Measuring efficient tickets resolved by calculating and subtracting them from reopened tickets.
- Formula: Total(Tickets resolved) - total(tickets reopened)
- Creating a metric called actual resolution time measures the time taken to resolve a ticket after it is in ‘X’ status to the time it was resolved.
- Formula: Sum(Time spent in business hours)
- Filter: list of statuses
- Measuring the number of emails and not the number of customer interactions. Therefore the first email customer sends is the first email.
- Formula: Total(customer interactions) + 1
- Track a metric like “Total Replies,” which would be a combination of both “Agent Replies” and “Customer Replies”.
- Formula: Total Replies = Agent reply count + Customer Reply count