In this recipe, you will learn how to create a report that shows you the number of created tickets per month compared to the percentage of created tickets in the previous month.
What you'll need
Skill level: Beginner
Time required: 15 mins
Data source: Tickets
Ingredients:
- Tickets
- Duplicated metric of Tickets
- Ticket created - Month
How to create the report in Explore
Use the following steps to create this report in Explore.
- In Explore, click the reports (
) icon. - In the Reports library, click New report.
- On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
- In the Metrics panel, click Add.
- From the list of metrics, choose Tickets > Tickets, then click Apply.
- Duplicate the metric Tickets and call it Tickets copy.
- In the Metrics panel, click Add.
- From the list of metrics, choose Calculated metrics > Tickets copy.
- In the Rows panel, click Add.
- From the list of attributes, choose Time - Ticket created > Ticket created - Month.
- From the Result manipulation (
) menu, click Result path calculation.
- On the Result manipulation page, change COUNT(Tickets Copy) to the below settings:
- Pattern | % of difference
- Path | On specified attribute
- Attribute | Ticket created - Month
- Reference | Previous element
- Click Apply.