Tagged Questions
1
vote
1answer
55 views
How to aggregate datapoints in a table?
Suppose I have following table -
CREATE TABLE data_points (t DATETIME PRIMARY KEY, value INTEGER);
I want to aggregate the data by calculating average of every 10 points in the table.
i.e. If ...