3 ms·
There is the timeshift function in the query editor but that is per panel and not per query. So you would have to have a panel per year. It should be possible
by danlimerick 6y ago
There is the timeshift function in the query editor but that is per panel and not per query. So you would have to have a panel per year.
It should be possible with SQL but it is trickier. TSDB's like Prometheus, Graphite and Influxdb (Flux) have the timeshift function built into their query languages. (https://community.grafana.com/t/advanced-graphing-part2-visualize-timeshift/365/11 https://community.grafana.com/t/advanced-graphing-part2-visu...)
- danlimerick 6y agoWe are also working on an expression language to backfill other data sources. You can see the frontend version of this - transformations in 7.0. The backend version which will support functions like timeshift is in alpha for now. Hopefully it will be officially released in the near future.