We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.
alteryx Community

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

## Challenge #88: Counting Combinations

5 - Atom

Haven't seen anyone use the tile tool. Here's my take on it by assigning each item a unique value then finding the standard deviation albeit being a teeny bit slower.

Spoiler

8 - Asteroid

Solution

5 - Atom

This was a fun one! First day using Alteryx so didn't know the best tools for the job. Relied on the Prime Factorization Theorem to solve this one: replace each item with a prime number and all null values with 1, then multiply all fields together and group by unique composite numbers.

Thanks everyone for posting your solutions, learning lots in the replies :)

8 - Asteroid
Spoiler
8 - Asteroid

Done

8 - Asteroid

Solution as attached.

6 - Meteoroid

My take on the challange.

Spoiler

11 - Bolide

Solution:

Spoiler
Hint: concatenate and count distinct values.
8 - Asteroid

Solved

8 - Asteroid

this is my solution