We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #264: Sliding Totals

ellen-wiegand
Alteryx
Alteryx

solution #264, wherein I admitted defeat to the batch macro

 

NicoleJohnson
14 - Magnetar
14 - Magnetar

My solution!

 

Spoiler
WeeklyChallenge264.JPG

Cheers!

NJ

johnemery
10 - Fireball

A fun return to the weekly challenges after a long hiatus

Spoiler
Solution.PNG
SgdPackard810
7 - Meteor

Gotta say, as much as I love Alteryx, it's a bit painful that windowing requires so many tools on the canvas. If I wasn't restricting myself to using only set tools, def would've just dropped a python tool onto the canvas and written a little code.

kelly_gilbert
12 - Quasar

Ooh, this was a fun one - thank you for submitting @JosephSerpis!

 

My solution is pretty similar to all of the other non-macro solutions, except I attempted to handle multiple instances of the same ID.

 

 

Spoiler
I made the assumption that if there were multiple instances of the ID, that I'd need to sum the range between instances 1-2, 3-4, 5-6, etc., and would ignore the range between instances 2-3, 4-5, etc. Basically, odd instance = start, and even instance = stop.

kelly_gilbert_0-1619804396964.png

 

LHolmes
8 - Asteroid

Fun challenge!

 

Spoiler
264 - Solution.PNG
JonathanAllenby
8 - Asteroid

Here's my solution.

Spoiler
Decided to wrap it in a batch macro. Only issue was it had two rows for each ID instead of 1, so I had to group it to remove the duplicates.JonathanAllenby_0-1619947739016.png

JonathanAllenby_1-1619947761789.png

 

mbogusz
8 - Asteroid
Spoiler
2021-05-03 08_38_21-Greenshot.png
ArtiRajput
8 - Asteroid

My solution.

RakshithNayak
5 - Atom

Find the solution