How to add a Time Series from chronological Data of multiple Sensors

Grafana MySQL
1

Grafana Version v9.0.2 on a Debian 10 64 Bit Machine

I have a MySQL Database with one single Data Table, where all the Data of various Sensors is stored in chronological order:
image
The table has 3 Columns: a Timestamp, an alias (name of the Sensor), and the Value.

I now tried to visualize that in Grafana.
I created a new Dashboard and added a Data Source of Type “MySQL”.
I used “time” as the Time column, “alias” as the Metric column, and “value” as Column Name in the SELECT-Statement:

That kind of works, I get a lot of Dots in the Diagramm with all the Data in the Table, but the dots are not connected to Lines:
image

If I switch to “Table View”, I see a lot of Columns and only somewhere spreaded the Values of my Data.

I see why that is as it is, thats what my Data looks like.

But is there any possibility to generate Time Series that are displaed as Lines in the Graph View with the Data I have?

Thanks in Advance,
regards
Hans

2

image
image1535×755 55 KB

maybe adding stacked series

3

Ok. Sorry for asking.
Just found the Solution - set the Option “Connect null values” to “Always”…

Regards,
Hans

1 Like