How to define "before current day previous year"

Get Help
1

Most of KPI tracking involves some comparison vs previous year.

I have created a segment by using “Current Year”, which is the dynamic date range between 01/01 and whatever day we’re on.

How can I create another segment reflecting the same date range but in previous year?

So basically for today it should calculate:
ThisYearToDate: 01/01/2020 - 26/05/2020
PreviousYearToDate: 01/01/2019 - 26/05/2019

but next week it should update to
ThisYearToDate: 01/01/2020 - 01/06/2020
PreviousYearToDate: 01/01/2019 - 01/06/2019

2

Hi @Bahadur
That’s relative dates at a higher level:
https://github.com/metabase/metabase/issues/4083 - upvote by clicking :+1: on the first post
The only way to do it currently would be with in a SQL question with some trickery.

3

clicked upvote :slight_smile:
thanks!