Can I intersect queries?

  • What Grafana version and what operating system are you using?
    v9.4.7 on windows

  • What are you trying to achieve?
    I want to combine 3 queries into a single table but only if a row exists in all 3 queries

  • How are you trying to achieve it?
    I’m not sure which transform to use

  • What happened?
    I have 3 separate panels with some repeating information, and some distinct information each

  • What did you expect to happen?
    , I would like 1 panel with only the rows that exist in all 3 queries

  • Can you copy/paste the configuration(s) that you are having problems with?
    it’s the same raw sql query in all 3 panels from 3 different sql server instances

  • 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?
    I googled around for doing a set “intersect” between queries but didn’t find anything.