PIE CHART mouseover is displaying 100% value from nowhere?

[the_wolverine]

My search:

• | chart max(REPORTING) as REPORTING max(MISSING) as MISSING

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:

[the_wolverine · Accepted solution]

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