Hello. I have database in MySQL and there are such values.
Using the plug-in MySQL in Grafana and we get next results:
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.
UNIX_TIMESTAMP(’%Y-%m-%d’ ‘%H:%i:%s’) as time_sec,
avg_ooa as value,
‘avg_ooa’ as metric
ORDER BY date ASC;
Please help to create the correct query.