Adding metrics and attributes to queries

To create a query you must add at least one metric and optional attributes.

Metrics are quantifiable values, such as the number of tickets, replies to tickets, and agent or customer wait times. Attributes are non-quantifiable values, such as ticket ID, ticket tags, and assignee names.

There are many metrics and attributes that you can use for each Zendesk product. To learn what's available, see Understanding Explore datasets.

Important: To limit performance issues, Explore currently returns only the first 50,000 rows from a query. To successfully run the query, consider using a filter to limit the results returned (see Adding attributes).

This article contains the following topics:

• Adding metrics
• Adding attributes
• Next steps

Adding metrics

You add metrics in the Metrics panel of query builder. Explore automatically uses the most suitable aggregator for the metric. You can change how your metric is calculated by clicking the metric, then selecting a new aggregator, for example, an average or sum value. For details, see Changing metric aggregators.

You can also select whether the metric results are measured in different sizes or colors, on a separate axis, or as datatips.

To add a metric to your query click Add in the Metrics panel. Your metric results will automatically appear on your query.

This section contains the following topics:

• Measuring results by color and size
• Adding a metric as a secondary axis
• Displaying a metric's results as a trendline
• Restricting metric results to datatips
• Using comparison lines to highlight metric results

Measuring results by color and size

You can measure a metric's results in a color gradient or with different display sizes.

In the image below, Agent replies has been added as a color-encoded metric. At the upper-right of the chart, you can see how results are distributed in the color gradient.

In the image below, Agent replies has been added as a size-encoded metric. At the upper-right of the chart you can see how results are distributed in the different sizes. Size-encoding options cannot be edited.

To add a color or size-encoded metric

1. In the Metrics panel, click the Color-encoding icon () or the Size-encoding icon ().
2. Select the metric you want to color-encode, or size-encode..

To change the color style

1. Click the chart configuration icon ().
2. Click Colors.
3. From the Color encoding drop-down list, choose a new style.

Adding a metric as a secondary axis

On some chart types, you can add a metric as a dual axis, or secondary axis. This is an easy way to compare metrics with different scales and separate results that would be difficult to analyze.

In the image, the Unresolved unreplied tickets metric uses a much smaller scale than the Agent replies and Tickets metrics. As the image below shows, the results from this metric are difficult to view.

To make data easier to view, you can add Unresolved unreplied tickets as a dual axis. This displays the metric by its own scale and visualization as displayed below:

To add a dual axis metric

1. In the Metrics panel, click the dual axis icon ().
2. Select the metric you want to use for the dual axis.

You can edit the dual axis in Chart configuration > Secondary axes.

Displaying a metric's result as a trend line

Similar to a dual axis, you can add a metric as a trend line to separate results. You can also display the trend for each metric by adding trend lines in Chart configuration> Trend line.

Note: If one of your metrics is added as a trend line and you add a trend line in Chart configuration, an additional line will not appear for that metric.

To add a metric as a trend line

1. In the Metrics panel, click the trend line icon ().
2. Select the metric you want to add as a trend line.

You can edit trend line options, including hiding and displaying values in Chart configuration>Trend line.

Restricting metric results to datatips

If you do not want a particular metric to display on the query, but still want users to be able to see the data, you can add the metric as a datatip. Any results from the metric added as a datatip will appear when a user hovers over a data point. For more information on adding and customizing datatips, see Working with datatips.

In the image below, only the replies metric is visible on the report, but when a viewer hovers over a data point, they can see the corresponding number of tickets results.

To add a metric as a datatip

1. At the bottom of Metrics, click the datatips icon ().
2. Select the metric you want to display as a datatip.

Using comparison lines to highlight metric results

Comparison lines can highlight multiple metric results for one value. When you add a comparison line, you can hover over any data point to view all results for the same X axis location. Comparison lines are useful when your attribute has several values, but your screen size cannot display each label.

To add comparison lines:

1. In the chart configuration menu (), select Datatips.
2. Select Comparison line from the Mode drop-down list.

Adding attributes

Attributes slice your data by non-quantifiable values. They can also be used to select or exclude results from your chart. You can choose values to display by clicking on the attribute after it is added.

Attributes can be added to the following panels:

• Columns
• Rows
• Filters
• Explosions

Columns

Columns slice your results by the attribute's values in one chart. To add an attribute to the Columns panel, click Add, then select an attribute.

Note: You can switch attributes in the Columns and Rows panels by clicking the Pivot table button () in the Columns panel. The pivot table feature saves you time by automatically moving your attributes, so you don't have to drag and drop.

Below is an example with the attribute Ticket created - Month added as a column.

Rows

If you add an attribute to the Rows panel, you can see individual charts for each of your attribute's values without selecting or excluding results. You can view a value using the Row Selector to the left your chart.

Below is an example of a report with the Ticket status attribute added as a row. The value Closed is selected in the row selector.

Filters

Attributes added as filters enable you to select or exclude values to include in the query results. Results are filtered to the values you select, but the attribute names do not appear on your query. Instead, all your applied filters are listed underneath your report. This list includes any result manipulations you create.

For example, the results below are filtered by the Open ticket status, but the attribute name is not displayed on the report.

Explosions

Similar to rows, attributes added to the Explosions panel break your report into individual charts based on the attribute's values. Unlike rows, explosions show all charts side-by-side. This provides a simple way to compare results, but if your attribute has several values, you should consider selecting values to display or using rows.

You can display a maximum number of 30 charts using an Explosion. If the attribute you add to the Explosions panel returns more than 30 values, apply a filter to restrict the number of values returned.

Next steps

• Saving queries
• Creating dashboards