2023: Week 42 - Solution
Solution by Tom Prowse and you can download the workflow here.
Step 1 - Combine Inputs
First we want to combine all 4 of our different tables given within the input. This involves a sheet for each year (5 & 6) and also a sheet for each year's contact details.
We want to first use joins to combine each of the contact details with the song choices for each year. This will need two joins
Year 5
Year 6
From here we can then combine the results of these joins using a union step and both years data should be 'stacked' on top of each other:
Step 2 - Total Votes
Next up we want to remove any song choices that don't have more than 5 votes. First, we need to total the votes for each song by using an aggregation tool to group by Year Group and Song Recommendation, and then sum the number of rows:
After we have the totals we can then filter the Number of Rows field so that it only contains data which is greater than 5
After renaming some fields we are ready to output our data that looks like this:
After you finish the challenge make sure to fill in the participation tracker, then share your solution on Twitter using #PreppinData and tagging @Datajedininja, @JennyMartinDS14 & @TomProwse1
You can also post your solution on the Tableau Forum where we have a Preppin' Data community page. Post your solutions and ask questions if you need any help!
