Challenge #3: Running Averages
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Dev73
8 - Asteroid
03-22-2024
02:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution
leonardstarrk
8 - Asteroid
03-23-2024
01:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DaisukeTsuchiya
14 - Magnetar
03-23-2024
05:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
jgvillalta
6 - Meteoroid
04-04-2024
01:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
msobyjr
6 - Meteoroid
04-04-2024
07:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ed2000
8 - Asteroid
04-24-2024
07:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CE_5085781
6 - Meteoroid
04-25-2024
09:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
barrymoe
7 - Meteor
04-26-2024
07:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Bobbyt23
12 - Quasar
04-28-2024
02:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
05-09-2024
01:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator