Im using Grafana v11.0.0 with MySQL datasources.
I need to add a third query to my panels, and I need to be able to filter each query result singularly with a variable.
On every dashboards i have set 2 separate variables to get those databases, and since I have two databases which are structurally very similar, both queries on every panel are identical.
So if i want to filter the results from one specific database, I select the same database twice.
I know this is very hackish, but it works for what it is.
The problem is that I now need to to introduce a third query to my panels that points to the B2B database, and my current approach won’t allow me to filter the individual queries (if I keep this approach, i can only filter the query result that points to the B2C db, or both the queries from the B2B db).
Is there maybe a better method of filtering the queries results?