Report generation?

[denis]

I have several devices that, in addition to their main goal, monitor a few things, like power consumption, temperature, humidity, lux, etc.
Is there a way to tally the numbers up to generate reports? Like Watts over time, or similar.
Thank you.

[dylan.c]

You can write values to a csv file, if that is any help. With some additional apps i think you can add Google sheets.

Appending to CSV

I am trying to write variables to a CSV file. Everything works well, except when I append to report it just adds it onto the same line. I'd like for it to append onto a new line (row). Is there a trick to this? I am currently getting: Value 1;value 2;value 3 I want: Value 1 Value 2 Value 3 Thanks

There is also a way to display data in a table format. Not something I've used but maybe relevant.

Lights Usage Table

A user wanted an easy way to see how long a light was on cumulatively. To meet this need, and to illustrate some basics of table UI, check out this app:

[mthomas1022]

I have the same issue. I just want to have the data put on separate rows. Did you ever get an answer how to do this? Thanks

[denis]

No never did. But I switched some devices to Home Assistant and it has all and more than I needed. Home Assistant is better with some tasks and extensively supported.