Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Not one of my favourites either. The way the question was asked confused me, worked it out from the output itself.
Can anyone help me understand why I cannot use the Summarize tool to pull the State and Min Pumpkin Numbers for each year? I have been fumbling around with this for quite a while.
And why is there no way to include the State column information without it sorting by state? Why so complicated? I just want the min value per year without dropping the relevant state information. Halp! Thank you!
I was able to match the solution up to the last 2 columns, then I'm stumped.
The 'Max Average State Production' number is the same for the entire column, but the 'Min Average State Production' doesn't work the same way. I still don't understand the definition of the 'Min Average State Production', even after looking at the solution!!!!
I have a completely different approach than the solution, which doesn't help in resolving the problem. Any kind souls who can explain what the 'Min Average State Production' is?