Optimizing dashboard performance

Optimizing dashboard performance#

This guide explains how to optimize the loading time of your dashboards.

Introduction#

To display the data in your widgets, your dashboard makes a number of database queries. The higher the number and complexity of these queries, the longer your dashboard will take to load. We recommend keeping dashboards clean and simple to help them load and display your data as quickly as possible.

Improving dashboard performance#

There are a number of ways that you can optimize the performance of your dashboards:

Keep dashboards clean

  • The more widgets you add, the longer it takes to load them. Use only the widgets you really need.

  • Don’t add too many widgets to the same dashboard page. If your dashboard page starts loading slowly, create a new dashboard page and move some widgets to the new page. For more information, see Using dashboard pages.

Simplify the widgets on your dashboard

  • Remove any metrics and dimensions that you do not use from your widgets.

  • Transposed fields that are included in visualization widgets take longer to use. If your visualization looks the same without transposing the fields, remove the transposition. For more information, see Transposing dimensions.

  • KPI box widgets take longer than other widgets to load. Try adding new information to existing KPI box widgets, instead of creating new widgets, and minimize the number of KPI box widgets on each dashboard. For more information, see Customizing KPI box widgets.

Use simple filters

  • Only use metric and dimension filters when necessary.

  • Choose the shortest possible date range for visualization widgets.

  • Filters that use contains, startsWith, or endsWith logic to filter data can take longer to load. Only use these types of filter logic when necessary.

Contents