Challenge #459: Fun Facts About LEGO® Sets! Part 1

[Bobbyt23]

Challenge complete.

Spoiler

[olga_strubbe]

Thank you, @Qiu!  This was a nice warm up challenge on a Monday.  Looking forward to a part II. 

Spoiler

[RolandSchubert]

Spoiler

[olga_strubbe]

I found a shortcut - there is actually no need to use a Summarize tool in the first task, you can use sort right away as the data is already laid out by unique set ID.  Thank you, @Bobbyt23 for the tip on this!

Here is my updated workflow:

Spoiler

[PhilipMannering]

Solution attached...

[balajilolla2]

Spoiler

Solution Attached

[Katerbugs]

So much fun! Huge LEGO fan, and I cannot wait for pt 2!

[mjacob530]

Completed!

Spoiler

[KLTerrell]

Fun!

Spoiler

 Hmmmmm..... looking at other solutions after I posted mine has me wondering why I built an Average formula instead of adding that field to the Summarize tool. Oh well! Could be shorter by one tool. 🙃

[jfissel]

Spoiler