Dashboard with rows for each year

[airmrmr]

• 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

[yosiasz]

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

[airmrmr]

Hi,

this is the table view:

The Data source is influxdb:

[yosiasz]

not sure how a query with one column
select value from

produces one row with 8 columns?

[grant2]

@airmrmr

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

[airmrmr]

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

[airmrmr]

Each column in there is one single query