Grafana text comment from database show on plot

1

Hello everyone,
Im newbie with grafana and searching for litlle help. On next picture you can see my current graph / using default grafana graph from grafana dashboards/. Everything is working awesome. I have some data here ordered by timestamp, but is it possible to add to the graph also “dovod_spustenia and komentar”? Datatype in sql database for both is in textformat.

grafana
grafana1024×768 90 KB

current query for graph

SELECT
UNIX_TIMESTAMP(DATUMCAS) as time_sec,
TEPLOTA_UL1 as ul_hore,
TEPLOTA_UL2 as ul_dole,
VLHKOST as vlhkost,
BATERKA as baterka,
VAHA as vaha
FROM ul1
WHERE $__timeFilter(DATUMCAS)
ORDER BY DATUMCAS ASC

2

I can’t imagine how to visualize texts in the graph without loss of graph readibility. You may try to use annotations for that.

3

Yes, I totally agree I tried with my very basic skills almost everything. Many thanks for your advice. Now working as I want. What will be absolutelly perfect, is if the comment will be editable from grafana plot to sql. But I think im dreaming. :smiley:

grafana
grafana1366×768 85.2 KB

query for my annotation, May someone help

SELECT
UNIX_TIMESTAMP(DATUMCAS) as time_sec,
wakeup_reason as text
/this must be as text/
FROM ul1
WHERE $__timeFilter(DATUMCAS)
ORDER BY DATUMCAS ASC