Yearly, monthly, weekly and other recurring graph

Hi,
is there a way to show a yearly recurring graph ? I want to show the values in years 2017, 2018, … over a year to compare them, over a given period, I created a query using EXTRACT(doy from "Start_date") AS "time" to share the same time between years and (EXTRACT(year from "Start_date")::numeric)::text as metric to give the year as metric name, but the graph insist in showing the full period and the values are seen at the beginning of the epoch in 1970.

Thanks.

Hi, did you find any solution?

Yes, using

or

Thanks I’ll give it a try. Here where I posted the problem I’m having. I think it’s related to a bug, so I even opened an issue Same dashboard with more relative time panel - #11 by donatod