I have created a Dashboard in Grafana with using InfluxDB as Backend. Now I want to use my Retention Policies in Grafana.
I have following retentions:
1day -> 10 secounds Data
1 week -> 5 min Data
1 Month -> 15 min Data
3 Month -> 30 min Data
1 year -> 24h Data
my continuous query for example 1 week is:
CREATE CONTINUOUS QUERY <name> ON <database> BEGIN SELECT mean(value) AS value INTO <database>.<retention policy>.:MEASUREMENT FROM <database>.<retention policy>./.*/ GROUP BY time(5m), * END
now i want to use the retention policy one week in my dashboard with only using the time periods from grafana and dont want to change everytime the retention in the graph-query.
can someone help me please?
i dont want to change anytime the retention policy in the graphs like in the picture: