Tag Archives: relative date
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 chart, filter, previous year, relative date, tableau
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
