Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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:-