To calculate the average number of tickets per user each month in Zendesk Explore, you need to create a custom metric. This involves using the Tickets dataset to build a query.
Add the metrics 'DCOUNT(Tickets)' and 'DCOUNT(End-users)' to your report. Then, use the Result Manipulation feature to create a new metric with the formula: DCOUNT(Tickets)/DCOUNT(Requesters). This will give you the average number of tickets per user. If necessary, add a filter to exclude tickets submitted by agents by filtering for the Requester Role.
To find the number of unique users submitting tickets each month in Zendesk, you can use the Explore feature. This involves creating a report that counts each user only once, regardless of how many tickets they submit. Start by opening Explore and…
To create a report in Zendesk Explore, you need to have either Editor or Admin permissions. These permissions allow you to access and manipulate the data within Explore. If you're unsure about your permissions, you can check with your Zendesk…
To visualize the number of users submitting tickets in a different format, you can adjust the report settings in Zendesk Explore. After setting up your report, you can move the 'Ticket Created - Year' and 'Ticket Created - Month' from the Rows…
Yes, you can filter your Zendesk Explore report to show only the last 12 months of data. This is done by editing the date range in the report settings. Click on 'Ticket Created - Year' and choose the period you want to analyze. For the last 12…