Issue Symptoms
If an Explore query can’t be executed within two minutes, the error message: The query cannot be displayed because it took too long to execute is displayed.
Resolution Steps
If a query can't be executed in two minutes it has likely requested too many results or uses complex calculations. To ensure that data is displayed, simplify your query by following these steps:
- Add a filter to narrow down the results. For example, instead of looking at the whole history look at the last month.
- If the query uses a high number of attributes or metrics exclude some of them.
- If the query 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: See Formula writing resources to learn more about formula writing best practices.
2 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.
Chanteena Murphy, I have created a ticket for you so we could investigate this issue. One of our colleagues will reach out to you.
Please sign in to leave a comment.