Compare two years in line chart

[Staffan]

Hello,

How do I compare the same dates in different years on a line chart? I would like to display two lines, one for 2020 and one for 2021 for comparison, not one line as in the attached screenshot.

Thanks,

/Staffan

[JordyWegman]

Hi Staffan,

Put this in the dimension:

Month( Date.autoCalendar.Date )

Year( Date.autoCalendar.Date )

You need two different dimensions for this.

Put this in the measure:

Sum( Visits )

Jordy

Climber

[Taoufiq_Zarra]

you can create two measure :

sum({YEAR="$(=Max(YEAR))"}>}Visits) for the year
sum({YEAR="$(=Max(YEAR)-1)"}>}Visits) for the year-1

and the month in dimension

[Staffan]

Thanks, 

However, this results in a single line showing 2020 to 2021. I would like to display two lines comparing day to day of april (the dataset only contains data from april 2020 and april 2021). 

My goal is something like this (but single days on x-axis instead of years):

[Staffan]

Thanks Taoufiq,

However, I get the following error when using the first measure:

[Taoufiq_Zarra]

=Sum({<YEAR = {"$(=Max(YEAR))"} >} Visits)

=Sum({<YEAR = {"$(=Max(YEAR)-1)"} >} Visits)

[Staffan]

Thanks, the function works now, but I get the same type of chart as before:

[Taoufiq_Zarra]

@Staffan  can you share a sample data ?

[Staffan]

Sure - as you can see, the data set is very simple. Just Date and Visits for april 2020 and april 2021:

[Taoufiq_Zarra]

@Staffan  if I understood correctly

you have or you  add in script Day(Date) as DAY and year(Date) as YEAR

in the UI

dimension DAY

measures:

1->=Sum({<YEAR = {"$(=Max(YEAR))"} >} Visits)

2->=Sum({<YEAR = {"$(=Max(YEAR)-1)"} >} Visits)