Dashboard with rows for each year

  • What Grafana version and what operating system are you using
    Raspberry pi 6.1

  • What are you trying to achieve?
    I got this:

    and would like to get this:

  • How are you trying to achieve it?
    Tried nearly all transformation options

  • What happened?
    Always stays at one row with all data in a series.

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

Data is coming from influxdb.
I have a query for each metric i am displaying and i am trying to get from a view where all values are in one row to a view where i have a row for every 4 values.

Maybe its easy or maybe it is not doable. But i cant figure it out.

thnx in advance

what is your data source and can you show us the table view?


this is the table view:

The Data source is influxdb:

1 Like

not sure how a query with one column
select value from

produces one row with 8 columns?


In this screenshot, what is the meaning of the two rows? Is this the data for 2023 and 2022?

Yes, it is the Energy consumption on a yearly basis. 2023 and 2024

Each column in there is one single query