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])

Filed under Tableau | Tagged , , | Leave a comment

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

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

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