Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAExcellent Challenge..! Attached is my solution with comments on the Solution Path.
Solution Path
1. The first 2 paths are for questions 1 and 2 which primarily look at the resolutions taken by different groups. 3rd path is for Question 3 which looks at groups and whether they were able to do the resolution either fully or part of it.
2. For Q1 and Q2, we need only the top half of the data - record IDs from 4 to 31. Made use of dynamic rename to get the resolutions as the headers and then Transposed it to get the values by Group. For Q1, directly the resolutions can be summarized. For Q2, we first need to filter out Suburban Men/Women and Summarize only for Fitness related resolutions.
3. For Q3, we need the bottom half of the data - Record ID after 34. Remove all unnecessary blank fields and then dynamic rename to get the Yes/No as the headers. Directly summarize based on Group and look for the Top 1 descending which comes out to be college graduates.