Add 1 month to a time with a transformation

  • What Grafana version and what operating system are you using?
    v9

  • What are you trying to achieve?
    I would like to link to a dashboard that display 1 month of daily data starting from a panel with monthly data.

  • How are you trying to achieve it?
    I tried different things, for instance working with from and to variables, but I’m unable to add 1 month to the to variable.

So? I’m trying to add a new field with the To variable already evaluated in the query in a transform operation, but without success for the moment.

  • What happened?
    The value is not evaluated with 1 month added.

Thanks

Did you try Query options?

Query options

No, I tried to change the date range in the time picker with the variables from and to, from a datalink.
I am able to set FROM with the correct timestamp, but are not able to set TO with FROM + 1 month,