Tableau – Rods, cones and a couple of neurons

WOW2020 Week 20: How much do these states contribute to the total?

13/05/2020 Tim Beard Comments 0 Comment

First challenge using 2020.2 features! WOW 2020 Week 20, version 2020.2. As Sean said, lots of 2s and 0s. This time it’s all about the new Set Controls feature which allows users to manually select members of a set in a very similar way to the current filter interface. Sean’s Challenge hereAnd his solution on Tableau Public here My Solution: This challenge involves a map of the US where a user can click on a state to add members to…

Too many subtotals!

08/05/2020 Tim Beard Comments 0 Comment

I picked this tip up from a three-second part of Luke Stanke’s build video from his (now legendary?) 10/10 Workout Wednesday 2020 Week 18 Challenge. It was very quick and easy to miss. If you create a table, you have the option under “Analysis” to add ALL Subtotals: The result it subtotals at all levels of your table. Makes sense. But what if you don’t want ALL subtotals, just at certain levels? In this example, if I just want to…

WOW2020 Week 19: Can you build a dynamic date drilling chart?

07/05/2020 Tim Beard Comments 0 Comment

This week’s Workout Wednesday Challenge was about creating a dynamic visual drilldown of a line chart. It should automatically change from a week view to a day view on selecting a range of dates. Challenge by Ann Ann’s solution on public My solution on public My Solution: Summary Create parameter and filter to limit range of the full data set, initially set to 52 weeks Create a custom date from [Order Date] based on continuous week in order to create…

Rods, cones and a couple of neurons

Cogitations and ramblings, mostly about Tableau

Browsed by
Tag: Tableau