$__interval_ms compatible macro

fr-ser / grafana-sqlite-datasource

Grafana Plugin to enable SQLite as a Datasource

Apache License 2.0

123 stars 17 forks source link

$__interval_ms compatible macro #117

Closed TuomasKiviaho closed 3 months ago

TuomasKiviaho commented 10 months ago

Currently there is no macro suitable for handling interval cast(time / ($__interval_ms / 1000) as int) * ($__interval_ms / 1000) since division can't be done in the macro parameter (that I'm aware of)

https://github.com/fr-ser/grafana-sqlite-datasource/blob/e35eef3e527f4ef810e952cabd8592d8522124f2/pkg/plugin/macros.go#L51

I believe there is something a kin in the postgre data source

fr-ser commented 10 months ago

I am not sure I fully understand the scenario. Could you provide a sample query with some data in a CTE or subquery and explain based on that what you are trying to see and what is missing?

github-actions[bot] commented 4 months ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.