The correct formula for calculating percentage change in Zendesk Explore is crucial for accurate reporting.
The formula should be: (COUNT(Tickets created this month) - COUNT(Tickets created last month)) / COUNT(Tickets created last month). This formula calculates the percentage increase or decrease based on the previous month's ticket count. Using the wrong formula can lead to misleading results, such as showing a 99.9% increase when it should reflect a 1000% increase.
Creating a time over time percentage change report in Zendesk Explore is straightforward and takes about 10 minutes. To start, you'll need Zendesk Explore Professional or Enterprise and Editor or Admin permissions. Begin by creating two date range…
To create a custom dropdown ticket field report in Zendesk Explore, you'll need a few things. First, ensure you have Zendesk Explore Professional or Enterprise and Editor or Admin permissions. You'll also need ticket data in Zendesk Support. The…
Handling zero ticket counts in Zendesk Explore reports can be tricky but manageable. If there are no tickets created in a period, calculations might return incorrect or empty results. A workaround is to adjust the formula to account for zero…
Yes, you can customize the time periods for your Zendesk Explore report to suit your needs. While the default setup compares this month to last month, you can adjust the date range calculated metrics to cover any time period, such as this week and…
Displaying percentage changes in Zendesk Explore reports involves a few simple steps. After creating your result metric calculation, you need to change its display format to show as a percentage. In the report builder, access the chart…
Breaking down Zendesk Explore report results by a custom field is a great way to gain deeper insights. To do this, add your custom field as an attribute in the Rows panel of the report builder. For example, if you have a custom field named…