This Explore recipe shows you how to track tickets created by agents on behalf of customers that had a reply from the customer.
What you'll need
Skill level: Average
Time required: 10 minutes
Data source: Ticket updates
- One standard calculated metric
- One Submitter role filter
- One Ticket ID attribute
- A table report
How to create the report in Explore
- In Explore, click the query ( ) icon.
- In the Queries library, click New query
- On the Choose a dataset page, click Support > Ticket updates > Support: Ticket updates, then click New query.
- In query builder, click the calculations icon () on the right sidebar.
- Click Standard calculated metric. The Standard calculated metric panel opens.
- In the Name field, type a name for your new metric, for example, Proactive tickets with replies.
- In the Formula field, add the code below:
IF (VALUE(End-user comments)>0) THEN [Ticket ID] ENDIF
- Click Save.
- In the Metrics panel, click Add.
- From the list of metrics, choose Calculated metrics > Proactive tickets with replies. Select the arrow icon > to open up the aggregator list and choose D_COUNT. Click Apply.
- In the Filters panel, click Add.
- Click Submitter > Submitter role and then click Apply.
- In the Filters panel, click Submitter role and select Admin and Agent. Click Apply.
- In the Rows panel, click Add.
- From the list of attributes, choose Ticket > Ticket ID, then click Apply.
The next steps are optional. By default, under the Proactive tickets with replies column, the 0 value means that in that ticket ID the customer didn't reply back to the agent's proactive ticket. With this additional step, you can remove those tickets from your query.
- From the Result manipulation () menu, click Metric filter.
- On the Metric filter page, drag the circle on the metric line to 1, then click Apply.
You can also make the Ticket ID clickable from the query itself. For more information, see the article: Explore recipe: Configuring clickable links to tickets.