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
Astéroïde

My solution 

Révélation
challenge 3.jpg
leonardstarrk
Astéroïde

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.

Révélation
スクリーンショット 2024-03-24 093210.png
jgvillalta
Météoroïde

My solution.

msobyjr
Météoroïde

they betta recognize

Ed2000
Astéroïde
Révélation
Screenshot 2024-04-24 150346.png
CE_5085781
Météoroïde

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?

Révélation
Screenshot 2024-04-25 171244.png
barrymoe
Météore

Needed to cheat on this one. 

Bobbyt23
Astéroïde

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

 

Révélation
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
Météoroïde

🏁