My search:
The table looks fine, 2 columns, REPORTING and MISSING, with value of 102 REPORTING and 4 MISSING.
The pie chart looks like this:
Where is 100% coming from? How do I remove it?
And if I add "| transpose" I get this chart with unwanted row/column text:
Workaround this by using transpose and rename the column and "row 1":
| chart max(REPORTING) as
"REPORTING" max(MISSING) as "MISSING" | transpose | rename "row 1" as count "column" as STATE