Grafana Enterprise to OSS migration - Oracle DB timeshift

  • 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.

This is OSS version - we cannot opt for licensed version

I guess it is:

It is third party = you can contact developer and ask to fix your issue or you can fork it and fix your issue.