howto format basic data for plotting in tabletui

Begonnen von claudio, 12 Januar 2018, 19:26:52

Vorheriges Thema - Nächstes Thema

claudio

Do you know the best and proper way to store data and plot graphics of, for exemple gas consumption ?

For exemple, I would like to store gas consumption in kWh for each day and get the difference between days, to show day to day total consumption. I'm totally new fhem, and have great difficulties to translate german, so it doesn't help...

right now, I only have continous incrementing data like :

2018-01-12_19:17:27 ecodata totalgazm3: 925.99
2018-01-12_19:17:27 ecodata totalwatts: 174
2018-01-12_19:17:39 ecodata data4: 7
2018-01-12_19:17:39 ecodata totalgazm3: 925.99
2018-01-12_19:17:39 ecodata totalwatts: 172
2018-01-12_19:17:51 ecodata data4: 7
2018-01-12_19:17:51 ecodata totalgazm3: 925.99
2018-01-12_19:17:51 ecodata totalwatts: 175
2018-01-12_19:18:03 ecodata data4: 0
2018-01-12_19:18:03 ecodata totalgazm3: 925.99
2018-01-12_19:18:03 ecodata totalwatts: 166
2018-01-12_19:18:18 ecodata data4: 7
2018-01-12_19:18:18 ecodata totalgazm3: 926.00
2018-01-12_19:18:18 ecodata totalwatts: 175
2018-01-12_19:18:30 ecodata data4: 7
2018-01-12_19:18:30 ecodata totalgazm3: 926.00
2018-01-12_19:18:30 ecodata totalwatts: 171
2018-01-12_19:18:42 ecodata data4: 7
2018-01-12_19:18:42 ecodata totalgazm3: 926.00
2018-01-12_19:18:42 ecodata totalwatts: 175
2018-01-12_19:18:54 ecodata data4: 7
2018-01-12_19:18:54 ecodata totalgazm3: 926.00
2018-01-12_19:18:54 ecodata totalwatts: 170
2018-01-12_19:19:06 ecodata data4: 7
2018-01-12_19:19:06 ecodata totalgazm3: 926.00
2018-01-12_19:19:06 ecodata totalwatts: 174
2018-01-12_19:19:21 ecodata data4: 7
etc...

Could you give me some examples to achieve this ? I use tablet-ui for the gui

MKeY

define YOURNAME FileLog ./log/YOURNAME-%Y-%m.log (ecodata).*:(totalgazm3|totalwatts|data4).*
This will save the data in a monthly log with the logname "YOURNAME" (please change this!)

try https://fhem.de/commandref.html#statistics for day to day statistics
Wer Fehler findet, darf sie behalten!
RPi's, D1Mini
Homematic, Hue, Sonoff, Alexa, Xiaomi, ConBee
Prusa MK2.5, Prusa MK3S (MMU2S vorhanden, aber nervtötend)
Lowrider 2CNC

claudio

thanks for your response, I will try the statistics module asap

Do you know if it is possible to trigger readings updates from the connected client ? for example, the data-refresh in label widget could update the label value at regular intervalls, but it appears that it doesn't actually trigger an update from the device itself, which I want.

How it is possible to do this,even with another method ?