Select specific day over last X years?

[asteroids]

I have a database with one entry per day. Is there a way to display a specific day over the last, say, three years?

For example: show a graph with the values of April 24, 2015-2017 next to each other.

[torkel]

There is no way to do this currently

[asteroids]

I thought about it again: what about giving those days a speficic tag in InfluxDB and then use templating to select just this tag, zoom out heavily and then the graph just shows these days?

[daniellee]

This might not be exactly what you want but have you looked at Time Shifting and Series overrides? It is definitely possible to show these values in different panels with time shifts. Unfortunately InfluxDB has no support for time shift functions yet but maybe in the near future.

Advanced Graphing (Part2): Visualize timeshift

The Graphite time series query language supports time shifts, so you can compare one metric against itself but for a different time range. [image] For example in the graph above we show dashboards downloaded on grafana.com/dashboards grouped into 6 hour buckets. You can also see the series but last week so you can easily compare how the current values compare against the week before. If you zoom out so the time range is bigger then the time shift you can see how the green line is mirrored in…

http://play.grafana.org/dashboard/db/time-range-override?orgId=1

[asteroids]

Thanks, will try that out!