Hi,
I’m rather new to grafana and am using v11.1.0 with flux queries to influxdb.
Meanhile I managed to build a dashboard to inspect the status of our photovoltaic plant. For “cosmetic” reasons I would like to add a text panel (or something equivalent to it) as header of the dashboard to display the startpoint and endpoint (date / time) of the displayed period.
In other words, I need something like “Startpoint: datetime1, Endpoint: datetime2”. I manage to extract the two values by a query to a random variable (e.g. homePower), but I didn’t find a way to display them nicely.
I tried this by choosing a stat panel and changing the display name, but ran into the same problem as here: Cannot change display name of stat panel when field "Time" is selected · Issue #79575 · grafana/grafana · GitHub
Then I added the Business Text Panel, but that seems too mighty and is too demanding for me to handle.
Is there a more simple / easy solution to my problem?
Hi @grant2,
interesting, your example shows exactly what I tried to achieve. Unfortunately, for the moment, this doesn’t work for me. Here is my example:
Query:
Result without transformation:
and with your proposal:
I can see that there are different names: _time and Time
Did you achieve this in a stat panel? Maybe you could expand your query and your first transformation?
Thanks so far
Yes, it’s a Stat Panel:
The dashboard with this panel can be found here. Maybe you can figure out why mine works but yours does not.
what is causing the No Data? if there is no data its working as designed
Finally, I could achieve my goal. The (probable) solution was two steps:
- Check “Replace all fields” in the first transformation (reduce rows)
- Select “All fields” in the value options → fields section of the panel
Thanks a lot!