Hi, I have running counters for several values (total power consumption per day) which will be reset at midnight. Now I would like to create charts that give me flat lines per day instead of the increasing lines per day that the standard persistence would display. My idea was to explicitly persist…

Cannot be done with openHAB persistence services. Recent related post [image] Graph from independent data points Scripts & Rules You will not find any posts in openhab referencing your desire because openHAB does not support the use of databases in that way. H…

[image] macmeck: My idea was to explicitly persist only the last value of the day at 23:59h or the max value or whatever. That can be done: (with all counters in the group gCounters) Strategies { beforeMidnight: "30 59 23 * * ?" default = everyChange } Items{ gCounters*: strate…

[image] RolfV: That can be done, but I’m not really sure why you would need that? That can be done? cool - how? why? If I persist at 23:59, the chart would display today’s value only tomorrow (starting 23:59 today). So the values are being shown one day late.

But isn’t that the reality? If the items would have that value at 0.00 already, you could have persisted it then. The how is in principle simple: adjust whatever you are using to make the graph such that it only takes the date part, not the time part, for the x axis. If that can be done with the g…

[image] RolfV: But isn’t that the reality? If the items would have that value at 0.00 already, you could have persisted it then. kind of - the value I’m measuring is the total power consumption per day for which the final value exists only at the end of the day but is valid for the whole day,…

The standard OH charting is deliberately quite basic. Do you actually notice this issue, if charting say monthly figures? Some people use the more sophisticated Grafana with OH. I don’t know what stunts that can perform..

[image] rossko57: I don’t know what stunts that can perform… Lots. For example, in this case I would use the dates only as the x-axis as RolfV suggests and chart the values as a bar chart instead of a line graph. Then the data very neatly lines up with the usage per day visually.

My thoughts were along the same lines indeed. Standard OpenHAB charts do not allow such things however. Furthermore, which persistence service are you using @macmeck ? Can be quite relevant to make this worthwhile as a solution for long term trends and such.

Explicitly persist value for arbitrary timestamp

Setup, Configuration and Use Scripts & Rules

rossko57 (Rossko57) May 12, 2019, 7:47pm 2

Cannot be done with openHAB persistence services.
Recent related post

I suggest that it’s usually better in principle to manipulate the charting, rather than “faking” original data, but I wouldn’t know how to go about that.