Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

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
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1619015221828.png

 

randreag
11 - Bolide

here the solution!

CatheyH
8 - Asteroid

Well that got ridiculously complicated before it got tidied up!

Nice curly one, thanks Joe

Spoiler
Screenshot Slider.png
cchandler21
Alteryx Alumni (Retired)

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 Alumni (Retired)

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
Moderator
Moderator

Great challenge @JosephSerpis !

 

Batch macro may have been overkill but its effective!

 

Spoiler
SNAG-22-04-2021 06.03.28.png
camillb
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.