Trying to use table from --Dashboard-- data source to be used in a graph

  • What Grafana version and what operating system are you using?
    OS should be Debian 9, not sure.
    Grafana 7.4.0

  • What are you trying to achieve?
    The post title is not very explanatory, but the issue is difficult to summarize.
    I have a panel where I run a query on a SQL server and display it as a table.
    I’d like to reuse those results to create a graph in another panel.
    Here is what I trying to achieve (I used the same query a second time and changed the SELECT fields)

  • How are you trying to achieve it?
    When using --Dashboard-- as datasource and choosing the source panel, nothing shows up on the graph
    I can see that it takes the data as table:
    image

  • What did you expect to happen?
    I expected it to use the base data and then be able to use transformations to shape the data in what’s needed for the graph (exclude some columns, rename others in metric and value, etc)