- Grafana Open Source v11.0.0; “Oracle Grafana” plugin has been installed (v1.0)
I am trying to implement a comparison of data between today vs 1 week ago vs 4 weeks ago. I implemented this in the Enterprise version using the timeshift one 1 query. However the timeshift is not processing in thisOpen Source version.
This is the query:
SELECT count(*) AS Today
FROM cus_ord co
WHERE co.ENTERED_DT BETWEEN $__from AND $__to
FYI - $__timefilter(co.ENTERED_DT) did not work
I cannot hardcode it since i would need variable comparison - last 2 hours or last 6 hours etc.