Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #3: Running Averages

Dev73
8 - Asteroid

My solution 

Spoiler
challenge 3.jpg
leonardstarrk
8 - Asteroid

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
13 - Pulsar
Spoiler
スクリーンショット 2024-03-24 093210.png
jgvillalta
6 - Meteoroid

My solution.

msobyjr
6 - Meteoroid

they betta recognize

Ed2000
8 - Asteroid
Spoiler
Screenshot 2024-04-24 150346.png
CE_5085781
6 - Meteoroid

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
Screenshot 2024-04-25 171244.png
barrymoe
7 - Meteor

Needed to cheat on this one. 

Bobbyt23
12 - Quasar

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
7 - Meteor

🏁