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

Solved this and talked over with colleagues. We agreed that the solution was not quite right for the first 3 and 6 months of each RM Category. Maybe that's what the hint was meant to address. We felt it was right to do as you would a real running average where the first 2 months are averaged, then 3, 4, 5, and 6 and not use the value of the closest row as it weights oddly.

Solved this and talked over with colleagues. We agreed that the solution was not quite right for the first 3 and 6 months of each RM Category. Maybe that's what the hint was meant to address. We felt it was right to do as you would a real running average where the first 2 months are averaged, then 3, 4, 5, and 6 and not use the value of the closest row as it weights oddly.

Output crashes my alteryx to hard to compare but think this is right

solved with multi row formula

I wonder if the solution given is correct but here is my workflow

Rachel Lynch

solved

Finally got it

This one was pretty hard, had to use formula tool twice since for some reason it went back to being null

curated machine learning resources

Join the weekly challenge takeover