Browsed by
Tag: WOW

WOW2020 Week 27: What is the distribution of total orders by customer?

WOW2020 Week 27: What is the distribution of total orders by customer?

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…

Read More Read More

2020 Week 25: Can you add and remove items from a set?

2020 Week 25: Can you add and remove items from a set?

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…

Read More Read More

WOW2020 Week 24

WOW2020 Week 24

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:…

Read More Read More

WOW2020 Week 23: Can you excel at bar charts?

WOW2020 Week 23: Can you excel at bar charts?

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…

Read More Read More

WOW2020 Week 22: Profitability spotlight – is your budget recovered?

WOW2020 Week 22: Profitability spotlight – is your budget recovered?

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…

Read More Read More

WOW2020 Week 21: Can you design for an automatic phone layout?

WOW2020 Week 21: Can you design for an automatic phone layout?

Comments 0 Comment

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…

Read More Read More

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

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

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…

Read More Read More