Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAthis one was a little harder then the usual ones categorized as 'Beginner'. But it was also fun - I learned a lot!
Admin/Moderator, requires your attention here please..!!
Solution uploaded as per desired result set.
However, IMO, "Min Average State Production" should be computed as the average of the 'minimum' production per state like its computed for "Max Average State Production".
However in the former, its computed as the overall average of the production per state. So the column value doesn't matches with the column header title in actual sense...!! (marked in the image)
Anyways solution provided to get the desired results.
Challenging but fun. Feels like I'm getting more comfortable in using the Dynamic Rename, but a challenge that even with this answer made me wonder about having fewer Joins and/or fewer tools. I do find the solution posted at the top intriguing as well as others here. Good stuff!
My solution
I enjoin you to see my solution!