Tag Archives: filter
Tableau: filter to Keep up to current day or month of year
Calculated Field for “Keep up to current day of year”: DATEPART(‘dayofyear’, [Order 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
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
Tableau: Filter with context
I had to apply a filter on a Top N chart; select a Region, then display Top N States. When I added Region to the filter section. it showed me from the Top N states overall, only the states in … Continue reading