Use transformation results of a panel in variables or other panels

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    8.5

  • What are you trying to achieve?
    Hi, i do quite a lot of transformations in one of my panels to transform the query data. so far so good. but now i need to reuse these results in another panel. If i choose the panel as a datasource i only can reust the query from that panel but not the result after transformation.

Can i somehow access these results or even better store them into a variable that i can reuse? Would be great.
Cheers
Paul

2

Hi paulchenpanther,

I have the same issue. Have you found a way to do this?

3

Transforms are made at runtime while the dashboard loads.
So I think it is difficult to reuse this data somewhere else.

4

You can reuse the data in another panel with Dashboard datasource (there you have an option to include transformations or not). As for variables - I don’t think you can, since change in variable would trigger a potential change in query, so it would be an infinite loop.

5

@dawiddebowski I had tried that, but using the “dashboard” datasource allows to select only 1 panel.
I actually don’t really understand the use of that, behalf showing the data in a difference way.

What i am looking for is a way to make calculation on these 2 panels (which contains few transformations)

image
image632×605 37.4 KB

With “dashboard” datasource I can select only one of them:

image
image1053×864 45.7 KB

6

Funny enough on the latest grafana version (playground) we can duplicate the dashboard datasource, but still can’t use it further:
https://play.grafana.org/d/ede8zps8ndb0gc/panel-as-data-source?from=now-6h&to=now&timezone=browser

7

Ok, to have data from two panels like that I don’t think it’s possible unfortunatelly. You could move the values you need to variables but I can imagine it won’t work for you either (since you’ve mentioned transformations).

8

maybe coming at this issue from another angle might be a good idea, instead of trying to reuse transformations

I stay as far away as possible from transformations and try to do all that I need in the datasource itself.

what is your data source and what transformation are you applying? please share raw data coming from datasource and what you want it to look like after transformation.