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
Chanteena Murphy
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.
1
Eugene Orman
@..., I have created a ticket for you so we could investigate this issue. One of our colleagues will reach out to you.
1
Deo Labindalawa
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.
0
Dave Dyson
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.
0
Dan Simon
This is happening for all my queries today (12/07/2021). Is the system down?
0
Dave Dyson
0
Cody Davis
This is also happening to all of my reports/dashboards. Is this happening again?
0
Nathan Cornwell
Happening for our reports as well
0
Michael Fisher
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
0
Jagoda Janiszewska
Same for me, no report is working for me (and my co-workers).
0
Jagoda Janiszewska
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."
0