The construction of graphs in Grafana

Grafana Time Series Panel
1

Hello. I have database in MySQL and there are such values.
Using the plug-in MySQL in Grafana and we get next results:

%D0%A1%D0%BD%D0%B8%D0%BC%D0%BE%D0%BA%20%D1%8D%D0%BA%D1%80%D0%B0%D0%BD%D0%B0%20%D0%BE%D1%82%202018-07-10%2009-31-40
%D0%A1%D0%BD%D0%B8%D0%BC%D0%BE%D0%BA%20%D1%8D%D0%BA%D1%80%D0%B0%D0%BD%D0%B0%20%D0%BE%D1%82%202018-07-10%2009-31-401823×396 51.6 KB

Now I want to draw a graph from the data, but I can’t make a valid request.
After that I get such a schedule the following query.

SELECT
UNIX_TIMESTAMP(‘%Y-%m-%d’ ‘%H:%i:%s’) as time_sec,
avg_ooa as value,
‘avg_ooa’ as metric
FROM kpi1819_noanswer
WHERE $__timeFilter(date)
ORDER BY date ASC;

%D0%A1%D0%BD%D0%B8%D0%BC%D0%BE%D0%BA%20%D1%8D%D0%BA%D1%80%D0%B0%D0%BD%D0%B0%20%D0%BE%D1%82%202018-07-10%2010-00-09
%D0%A1%D0%BD%D0%B8%D0%BC%D0%BE%D0%BA%20%D1%8D%D0%BA%D1%80%D0%B0%D0%BD%D0%B0%20%D0%BE%D1%82%202018-07-10%2010-00-091837×477 22 KB

Please help to create the correct query.

2

Who can help me ? :frowning:

3

It seems that your mysql query doesnt return any values. Try to query your mysql database with the sql string grafana generates and if you get some vlaues back.

If there arent any values try any longer timewindow.

image
image785×91 6.18 KB