Date calculation with ${__to📅YYYY}

Hi!

In one of my queries (InfluxDB2, no Flux) I’m using the alias Total ${__to:date:YYYY} which resuts in Total 2026

The panel, however, shows values from a year back selected by query options. Additionally the same global variable is used in the panel’s title and again shows year 2026.

Is there a chance to show year-1 in both places? E.g. do some calculation?