Widgets Are Slow to Update - Why?
If you experience that your dashboards and widgets are slow to update, there are some things you can do to improve it.
Last updated: Feb. 16, 2022
Data source import frequency
Plecto only updates widgets when it receives new data from a data source. Try checking in the settings of your data source, what frequency these updates is coming through to Plecto, and increase it, if the integration supports it. You can find information on whether or not the integration supports it here: Plecto integrations.
If you still experience problems with widgets not updating correctly and not showing new data, please have a look at the other possible causes below.
Very long formula
A very long and complicated formula might have a big impact on the speed of updates. If you have a formula with over 50 lines, then it would be a good idea to consider restructuring your data so that you can write a shorter formula in Plecto.
Showing too many custom groups
When using a custom group by, be careful at the number of groups it will return. It's generally a bad idea to group by a field that has hundreds of unique values. This will very often make the widget very slow to update. Consider using a Timeline widget instead.
Showing too many teams or employees
If your widget is showing a lot of employees or filtering on hundreds of teams, please consider deleting or removing unused ones as they will make it difficult for Plecto to update the widget frequently.
Very large tables
Using a table widget with a lot of columns is discouraged. Besides it being hard to get an overview, tables with a lot of columns can be very slow to update because of the amount of data they handle. Consider splitting the information into smaller widgets or using Reports.
"Contains" filter in the formula
If you have a lot of data, some widgets might be slow to update because you're using the "contains" filter in your formula. If that happens, you can try to use a different filter, for example "is."
Was this article helpful?
Please leave a comment to help us improve.