I think that the fundamental problem here is that your “Codes” are getting recognized as numbers, not strings. When I changed that field’s values to more explicit strings like “Code 1100”, I got closer. I believe that the pie chart, much like the new Bar Chart, requires strings.
But In either case, I mocked up your data and played with this, but couldn’t get the pie chart quite right.
I think the Bar Chart might be a better fit:
