Inner Join problem

  • What Grafana version and what operating system are you using?
    9.1
  • What are you trying to achieve?
    I have a mixed dashboard that contains in query A results from elasticsearch as a table, and in query B results from a postgrees sql as a table.
    Both have a column name and time that i should merge to obtain my goal table.
    In the transforms, I just have the Outter join, that receive only one element as key.

I don’t have labels to use the join by label. What should I do?

  • How are you trying to achieve it?
    With transforms in a mixed dashboard

  • What happened?
    I cannot perform an inner join

  • What did you expect to happen?
    Join the tables by name and time