Search

Close

Start Free Trial

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

Solution attached. Tricky with the gaps.

Spoiler:

Solution attached

Here is my solution! The average intensity is slightly different than the one given in the solution.

Oh Harvey

Attached my solution, a bit workaround without macro creation

Loved this and just checked out the solution, I did this without the need of a macro, cannot wait to see what others have done. 🙂

#Alteryxrocks

Like others, I first grouped by segments but encountered holes between segments. I had to create duplicate rows whenever there was a change in storm type.

My solution:

Average Intensity slightly different from official solution.