I’m setting up a new dashboard in Grafana, and want to get datas from postgresql.
I am using Postgresql 10 and Grafana 6.1.6. In the database I have three column, id (bigserial), time (timestamp), temp (float4).
I tried this query:
time AS “time”,
CAST(temp AS integer)
ORDER BY 1
But I need to get with decimals. Is there any option to do that or I simply can’t ?