Challenge #264: Sliding Totals

[ellen-wiegand]

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

[NicoleJohnson]

My solution!

Spoiler

Cheers!

NJ

[johnemery]

A fun return to the weekly challenges after a long hiatus

Spoiler

[SgdPackard810]

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]

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.

[LHolmes]

Fun challenge!

Spoiler

[JonathanAllenby]

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.

[mbogusz]

Spoiler

[Alteryx_AR]

My solution.

[RakshithNayak]

Find the solution