I needed a dashboard in Grafana to show two date ranges in panels. I have used interval variable and solve it. Like this:
As seen, one line shows current day and other line shows 10 day before. But we need as a date picker. I know Grafana does not provide date picker in variables. But I want to ask that is it possible to make this using custom or text box variable? I used custom and i gave some dates as string but I couldn't convert it duration while I am querying to Prometheus. My Prometheus query is
MY_METRIC offset $daybefore