Hi @koot,
In addition to Max’s suggestion, here are a couple other options:
- Create calculated fields to partition the data
- Create separate datasets for each year and then display the visualization for each data on top of each other (see here)
I did prototype the first option with moderate success:
The calculated fields for these are:
date_month => extract(‘MM’, {Date})
date_month_2 => formatDate({Date}, ‘MMM’)
year=2019 => ifelse(extract(‘YYYY’, Date) = 2019, Value, null)
year=2020 => ifelse(extract(‘YYYY’, Date) = 2020, Value, null)
The biggest issue you run into is that the formatDate() function returns a string, which then messes up the calendar sorting. You can use the truncDate field, but then the year is implicit and the X-axis will show more than a single year. e.g.
Let me know if this helps.
ws