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
Asteroide

My solution 

Saqueador
challenge 3.jpg
leonardstarrk
Asteroide

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.

Saqueador
スクリーンショット 2024-03-24 093210.png
jgvillalta
Meteoroide

My solution.

msobyjr
Meteoroide

they betta recognize

Ed2000
Asteroide
Saqueador
Screenshot 2024-04-24 150346.png
CE_5085781
Meteoroide

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?

Saqueador
Screenshot 2024-04-25 171244.png
barrymoe
Meteoro

Needed to cheat on this one. 

Bobbyt23
Asteroide

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

 

Saqueador
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
Meteoroide

🏁