I am migrating from Grafana v7.3.7 to Grafana v9.4.3.
I encounter a blocking problem during my migration concerning the use of a Graph panel containing only 1 query A but returning a dataset with two metrics, server_1 & server_2.
I insist on the fact that it is only one query A returning the 2 metrics, and not two metrics A and B returning respectively the metrics of server_1 and server_2 because in this case I have no problem.
My source is mssql which returns this dataset:
In v7, I used to get this visualization :
In v9, I get the unwanted visualization :
The reason is that grafana v9 is changing ma dataset by that :
So it is trying to find a value for each metric and for each time that he will find the dataset, and is virtualing creating a measure with a 0 value for each correponding missing matchs.
This behavior is unwanted and can not be changed with connect as null…
How can I tell Grafana to not add this 0 values?