Challenge #3: Running Averages

[PeterGoldey]

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.

[bryanbumgardner]

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.

[jlaverne]

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.

[Christen_Marshall]

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.

[kvnpt]

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.

Spoiler

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

[jfgirouard]

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.

[EEdLoh]

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.

[danrh]

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

[ydmuley]

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.

[jevon]

Spoiler

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