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 #93: Pumpkin Production

tkisch
8 - Asteroid
Spoiler
Spoiler
tkisch_0-1674680912818.png

Spoiler

MajorData
Alteryx
Alteryx
Spoiler
MajorData_0-1674766750348.png

 

I spent some time trying to get a solution to work using Summarize max/min function but you can't group by the year and keep the state associated with the max or min values. 

logdog0411
8 - Asteroid
Spoiler
logdog0411_0-1674766936655.png

 

olga_strubbe
11 - Bolide
Spoiler
olga_strubbe_0-1675176747762.png

 

kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_93_KU.png
ShankerV
17 - Castor

Had the thrill of solving!!!!

 

Spoiler
ShankerV_0-1676809338608.png

 

Adrien_Sourdille
8 - Asteroid

 

Spoiler
Alt 93.png

 

 

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1677577692495.png

 

alacoume
8 - Asteroid

My solution:

Flo_P
9 - Comet
Spoiler
Lots of pumpkins
Flo_P_0-1678284762407.png