Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
be sure you don't have any selection
dimension =DAY(Date)
measure
=Sum({<Date = {">=$(=Max(Addyears(YearStart(Date),-1))) <=$(=Max(Addyears(YearEnd(Date),-1)))"} >} Visits)
=Sum({<Date = {">=$(=Max(YearStart(Date))) <=$(=Max(Yearend(Date)))"} >} Visits)
@Taoufiq_Zarra Ah, I had an uncleared selection that I had to remove. Now it works! Thank you! 🙂