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.
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.