Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account 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 #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