I am trying to visualize data from postgress again. I had issues with this in my previouse post but managed fix it with some help. After cahnge the way my postgres tables are set up I cant manage to create a line for each “sensor_id”. The axies should contain the time and the temperature.
This is my Postgres setup:
No matter waht I do there are two seperate lines for “sensor_id” and “value” like this
I tried changing the data type of id back to uuid an it works again. Is it possible to get it to work using int as the type for the id?
Yes, you can have int in the DB, but you must have it as string in the Grafana. So CAST int to varchar on the SQL level or use Grafana transformation to change type to string.