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.

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

fcuarteros
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

fcuarteros_0-1674835623596.png

rajeshtv
8 - Asteroid

Solution

hgray005
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 :) 

kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_88_KU.png
subhajit843
8 - Asteroid

Done

Daniel1127
8 - Asteroid

Solution as attached. 

Filippo
6 - Meteoroid

My take on the challange.

Spoiler
Alteryx_88.png

gaoa
11 - Bolide

Solution:

 

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

Solved

ChrisCode007
8 - Asteroid

this is my solution