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
Alteryx Partner

this one was fun


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

Highlighted

For some reason, my output data titles were messed up and I had to modify to make everything match.

 

This one was hard!


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

Highlighted
Meteoroid

Great exercise.  Love using the multi row tool.


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

Challenge 3 done... I wish I had had something like this when I was calculating admissions and readmissions when I was working in healthcare data! 


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

Highlighted
Meteor

I took a very different approach by spamming the copy paste button, the the results are there.  I like the official solution better.  Need to get used to thinking that way.

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

Highlighted
Meteor

Interesting one.  I had a different approach to start with, which was to treat fields individually for 3mo and 6mo averages, but that would have been a cluster of multi-row formula objects.  This was a good opportunity to try out a dynamic approach instead.


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

Highlighted
Asteroid

Transpose, Multi-Row, Cross-Tab Join


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

Highlighted
Pulsar

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

Highlighted
Quasar
Quasar

A great learning on using multi-row formula tool for calculating 3M & 6M Averages! Loved this challenge

 

 

The solving thrill continues!!!!!!!!!!!!!!!!


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

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