Good Day,
I’m using Grafana to monitor an application. Besides the usual server monitoring I’m trying to create a dashboard to monitor business data as well. I’ve successfully setup a working connection to my MySQL database. Now I’m trying to visualise some data.
The application itself stores bookings in the database. I’m trying to display those bookings in a graph formatted as a time series. The problem is that the entries provide columns for a start and end date. Now I don’t know how to create a working graph using these two columns. I need both of them to know whether an entry is active in the given time range or not.
SELECT
COUNT(*) AS “value”,
validfrom AS “time_start”,
validtill AS “time_end”
FROM booking
WHERE validfrom BETWEEN $__timeFrom() AND $__timeTo()
AND validtill BETWEEN $__timeFrom() AND $__timeTo()
GROUP BY validfrom, validtill
ORDER BY validfrom, validtill;
I know that the above won’t work because I need to provide a column named time. But in my case I need two times and I don’t know how to connect them both. Is this even possible with grafana or do I need to use something else?
Thanks for any assistance.
Kind Regards,
John