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 #410: Optimizing Winter Sports Inventory

lukas_olsovsky
8 - Asteroid

It took me a while to get the data cleaned and sorted, thanks for the challenge!!

Running time: 0,3sec

 

Spoiler
image.png
AGilbert
11 - Bolide

Multi-row running total on text in 'Product ID' to build groupings for cross-tab/transpose pairs.

 

Had to re-lookup how to deal with serial dates. 

 

Spoiler
Screenshot 2024-03-13 180451.png
Erin
9 - Comet

Wow I went a totally different route to line this stuff up, but still got the same answer! The route I took might be for the more visual thinkers vs fancy formula parsers...

AaronSmatta
8 - Asteroid

With Macro

adamweaver39
9 - Comet
Spoiler
challenge 410 - alteryx flow.jpg
vicakram
7 - Meteor

My solution

vicakram
7 - Meteor
Spoiler

Weekly Challenge- 410.png
Bobbyt23
8 - Asteroid

Absolutely loads going on in this one, great challenge. Had to look at the solution for help to get started.

youchun
6 - Meteoroid

Interesting challenge!