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

Rima1776
8 - Asteroid

Solution Attached

iamme012397
8 - Asteroid

FUN TO LEARN NEW THINGS

treepruner
9 - Comet

I did have to peek at the solution to get unstuck...

Gomes
8 - Asteroid

See my proposed solution.

AnaisComyn
9 - Comet

Done ! 

DPRC
8 - Asteroid

Learned more about DTC tool and Multi Row Formula doing this challenge than I thought I would....delighted to have done so.

kevin025
8 - Asteroid

Looks easy but actually very challenging without knowing the use of Generate Rows

Challenge#106.png

JoePC
9 - Comet

Solution Attached

KilianL
Alteryx Alumni (Retired)

I didn't think of generating rows, but it seems like the most dynamic and efficient solution here.

 

I approached it with the Multi-Row Formula, but if there are bigger full overlaps in the data, the results will not be correct.

 

Spoiler
106 - Lights On - KL.png
carmenrapariz
8 - Asteroid
Spoiler
Challenge 106.PNG