Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #88: Counting Combinations

Inactive User
Not applicable
 
sgrabish1
8 - Asteroid

Thanks for practice exercise!

RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_88_RODO_Solution.png
sarahjohnson
8 - Asteroid
Spoiler
sarahjohnson_0-1572545479888.png
Billigans
8 - Asteroid
Spoiler
challenge_88_solution_BL.png

Snare
8 - Asteroid

Solution attached.

 

Spoiler
Snare_0-1572979193087.png
JennyMartin
9 - Comet
Spoiler
AWC88.PNG

Found the wording of this challenge a bit confusing, but simple to carry out when I understood it!

mat_budden
8 - Asteroid

Hi All,

 

Please find my Result below, This one stumped me as i thought it was all sub combinations as well, But after working out a way to iterate through all possibles the answer was nothing like it.... In the end the answer was simple, just shouldn't over think.

 

Spoiler
Transpose, Remove Nulls, Sort, Summarize by Transaction to Concatenate, then summarize and count distinct, Done.

 

Thanks

Mat

AmeliaG
Alteryx
Alteryx
Spoiler
88_screenshot.png
apabonok
8 - Asteroid

Hi, this is my solution, by using trapose and summary tool