I have a panel that calculates the time an on/off state sensor has been on. I also like to use this value to convert the time in that state to another unit, liters of water in my case.
How can I use the count value, but multiply it by a value (12) and display that value in the panel?
welcome to the forum, @tfsjohan
this should be possible using transformations, but ultimately it will probably be more performant to do these calculations on the DB side.
can you please follow these steps to share your raw unformatted data? That way, the community can try and mock up your problem