In Grafana I like to have a mix of time periods in my dashboards, so some that are driven by the selection and some that remain static based on what I choose.
I would like to replicate the “Today” you can choose from the top down but do it in the query so it won’t be changed by what I choose.
So something like this;
SELECT count("blink") FROM "house" WHERE time = today()
Hopefully this makes sense, any suggestions?