Use String status in Time series

  • What Grafana version and what operating system are you using?
    Grafana v10.2.0 on a Raspberry Pi 4 running Raspberry Pi OS

  • What are you trying to achieve?
    I want to display the status of my thermostats on the time series or (even better) use the status to alter the set temperature. Via IOBroker I set the thermostat status to “off” while the window is open and back to “heat” a few minutes after it is closed.
    I would like the set temperature to display 0°C while the status is set to “off”
    Everything is logged in an influxdb database. The status is logged as string (“off” and “heat”)
    If it is not possible to change the set temperature value, I would just like to display the status as a number on the graph. (1 and 0 for “heat” and “off”)

  • How are you trying to achieve it?
    Tried finding a solution with google and also asked ChatGPT with no success. Played around with Value mappings but could not find anything useful.

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

@FeuerFrosch Hey, I’m trying to achieve the same exact thing. But here is what I’ve only achieved:

The “Enums” are duplicated for each TRV, their order is not consistent :dizzy_face:, and the value at the start of the time series is not either one of the enum values