Introduction This weeks challenge came to me through a Data School consultant trying to figure something out. We figured for their workbook it would take a full rebuild, but it gave me inspiration to try and do it from scratch. So today I present to you a KPI dashboard, where you can only pick a …
#WOW2023 Week 37: SDG Goals showing a maximum of 6 Read More
Introduction Recently, I needed to build a dashboard from some pre-aggregated, segmented data counting unique users. This created some difficulty, because we may want to look at overall numbers, or one segment, or multiple segments, and that changes the user counts. Each of these have their own level of aggregation in the data, so it …
#WOW2023 Week 36: Can you build a dashboard for pre-aggregated metrics? Read More
Introduction I’m always on the lookout for ideas for challenges. Typically I’ll see something someone has done and want to know how they did it and whether I can craft it into a WOW challenge. When my colleague, Sam Parsons, demonstrated the concept of an interactive Viz In Tooltip (VIT) at Tableau Conference this year, …
#WOW2023 | Week 35 | Can you build an interactive Viz in Tooltip? Read More
Introduction I’m so excited to invite Felicia Styer to the blog for this week’s challenge! Felicia is the Associate Director of Analytic Solutions at Playfair Data and hales from Kansas City, MO. Connect with her on Twitter and LinkedIn and here is her challenge! Long time fan, first time contributor! This week’s challenge is question …
Introduction This week I have a full-on Tableau Spatial challenge for you. Just one worksheet. Minimal formatting. It’s all about the behind-the-scenes magic. Enjoy! Click to open in Tableau Public Requirements Dashboard Size: 1000 x 800px 1 sheet Create a map of the 48 ‘contigous’ (aka: mainland) US States Plot points for every City in …
Introduction This week we have a special guest, Venkatesh Iyer. Venkatesh is currently a Senior Analytics Consultant at phData–and has recently written a number of blogs that bring novel solutions to the community, including: How to improve the performance of count distinct How to Create a Drill Down Table in Tableau How to paginate in …
2023 Week 32: Can you show all values when filtering? Read More
Introduction I am a big fan of Level of Detail calculations and this one is an oldie but goodie! That is the main focus this week, but also uses Parameter Actions & Viz in Tooltips. Click to open in Tableau Public Requirements Dashboard Size: 600 x 600 Two Sheets Find the most popular sub-category by …
#WOW2023 W31: Can you find the most popular sub-category by sales per state? Read More
Introduction We’re continuing retro month this week, and I decided to re-viz Andy’s Week 41 challenge from 2017. I chose this one because I really like the concept of being able to drill down from state into city on the same chart, but I wondered if things would be easier than the calculations required to …
WOW2023 Week 30: Can you build a dynamic drill down scatterplot in one view? Read More
Introduction For retro month at WOW Towers, I decided to go way back into the archive and focus on a challenge that was set by one of the original WOW coaches, Emma Whyte, in May 2017. The original challenge looked like the below image and provided a visual representation of the results of a blind …
#WOW2023 | Week 29 | Re-viz : Blind leading the blind Read More
Introduction This is week 28 of 2023 and week 2 of #RE-VIZ-IT and I’m bringing back my VERY FIRST #WOW challenge from WAY BACK in the summer of 2018! I chose this challenge because “back in my day” this use case required additional sheets, a “custom” chart and a lot of sheet swapping. If you …
