My attempts to solve the Workout Wednesday challenges
You can see my entry here. Lessons Learnt ● I spent far too long on this! I’ll try to take a much simpler approach next time. ● It is difficult to balance background images that cover the whole dashboard with visual clarity. Not sure of the best solution here. To be practised. Or maybe avoided. ● More to come after feedback! Makeover Monday Whilst I deeply love playing with mathematics and geometry in Tableau, I’ve felt a bit weak on…
Lorna gave us another challenge today based on the geo calculations in Tableau. Challenge PageLorna’s solution on publicData for the challengeMy solution on public The challenge is to create a map of crimes in London and filter and colour them according to their distance from a selected central point, either St. Paul’s Cathedral or Buckingham Palace. It was mostly pretty straightforward, except for a couple of dumb mistakes I made, which had nothing to do with the crux of the…
A fun little challenge this week from Luke. It was one of those where if you hadn’t already worked with certain concepts, it would be really difficult, but not too bad if you had. Fortunately, I had and when I saw the challenge, I knew I wouldn’t have too much trouble (in principle!) It also had the benefit, that the difficulty was in the concept, so it’s pretty quick to build if you already know the techniques. In essence, this…
Lorna’s challenge this week is all about the new set actions available in 2020.2 and was inspired by the training that Bethany recently gave on this topic. Fortunately, I attended this training, so I’m hoping not to have too many problems. The key ability that has been added is being able to individually add or remove members from a set. Think of the old school yard scenario of two “captains” picking members in turn for their teams. Here there are…
Can you compare a 3-day vs. 14-day moving average and describe the latest trend? Ann’s challenge this week is based on COVID-19 data and is an exercise in table calculations. Excellent! I feel I’m slowly getting to grips with these, so I’m intrigued to see how I get on. The core challenge is to calculate 3-day and 14 day moving averages and to compare them. Ann’s challenge on Workout WednesdayThe official solution by Jami Delagrange on Tableau Public My solution:…
Bar charts. Or are they? Requirements on the WOW websiteLuke’s solution on Tableau PublicMy solution on Tableau Public This week’s challenge from Luke looks at first blush to be a fool’s errand: why would you want to abuse lovely Tableau to create a chart that looks like an Excel chart? However, I’m sure, as ever, there’s more to this than meets the eye. Below are Luke’s chart and the standard equivalent in Tableau for comparison: Note that the Tableau bars…
A challenge involving a new chart type, described as “a bi-dimensional chart (alternative parallel chart)”. Requirements on the WOW websiteIvett Kovács’s solution on Tableau Public My solution: The Journey The first challenge is working out what the chart is supposed to show and how to read it. Certainly not a chart type for the casual user, more something that succinctly shows information to regular users of the dashboard. The solution looks like this: If you understood that straight away, then…
This challenge from Lorna focuses on creating dashboards for use on mobiles. As such, the calculations and worksheets are not complicated. It’s all about the dashboard formatting. Lorna links to a handy article from Bridget Cogley, which gives some tips. I think the main idea here is to build the default dashboard layout in such a way that Tableau’s automatic layout feature converts the dashboard successfully into a mobile format. Lorna set her public solution such that it can only…
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…
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…