Grafana shows incorrect time series

I am trying to create a time series plot on Grafana.
It uses MS-SQL database

  (eventdatetime) as time,
  Customer as "metric",
  kpi1 as "value"
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.

Resolved now.

Stack option should be off, which i overlooked for some reason

1 Like