We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Here are some suggestions to improve the dashboard performance...

1. Create views

Lots of join operation would take more time. If you find yourself creating a data connection with many tables, you can create a view in the database for those joined tables. It will help to improve the performance of the dashboard. Also, it will simplify the view in dashboard designer.

 

Tables (Joined):

cid:image001.jpg@01D34E80.1513B5B0

 

Views:

cid:image002.jpg@01D34E80.1513B5B0

 

2. Create initial filter

Filter data as early as possible. For example, if your dashboard shows data for a certain date range, time range, a specific set of regions etc., using initial filter at the earlier stage can help to improve the performance.

 

cid:image007.jpg@01D34E80.F6021B70

 

3. Remove unused columns

Reduced the number of columns in the table schema, from the dashboard designer view, by manually excluding the unused columns.

 

cid:image004.jpg@01D34E80.1513B5B0

4. Avoid creating complex expressions

Following actions may contribute to the dashboard performance.

  • If possible, avoid/reduce the complex expressions.
  • Avoid creating filters for calculated dimensions.

 

5. Avoid changing datatype

Datatype change in designer reduces the performance. If possible, do the datatype change in database itself.

 

6. Avoid using too many widgets

Don’t use too many widgets in one single dashboard. In case, if you have used more widgets, move to another dashboard using multiple dashboard option.

 

cid:image005.png@01D34E80.1513B5B0

 

7. Aggregate the raw data

If the granularity of your raw data is higher than the data you intend to display, aggregate it to the smallest granularity you need. If possible aggregate the raw data instead of using "None" option or "Enable Data Grouping" option in dashboard.

 

cid:image006.png@01D34E80.1513B5B0

 

8. Moving file type data to server

If you’re using file type database such as Excel, CSV, JSON, before connecting dashboard designer, move your data to another server like SQL. It will improve your overall dashboard performance. 

Article ID: Published Date: Last Revised Date: Platform: Control:
8390 02/09/2018 02/09/2018 Dashboard Platform Dashboard Datasources
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon