Calculate difference beetween mixed query results

I have a mixed panel, with two queries in different datasources. Both queries are a list of names.

I want to know the percentage of names in table A over table A and table B.

Here’s an example:

| table A |
| foo bar |
| bar foo |

| table B |
| foo bar |
| john doe |

| merged |
| foo bar |
| john doe |
| bar foo |

count table A / count merged = result

Grafana Version: 4.9.7

I would recommend to upgrade to the recent version (e. g. 11.5.X) first. You will have more options available. I don’t believe someone will remeber what’s available in your old version.

1 Like