I added a bit of reporting to my solution. I wanted to see the names over time, how popular they were, and for how long they kept that #1 spot. I'm still learning how to use the Charting tool, so not the world's best chart.
I don't want to spoil the party. Far be it from me to be a baby about it. But I'd like to point out that @patrick_digan & @NicoleJohnson (both ACEs and the latter the 2018 Grand Prix winner) have turned in UNEQUAL results. Their answers do NOT match the expected output.
My dear friend and colleague, @JoeM and I instructed a training class at #alteryx18 on CReW macros. If either of the aforementioned Alteryx Experts had taken the training, they would have employed a CReW test macro, Expect Equal (BETA) and found that their results were both sub par.
They should give you extra credit for that reply. I just got off of the phone with @patrick_digan and he has found the error(s) in his ways.
Long live CReW!
At least I'm in good company with @NicoleJohnson. To clear my good name, I've detailed my missteps...
...and corrected them