Hi there. I am completely new with grafana and postgresql and was hoping to get some help. I have a table with time (timestamp without timezone) and value (integer) and am trying to create graph in grafana. I’ve tried many different things but I never managed to do it. Heres my code:
ELECT
EXTRACT (EPOCH FROM “CAS”) AS “time”,
“VLAGA” AS “value”
FROM
public.temperature
WHERE
EXTRACT(EPOCH FROM “CAS”) BETWEEN __unixEpochFrom() AND __unixEpochTo()
I get no errors, but nothing shows up. Also values stay between -1 and 1, however if I remove WHERE statement correct values will show on Y-Axis.
Any help would be much appreciated. Thank You
Ps. Im sorry for asking such basic question