We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #301: New Year's Resolutions

reyreygg
7 - Meteor
Spoiler
reyreygg_0-1642486870069.png

 

BMorgan1390
8 - Asteroid

Who tried to upload a PDF?

Watermark
8 - Asteroid
Spoiler
MT Solution 301.png

ssrika2
6 - Meteoroid

Excellent 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.

pmukhi12
5 - Atom

Weekly Challenge 301

Ashuu11
7 - Meteor

Uploading my solution.

prateekgid
7 - Meteor

Please find my solution attached here

AJ_23
7 - Meteor

My Solution

DalilaSalinas
8 - Asteroid

ti

Rupal03
8 - Asteroid

Here is my Solution