How long a switch was ON today

[nakh_Home]

Hi,

i am trying to find a way to know how long the TV was turned on all Over the day till now.

my swich is persisted in influxdb.

The goal is to display a text item like : 2H43M

Any Ideas how to tackle it?

[rossko57]

A “cheating way” is to persist every minute, and then add up all records.

How do create a graph of how long a device was on for the day, week, month?

That is not what I am recommending. You already have HVACRuntimeC being stored in the database with 1s for on and 0s for off. So update your mysql.persist file to save that Item every minute instead of on every change? This way if you count the 1s you have counted the minutes it has been On. If you want a better resolution than every minute (and don’t mind trading the space in your DB for simplicity) change it to every second. No need for rules or other Items and any other changes. Example …

[mstormi (Markus Storm)]

See persistence docs. Try making use of
<item>.previousState(true)
Gets the previous State of a persisted Item, skips Items with equal State values and searches the first Item with State not equal the current State (returns HistoricItem)

[CDriver]

Wouldn’t item.lastUpdate tell you? Assuming it always goes on/off/on/off