I am trying to create a time series plot on Grafana.
It uses MS-SQL database
SELECT
(eventdatetime) as time,
Customer as "metric",
kpi1 as "value"
FROM
Grafana_CBRS.dbo.MWC_enterprise_kpis
where
$__timeFilter(eventdatetime)
order by eventdatetime
Using the format time series, i am able to separate the different labels (Customer column), and on the table view, the expected values can be seen.
But on the actual graph, the curve is different, for the 3rd column (or 2nd label, Howard…)
It seems the 2 series have been added and then being shown.
These 2 series should be near each other, but that is clearly not the case.