General Rule help needed!

[rossko57]

@siod

How can I manage in openhab2 that the item shows me a value e.g. 1000 as an initial value and than adds +1 whenever the sensor writes an OPEN into the database?

That doesn’t seem to e a database related requirement.
I’d create a number item for counting.
Trigger a rule to set it 1000 whenever (at system start? when the date changes? when a button is pushed?)
Trigger a rule from the sensor item changing to OPEN and have that rule add 1 to the counter.

I’m not sure how that helps with

@siod

In the end I want to have a power consumption measurement which shows me tha actual KWh consumption

Might be some ideas here

Imitating the Power Consumption of Lights (and others)

In this short article, I’m going to show how to monitor most of your energy consumption without investing in special hardware. This solution is based on the fact, that most devices (prominently all your lights) have unchanging wattage only depending on their current state, which is already controlled by your openHAB system. By the help of power consumption measuring modules, such as the Homematic HM-ES-PMSw1-Pl, Sonoff Pow or similar, we are able to monitor the consumption of dynamic consumers,…