I’m query a sqlite database to fill a chart on page load. This works all fine.
However for the battery the chart is 1 month width and filling it with “sampled every 3 minutes” = 14400 point takes to long. It’s also not necessary to have that much points in the chart.
Is it possible to query not all the points from the db?
msg.topic ="SELECT batterij ,timestamp FROM temphal WHERE timestamp >= " + fromdate + " AND timestamp <= " + enddate + "" ;
There was also a node to reduce the datapoints in an array, but I can’t find it any more. Somebody a suggestion?