2020 week 8: Can you create a concatenated list of values?
There is still a need for legacy reporting, how can we use Tableau to create a report where one row contains all the data? Here’s how to create a concatenated list of values
table calculations
Week 5: Where do regions rank month-to-month?
Introduction This week I wanted to share a challenge that comes from a chat that I had with Zach Bowders near the beginning of the year. Zach was shared a step-ranking visualization he was putting together and I really thought it was a great iteration of the chart type. While there have ben step-ranking charts …
Week 48: Can you build a Bar Chart that automatically combines small contributions?
How much information have you retained from Tableau Conference 2019? Are you still watching session videos (like I am?). This challenge is an homage to the amazing conference from this year. The challenge comes from something I encountered in a recent work situation. The end-user wanted to be able to automatically group together small contributing …
Week 48: Can you build a Bar Chart that automatically combines small contributions? Read More
Week 42: Can you build a comparative line chart with dynamic inputs?
This week’s challenge is taken directly from a situation I recently had on a project. The goal of the project was to be able to isolate out time periods of a specific length and compare it to the time period directly before it. So as an example, if it’s October 2019, I want to look …
Week 42: Can you build a comparative line chart with dynamic inputs? Read More
Week 38: Can you build a sales comparison chart with performance indicators?
This week I’m tackling a topic that nearly everyone has been asked – visualizing good/bad as performance indicators that are red or green. At least here in the western world, the busy executive tends to think about things in terms of traffic lights. So this week your task is to create something that satisfies their …
Week 38: Can you build a sales comparison chart with performance indicators? Read More
2019 Week 18: Let’s Compare Quarterly Sales Performance
Have you ever been asked to make a tool that allows end users to dynamically select two periods and compare them? The challenge this week takes inspiration from this all too likely to be asked request. At surface level it can be an easy ask, but how can you add on additional context along with …
2019 Week 18: Let’s Compare Quarterly Sales Performance Read More
Week 17: Can you build an automated monthly report
A few weeks ago I had this problem: I needed to create a dynamic table that showed the last 12 full months of sales for a particular channel/category of the business but I also needed to show the month-over-month and year-over-year totals. I didn’t know how to do it right away so I asked the …
Week 17: Can you build an automated monthly report Read More
2019 Week 10: How Has Our Profit Ratio Changed Nationally?
This week’s challenge is plucked directly from #IronQuest. If you’re not aware of what #IronQuest is, it’s a monthly challenge during the off season of Tableau Public’s Iron Viz feeder contest. It’s run by Sarah Bartlett and each month a different theme is chosen. Participants are allowed to submit for feedback (the idea is to …
2019 Week 10: How Has Our Profit Ratio Changed Nationally? Read More
2019 Week 9: Can you remove the scroll bar?
When I started Workout Wednesday I made a list of potential challenges. This challenge was the second challenge I wrote down. After more than 20 challenges I’ve finally gotten around to sharing it! Challenge Click to view on Tableau Public Requirements Format: 1000px by 600px Create a visualization with bar charts that show total sales, …
2019: Week 6: Weekly Orders & Sales by Segment
Those of you who know me well know that I like to create visualizations that include both detail and aggregate in the same view. I have a particular interest in showing how the smaller components contribute to the overall. When there’s one major chart on a dashboard I think it works out particularly well – …