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

Tyro_abc
11 - Bolide

❤️ 

Spoiler
Tyro_abc_0-1619009634594.png

Best Regards
Arundhuti

kceleven
6 - Meteoroid
Spoiler
kceleven_0-1619012286512.png

 

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1619015221828.png

 

aruiz-itp
11 - Bolide

here the solution!

CatheyH
6 - Meteoroid

Well that got ridiculously complicated before it got tidied up!

Nice curly one, thanks Joe

Spoiler
Screenshot Slider.png
cchandler21
Alteryx
Alteryx

Solution attached

mike_w
8 - Asteroid

I was able to do this essentially with the Summarize tool, but I was looking for something else initially: It would be great to have a function that works like an on/off switch, as in: "if I encounter this value then 'on' (eg '1'), if I encounter it again then 'off' (or 0)" (This principle could repeat)

Surprisingly, I couldn't find such! 

Spoiler
mike_w_0-1619039990059.png

 

KaneG
Alteryx
Alteryx

I didn't read the question on the forum, just in the workflow and so made my answer to work if an ID was to appear >2 times. Little iterative macro..

 

Spoiler
The Workflow:
KaneG_0-1619067261001.png



And the Macro:

KaneG_1-1619067344146.png

 

LukeM
Alteryx
Alteryx

Great challenge @JosephSerpis !

 

Batch macro may have been overkill but its effective!

 

Spoiler
SNAG-22-04-2021 06.03.28.png
camilb
8 - Asteroid

Two approaches:

 

  1.  A good approach to solve it with a couple of tools.
  2.  A heavily manual approach using Samples to get the output.

 

Spoiler
challenge_264_sol_camilb.png

Way happier with the first approach though.