# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

## Challenge #3: Running Averages

Highlighted
Quasar

Handled this with a macro, but would've loved to turn it into a single macro... The awesome macro logic is from CReW macros!

Update after looking at the solution: Went way complicated... Forgot about that simple transpose trick

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

Highlighted
Atom

Hi All,

Through trial and error I finally came up to the solution that surprised me a bit :).

The pattern is that we need to apply two (similar) calculations to a few sets of data (grouped by HP Category).

After cleaning NULL values I applied multi-row formula tool 12 times and it worked fine, 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.

Meteor

my solution

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

Highlighted
Meteor

Found my solution. This link helped me a lot!

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

Highlighted
Asteroid

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.

Highlighted
Asteroid

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

Highlighted
Meteor

Not as elegant as others solutions but it got the result I was looking for!

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

Highlighted
Meteor

Mine is slightly different than the solution provided.  I used an extra column called avg_name to determine whether it is a 3mo or 6 mo and then did a union before my crosstab.

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

Highlighted
Alteryx Partner

Here's my solution

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

Highlighted
Asteroid

Interesting one. Used a CrossTab, 2 Summarize and a Transpose.

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