Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAUpdating workflow with updated challenge information & to add spoiler to get challenge tracker to work correctly.
Solution attached. I realized when looking at Alteryx's solution that my workflow is not robust enough to handle varying part groups as I created a column for each permutation of bucket manually using a formula. I had forgotten about the Concatenate function of the Summarize tool. Very interesting to see other people's solutions and realize there is a better way to do it.