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 #427: Bookstore Sales Analysis

DataNath
17 - Castor

My solution to #427:

 

Spoiler
347.png

Used my SQL Join macro to easily handle the range join and then the rest was straightforward.

Milanz
8 - Asteroid

my solution ;-)

 

Spoiler
ML427.jpg

logdog0411
9 - Comet
Spoiler
427 Bellamy.png

I am almost certain there's a far more elegant way to accomplish this. Can't wait to look at everyone else's answers!

 

🪖

ScottLewis
10 - Fireball

This one was a good one for solving and then trying to figure out a more efficient way to solve.

This is where I ended up. I want there to be a way to do it without sorting, but the only way I see requires a rejoin, which is worse.

 

Spoiler
427_Scott.PNG

fmilliren
8 - Asteroid
Spoiler
Challenge_427_solution_image.jpg
Qiu
21 - Polaris
21 - Polaris

Fun Challenge

Spoiler
Challenge_427.png
balajilolla2
9 - Comet
Spoiler
Solution Attached

Screenshot 2024-06-03 164911.jpg
Qiu
21 - Polaris
21 - Polaris

I also made attempt to use the Designer Cloud but strange thing is that the Join will not work for two Date Fields...

Spoiler
Challenge_427_Clound.png
jbarney
5 - Atom

Cool challenge!

Anujmalikk
5 - Atom

Solution:-