I am trying to display the daily energy delivered by my photovoltaic panels using the stat panel. I have configured telegraf to read the inverter power every 10 seconds and write it into an InfluxDB. Getting the daily energy is done using the following query:
SELECT integral(“WR_P_AC”) / 3600 FROM “modbus” WHERE $timeFilter GROUP BY time(24h) fill(null) tz(‘CET’)
which delivers this (formatted) data:
now, my idea was to add a transformation to set the field name to the corresponding time to display the weekday in each value field:
at this point, the time gets formatted and interpreted as number.
how can I achieve formatting the time as weekday and display it as such?
thanks a lot!