Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution:
Interesting case, thanks!
I just checked your solution @ChristineB and I love the macro use! I used multi-rows to identify then duplicate the end/start points of each segment (posted above), but you made me think differently about how I could have approached this. Thanks!! :)
This has so many practical applications! Awesome challenge! I was actually able to download Harvey data from NOAA and layered it onto sales performance which made a really cool page visualization on Tableau!
Really fun challenge! I, like many other posters, at first solved this very quickly only to notice that the average intensity numbers weren't quite right. A little bit of elbow grease and a few extra tools and I had it.
Thanks for these challenges, they're making me much better with Alteryx than I would be otherwise.