ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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 #3: Running Averages

Vidya26
Astéroïde

Running Avg Solution!!


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Here is my solution


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Heather_Zhu
Météoroïde

See solution attached!


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

bnelly1987
Astéroïde

Great Challenge! Learned some new stuff about the Multi-Row Formula


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

vpsanchez
Météoroïde

Greetings,

 

   My solution is much like other people on here. In lieu of dividing the multiple rows by 3 or 6, I used the AVERAGE function. Also got the chance to use the Imputation tool! I learned a lot from this exercise.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Cosmin_S
Astéroïde

My solution is very similar to other solutions around here. I picked IIF function to compute the averages.

 

Thank you.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

cgoodman
ACE Emeritus
ACE Emeritus
Révélation
challenge 3.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
lavanyadurai
Météore

I have attached my solution


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

brandowd
Astéroïde

here's my solution. I'm still new at this and just comparing the solution to mine there's still more I need to learn. Mine was bit more basic and less flexible but I learnt more from walkting through the solution


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

kelly_gilbert
Pulsar

@brandowd that's one of the best things about Weekly Challenges (learning from other solutions)!

 

In addition to the provided solution, be sure to check out some of the other user-posted solutions as well. I always learn some new tricks each week!