I want to have a time series chart with a single query show up as multiple lines. I have a MySQL datasource with data that looks like this, and I can see the same data in the Grafana table view:
time (datetime) | name (varchar) | value (float)
2021-08-30 12:44:10 | nameA | 0.483
2021-08-30 12:46:12 | nameA | 0.425
2021-08-30 12:44:10 | nameB | 0.483
2021-08-30 12:46:12 | nameB | 0.425
However when I use the “Time Series” panel in Grafana 8, the value metrics are all graphed in one line and it’s a big mess:
I don’t know the values for name ahead of time so I can’t use multiple queries. From what I’ve read on this topic as long as the data is in the form above it should be automatically picked up by the Time Series panel as separate lines, but that is not working for me. Anyone have any ideas?
Weirdly enough plugging the exact same query into the “Explore” view seems to work OK:
