Issue symptoms
When I try to build a report, I see this error message: The report cannot be displayed because it took too long to execute.
Resolution steps
If a report isn't executed in two minutes, the report has likely requested too many results or uses complex calculations. To ensure the report displays that data, simplify the report by following the steps below.
- Add a filter to narrow down the results. For example, instead of looking at the whole history look at the last month.
- If the report uses a high number of attributes or metrics exclude some of them.
- If the report uses custom calculated metrics or attributes check if their formulas can be improved. For example, use the IF THEN ELSE function to specify exactly when the metric or attribute should be executed.
Note: For more information about best practices in writing formulas, see this article: Formula writing resources.
11 Comments
I am constantly getting this error while trying to select "Updater Name" filters. I have already added an extra filter to narrow down "Updater Role" to Agent and Admin (or excluding null and end user) before attempting to load the "Updater Name" filters.
@..., I have created a ticket for you so we could investigate this issue. One of our colleagues will reach out to you.
Hi @..., I tried creating a new query with no filters yet.
I tried adding Update - Date as a row but when I try to select the date it shows up the below error.
Hi Deo,
I'd suggest adding an "Update - Date" filter first, before adding "Update - Date" as a row. Narrowing down the date range (and thus the number of tickets you're looking at) should help.
This is happening for all my queries today (12/07/2021). Is the system down?
This is also happening to all of my reports/dashboards. Is this happening again?
Happening for our reports as well
In Zendesk Explore we have custom dashboard/reports that had been working. Today we discovered the reports and the filter widgets are all displaying "The report cannot be displayed because it took too long to execute" error message.
I just found there is an ongoing issue: Zendesk Status
Same for me, no report is working for me (and my co-workers).
I submitted a ticket and just received a reply:
(11:08:09 AM) K: Here is the most recent update from our Developers:
"We have confirmed an issue across multiple products causing Explore syncing delays and access issues, latency in Support, delays in SLAs applying after ticket updates, and bulk job processing delays. Our team is engaged and we will provide further updates soon.
In addition to the above, we have confirmed the issue is causing disconnections from calls in Talk as well as impact to ticket merging functionality. We will provide additional information as we learn more."
Please sign in to leave a comment.