Challenge #3: Running Averages

[JoeM]

@AKnutson11 - Check out the configuration in the Multi-row tool. You'll see there is a 'group by' box. The groupby will repeat the logic for each distinct group. In this case, each HP category.

[iedroso]

Probably there is a more elegant solution than this one, I will have a look to other solutions later... anyway, here it is.

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

[iedroso]

I had forgotten some group bys. Here it is fixed

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

[SimonaLoffredo]

Here my solution for this challenge, I started with a bunch of multirows formula but then I thought there was an easier way using transpose and then crosstab which was cleaner solution. Good one!

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

[MJG]

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

[DanielArenas]

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

[RWvanLeeuwen]

treating missing values as the number 0 was not clear to me at the start. the reason why the value 0 is returned when it cannot be know, is still unclear to me. great solution by the topic starter, but I think it's just as good to think about why you want these rolling averages rather than bluntly calculating everything there is to calculate. feedback and or badges are well appreciated

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

[joshuaburkhow]

Getting this train going.... I call this my viking ship workflow....haha. 100 other ways to do this but this is one that works

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

[anthonyd]

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

[dsmdavid]

Definitely should remember to keep it simpler, but I like macros.

Spoiler

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