Challenge #88: Counting Combinations

[fcuarteros]

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

[rajeshtv]

Solution

[hgray005]

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]

Spoiler

[subhajit843]

Done

[Daniel1127]

Solution as attached. 

[Filippo]

My take on the challange.

Spoiler

 

[gaoa]

Solution:

Spoiler

Hint: concatenate and count distinct values.

[Crispy131]

Solved

[ChrisCode007]

this is my solution