MySQL Name of line / dataset

Grafana Time Series Panel
1

Hi There,

I’m trying to get a graph working based om MySQL data. The data is visible, but I cannot figure out (even after a couple of hours search on Google and this community) how to set the name of the data correctly. Now it always says: “Unknown”.

This is my SQL used:

SELECT
  UNIX_TIMESTAMP(Time) as time_sec,
  Value as value
FROM Item4
WHERE $__timeFilter(Time)
ORDER BY Time ASC

And that yields this:
unknown

Am I doing things correctly?

2

And within 5 minutes it’s fixed by looking at the suggested topics.

Solved by adding:

'name-of-line' as metric

1 Like