In this article, we are going to map some of Sisense Dashboard Design Best practices related to performance. When you start developing a dashboard or when you want to simply improve its performance, take a look at the guidelines below and adjust your dashboard accordingly.
Avoid Wide or Long pivot tables
- Reduce the number of columns
- Filter the number of rows (Top filter on value)
- Consider Table widget or Aggregated Table plugin
Avoid many members in charts
- Wide X-axis in Line / Column charts
- Many members in “break by”
- Use Drill hierarchies
Always consider the number of widgets
- Recommended 7-10 widgets
- Consider the number of elements (filters/texts)
- Use drill dashboards (Accordion / Jump to)
Avoid dashboard date functions
- Date functions in the dashboard are re-calculated in the front end (Qdiff, MTD)
- Try to create the logic in the ElastiCube
Avoid too many include/exclude values
- Choose the lowest selection between the two
- Consider using a higher hierarchy
Addons and customization
- Make sure all the scripts are not colliding (console)
- Disable un-used plugins
Performance issue and Possible Cause
