Autor Thema: howto format basic data for plotting in tabletui  (Gelesen 158 mal)

Offline claudio

  • New Member
  • *
  • Beiträge: 10
howto format basic data for plotting in tabletui
« 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

Offline MKeY

  • Jr. Member
  • **
  • Beiträge: 78
Antw:howto format basic data for plotting in tabletui
« Antwort #1 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
Wer Fehler findet, darf sie behalten!

Offline claudio

  • New Member
  • *
  • Beiträge: 10
Antw:howto format basic data for plotting in tabletui
« Antwort #2 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 ?