How can I display weekday names in stat panel

Grafana Stat Panel
,
1

hi,

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:

image
image1882×1207 133 KB

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:

image
image2518×931 231 KB

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!

2

Hello :wave: and welcome to the forum, @tom84

this should be possible one way or another. You might need to do some regex work. Can you share your raw, unformatted data?

3

image
image1434×1162 81.2 KB

the data looks pretty much like in your gif…

4

two more screenshots: the time column can be formatted as weekday:

image
image1097×1331 85.1 KB

but when i add a transformation to use the time as field name then I can not find a way to apply the formatting options:
image
image1912×1249 141 KB

5

Solution? I am trying to build something similar right now

6

Please share your query, any transformations used, and resulting output.