FHEM Forum

FHEM => English Corner => Thema gestartet von: claudio am 12 Januar 2018, 19:26:52

Titel: howto format basic data for plotting in tabletui
Beitrag von: claudio am 12 Januar 2018, 19:26:52
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
Titel: Antw:howto format basic data for plotting in tabletui
Beitrag von: MKeY am 12 Januar 2018, 21:04:36
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
Titel: Antw:howto format basic data for plotting in tabletui
Beitrag von: claudio am 17 Januar 2018, 22:27:44
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 ?