Challenge #3: Running Averages

[Dev73]

My solution 

Spoiler

[leonardstarrk]

Honestly I didn't understand this challenge even after looking at the solution file. Had to see other users' solutions to understand what the challenge actually was about.

Even now I'm still a bit confused.

[DaisukeTsuchiya]

Spoiler

[jgvillalta]

My solution.

[msobyjr]

they betta recognize

[Ed2000]

Spoiler

[CE_5085781]

Found this one very difficult, especially given the target output, which is not what I would have used/done.

I ended up creating a different output view, leaving the Category as a Column and adding the running averages as extra columns at the end.

Creating separate columns for 3M and 6M averages, perhaps I didn't understand the question?

Spoiler

[barrymoe]

Needed to cheat on this one. 

[Bobbyt23]

Interesting this one and not as straightforward as I first thought.

Spoiler

Took me a bit of time to get my multi row calcs right. One day I'll remember the difference between crosstab and Transpose too, without having to look at the images 🤣

[Selasi]

🏁