Challenge #3: Running Averages

[Calliecobbs]

Here's my solution!

Spoiler

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

[Jbrooks]

Spoiler

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

[jwlong91]

Fun challenge!  I did this using basic Alteryx tools as well as tried using the Python tool for a "one tool solution".  My first attempt at creating a Python solution was very slow, so I took a second stab at it and it ran much faster.

Spoiler

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

[MikeHinz]

Spoiler

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

[Marcel_Gavrila]

Here's my solution!

Spoiler

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

[Nikos_I]

My solution is a bit more messy, meaning that if we had a million columns to do calculations it would take a million times to apply the multi-formula tool. Not very practical. But it was what stroke first as a possible solution.

However, I post this solution because upon testing the calculated and the expected results I noticed an error of the magnitude of -13 which is probably to the machine error in the division in the multi-formula calculations.

I just noticed that before the test in the actual solutions the numbers are transformed to integers. Would this be considered a good practice? (Probably not if data involve big numbers)

Spoiler

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

[Hobbs1292]

Here's my solution for #3. Thanks,

Will

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

[Niklas]

Challenge done and attached. Reconciliation was hard as there is some inconsistency i the answer headers.

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

[Etienne]

Solution attached

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

[FRANCK_ROUQUETTE]

solution similar to others - great exercise

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