Tag Archives: previous year

Tableau: Relative Date Filter over year change

In case you want to compare years when filtering on last x weeks and have the year comparison over the year change (week 53 and week 1), you can’t use a relative date calculated field filter as this method transforms … Continue reading

Filed under Miscelleneaous, Tableau | Tagged , , , , | Leave a comment

Tableau: Trend chart Previous Years in Current Year

Use the following formula to display Current and Previous Years trend lines while having a Relative Date filter: Relative Date: DATEADD(‘year’,DATEDIFF(‘year’,[Order date], today()), [Order date]) This formula will add 4 years to orders made in 2010 (if current year is … Continue reading

Filed under Tableau | Tagged , , , | Leave a comment