Hi y’all, Carolina from support here!!
Here we go with a quick tip that shows how to use the Aggregate function in Data Analytics to perform downsampling directly in the widget, drastically reducing the number of data points and speeding up visualization.
When displaying large amounts of data in a widget it can slow it down and impact the performance of the entire dashboard.
The Quick Solution:
-
In your widget, click “Data Analytics [beta]” in the data source section.
-
Select Function: Aggregate.
-
Choose Calculation: Average (or Max/Min for peaks).
-
Set the Interval: Hourly or Daily to aggregate the data.
-
That’s it! The chart now renders only the aggregated points (e.g., 24 hourly averages per day), becoming instantly faster.
Why it works: Instead of fetching and drawing thousands of raw points, the widget now queries and displays only the aggregated data for the chosen interval. It’s the most efficient way to visualize historical trends without overloading your browser.
Pro tip: For real-time visualization (“live” data), keep a separate chart without aggregation.
Important additional info: You will need to define Cache settings, which are mandatory for maintaining dashboard responsiveness and performance.
Did this tip solve your performance issue? Share in the comments if you’ve used Data Analytics for other purposes!
Cheers,