Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #106: How Long were the Lights On?

JamesCameron
8 - Asteroid

My Effort - first of 2020. Happy New Year!

 

Spoiler
JamesCameron_0-1577964273969.png
bjkay30
8 - Asteroid

This was an interesting challenge.  I ended up creating a really complicated IF statement in a multi-row tool, but I'm sure I didn't capture all of the potential possibilities, just the ones that appeared in the dataset.  

 

After looking at the solutions with the generate rows tools, my mind is blown.  Such a simple, elegant solution.

 

Spoiler
bjkay30_0-1578003450466.png
brudnicki
7 - Meteor

My overcomplicated solution in the attachment

joshuaburkhow
ACE Emeritus
ACE Emeritus

**bleep**, totally forgot about generate rows! 

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
jfone
8 - Asteroid
 
Aswin
8 - Asteroid
 
nivi_s
8 - Asteroid

Solved!

 

Spoiler
nivi_s_0-1578606192324.png
JonathanW
8 - Asteroid

solved 

 

Spoiler
JonathanW_0-1578627874011.png
rmassambane
10 - Fireball
 
Marcel_Gavrila
8 - Asteroid

Here's my  solution!

Spoiler
{00D4F437-3259-477B-B4AE-5AEBACF4F02E}.png.jpg