How to link a dashboard built on MySQL queries to a Grafana selection?

Question

MySQL

Colleagues welcome! I deployed helpdesk and connected grafana to the helpdesk (HESK) database.
I fetch data using sql queries

SELECT COUNT(*) FROM hesk_tickets WHERE category=2 AND status=4

through the visualization "Stat"

How can I bind the range of the dashboard sample to the issue?

Answer 1

https://grafana.com/docs/grafana/latest/datasource...
SELECT COUNT(*) FROM hesk_tickets WHERE category=2 AND status=4 AND $__timeFilter(dt)

Answer 2

Greetings! Can you describe in more detail the creation of a dashboard in Grafana for the HESK database?