Azure Managed Grafana 10.2.1
I’ve connected Grafana to multiple data sources and can switch between them using a variable. Everything works fine when only one data source variable is selected, and the data is correct. However, there are issues when I try to select multiple values. I’ve attached some screenshots for better clarity. I think I might have missed some additional calculations. Thanks for the help
what does the usage of that variable look like?
I`m not sure what you mean by that but here is the query I use
as the name indicates you can only do one data source.
instead of that approach might want to look at using that variable in the query itself?
select yadiyada from ${datasource} where x = 12 kind of thing?
The problem is that all data is stored across several SQL databases, with one database for each client.
Are these databases on the same sql server?
Yes, the server is same
Understood, thanks a lot for your help again)
We use different databases for a more reliable and fast syncing process.