Storing energy data

[RonnyW]

Here is an example for writing values via flow into a database. If mySQL makes sende depends on the way you want to visualize the data.
As small version you could use MS Excel with a mySQL ODBC addon. Then you can create Pivot tables and charts.

[APP][PRO] MySQL-Client

Examples: SELECT Select one value from your database in the THEN part of your flow: [grafik] Use the flow trigger in the IF part of your flow to receive the first value of the result. You can use the Query-ID used in the SELECT above to filter your flow (react only on this kind of query). [grafik] Use the value in your flow. Take a look at the local flow tags you can use: [grafik] Use the first valus as number or text, write the complete JSON result to the timeline or what ever you ne…