The correct end date for the 12-month average metric in Zendesk Explore is 'To the end of: 1 month ago'. This ensures you get a true 12-month rolling average.
This setting looks back to the beginning of the current month in the previous year and stops at the last day of the previous month. For example, if you run the report today, it will look back from May 1, 2021, to April 30, 2022, providing 12 full months of data for the average calculation.
To create a report comparing last month's tickets to a 12-month average in Zendesk Explore, follow these steps. First, ensure you have Zendesk Explore Professional or Enterprise and the necessary permissions. Start by clicking the reports icon in…
To create a report in Zendesk Explore, you need Editor or Admin permissions. These permissions allow you to access and manipulate data within Zendesk Explore. If you don't have these permissions, you may need to contact your Zendesk administrator…
Yes, you can compare weekly ticket data instead of monthly in Zendesk Explore. This involves adjusting the formula and date range. Instead of usingCOUNT(Tickets)/DCOUNT_VALUES([Ticket created - Month])
, use `COUNT(Tickets)/DCOUNT_VALUES([Ticket…
Creating a report in Zendesk Explore requires an intermediate skill level. This means you should be comfortable with navigating the Explore interface and using its features. The process involves creating calculated metrics and understanding how to…