When I try to build a report, I see this error message: The report cannot be displayed because it took too long to execute.
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.