Introduction
The performance of your forms plays a crucial role in the user experience of your dashboard apps. Slow-loading forms can cause delays and frustration. This article provides best practices and steps to enhance form performance and ensure a smooth user experience. Kepion will notify modelers when a form exceeds 1000 KB in size.
Before you start
- Keep the form layout simple.
- Limit the number of dimensions on the rows and columns.
- Reduce the scope of large forms by adding more filters.
- Disable or redesign features that aren't necessary, e.g., drop-downs, annotations, cell attributes, and color formatting.
-
Separate a large and complex form into multiple smaller forms.
-
For large forms, break them into smaller, more manageable forms and display them side by side on a dashboard. This reduces the complexity and load times of individual forms.
-
Form formatting recommendations
Use cell attributes for dynamic formatting.
Cell attributes can be used to define cell formats by condition.
Apply static cell formatting to the entire rows or columns if possible.
For non-dynamic formatting, apply formatting to rows or columns instead of individual cells. This reduces form size and improves performance. For example, to add color, highlight an entire row rather than formatting each cell.
Use pre-defined advanced settings for bulk formatting.
Advanced form settings can be used to customize forms in a flexible way, allowing for broad, generic adjustments to suit various needs.
Steps to optimize form formatting
Use the steps below to diagnose and improve form size and performance.
1. Create a copy of the form that has a large size.
2. Clear all formatting options such as:
- General formatting styles (e.g., colors, borders)
- Cell attributes
- Properties on row or column
- Drop-down menus
Note: The query time for this cleaned-up form should be similar to the raw MDX query time in Microsoft Analysis Services.
3. Reintroduce formatting gradually.
- Add the necessary formatting options back into the form, one by one.
- If you notice a significant slowdown, stop and investigate which feature is causing the issue.
By the end of this process, you will have recreated the original form with optimized performance. For further guidance, refer to the Performance Tunning Guide, which provides details on settings and options that typically have the greatest impact on performance.
Additional considerations
To ensure optimal performance across your entire application, it's important to continually refine and optimize form performance wherever possible.
Feel free to submit a ticket to our support team for more personalized assistance.