Menu

Expand
Rate this page:

Thanks for rating this page!

We are always striving to improve our documentation quality, and your feedback is valuable to us. How could this documentation serve you better?

Working with Custom Metrics in WFO

If you are creating WFO reports that do not include built-in metrics, you might need to build a custom metric. You can write MAQL query (Multi-Dimension Analytical Query Language) from the Analytics Portal using the Advanced Metric Editor to create custom metrics.

This page provides an overview of building your custom metrics. We'll cover:

Navigating to the Advanced Metric Editor

You can open the Advanced Metric Editor in the Analytics Portal.

  1. Open Analytics Portal when you're logged into Flex.
  2. Click Reports.
  3. Click Create Report.
  4. In the What menu, click the (advanced) link next to Add new metric.

    What pane

  5. Select Custom metric.
    Custom Metric

You will now be redirected to the Advanced Metric Editor, where you can write your custom metrics.

Writing Custom Metrics

After you click Custom metric, you will be redirected to the Advanced Metric Editor as shown below.

custommetric_3.png

  1. Enter a name for your metric in the Name your metric text box.
  2. Check the Add to Global Metrics box to access your metric in any of your reports. If you want the metric to only be available in the current report, leave this box unchecked.

    If you check Add to Global Metrics, choose a folder to store the metric in. You can then edit the format of your metric in the Format string box. You can define how you'd like numbers to be formatted when you save a global metric – see more on metric formatting here.

  3. Enter your MAQL query into the Editor pane. If you are not familiar with writing MAQL in the Editor pane, see the section below on using the editor pane.
  4. Click Add.

Using the Editor pane

In the Editor pane, you can write your MAQL to build your custom metric. All metrics begin with SELECT.

Below the Editor pane, there is a list of functions you can apply to the facts, metrics, and attributes in your metric. Each function contains a definition, and you can click on a function to add it to your report:

functions

You cannot directly type in your facts, metrics, and attributes into this editor pane, but instead must select from the Elements menu.

Elements

The Elements menu contains the following folders:

  • Facts: Raw numbers from your data
  • Metrics: Existing queries over facts
  • Attributes: Date and text fields
  • Attribute Values: A choice for an attribute. For example, the attribute Kind attribute can contain attribute values such as Queue, Conversation, Agent Status, etc.
  • Attribute Labels: The name of the attribute field. Attributes like Handling Team contain multiple labels - Handling Team Id, Handling Team Name and Handling Team Hierarchy Name.
  • Variables: These permit metrics to be dynamic, based on the data threshold or user who is viewing the metric.

To add an element to your report

  1. Click on the folder containing the element you would like to add.
  2. Choose the element or elements to add.
  3. Click the + Add Selected button at the top of the panel or double-click the element.

Once an element is added to the custom metric formula, it will automatically be color-coded in the following way:

  • Facts: blue
  • Metrics: green
  • Attributes and attribute labels: purple
  • Attribute values: orange
  • Variables: light brown

Please reference our document on the Analytics Data Model for a full list of Flex WFO data points.

If you click the green Add button at the bottom of the report, you will receive an error message. The Add button is for adding the completed metric, not adding an element.

MAQL Best Practices

1. Don't copy/paste formulas directly from a plain-text document.

For a custom metric to work, you must choose your metrics and attributes from the Elements panel. Typing out element names or copying and pasting from a different source will not be successful.

This formula is incorrect (a copied and pasted formula):

Wrong MAQL

The formula below uses the Elements menu to add objects. This formula is correct:

MAQL correct

2. Make sure you match parentheses.

If you are creating a query that is more complicated than a single aggregated action, you should pay attention to parentheses usage and make sure that sub-queries are appropriately nested:

Parentheses

If your query contains any missing parentheses, you won't be able to save the metric:

Missing

If you are creating a complicated custom metric, it might be easier to split your custom metrics into pieces.

3. Make sure you select attribute value from the correct attribute.

The most common mistake in custom metrics is syntax errors. It can happen that instead of selecting the "Yes" value from "Abandoned" attribute you select the "Yes" value from another attribute, for example, "Productive."

While visually the formula will look identical in both scenarios, you may receive a red error message when clicking the Add button at the bottom of the editor indicating that you chose the value from a wrong attribute:

Incorrect attribute value

Rate this page:

Need some help?

We all do sometimes; code is hard. Get help now from our support team, or lean on the wisdom of the crowd browsing the Twilio tag on Stack Overflow.