Currently, I am utilizing Flot Charts to create line charts that display timeseries data.
To streamline the visualization process and reduce the number of data points shown, I have implemented a downsampling technique by averaging data points within the same hour.
However, my recent discovery of the Largest-Triangle-Three-Buckets algorithm has prompted me to consider its benefits. You can find more information about it here:
What advantages does using LTTB provide over simple aggregation methods like averaging (by minute, hour, day, etc.)?
Would pre-calculating an SQL table on the server-side using LTTB for each month of data, and then applying another LTTB on the aggregated data client-side, improve the efficiency of long period queries?