Monthly Archives: December 2014
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: toggle between charts
If you need to toggle between charts you have to: – create a sheet for each chart – create 1 string list parameter, which you place on each sheet, display parameter – create a calculated field referencing the parameter – … Continue reading
Tableau: Order of Execution
Order of Execution in Tableau: Computed in the database: 1. Context filters 2. Top N and conditional filters 3. Regular quick filters Computed in Tableau: 4. Table calculations are computed 5. Table calculation filters are applied 6. Reference lines This … 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
Tableau: Waterfall chart from Budget to Actual
It has been a while since I posted anything. Currently I am exploring Tableau Software, as I encounter some challenges as well, I decided to post those in a separate section. This will be the first post. I did not … Continue reading
