In timescaledb i create a hypertable and insert data as such,
CREATE TABLE IF NOT EXISTS weather (
time TIMESTAMP NOT NULL,
temp double precision NOT NULL
INSERT INTO weather VALUES(NOW(),3.5);
Surprisingly Grafana’s query builder does not produce anything useful for this VERY SIMPLE setup.
So my question is rather simple.
If grafana’s builder cannot produce a nice query could someone be so nice to provide me one ?
… unknown time manipulation for grafana not to complain
GROUP BY time
ORDER BY time
Thanks you for any answer on this very simple question.