https://community.splunk.com/t5/Splunk-Search/PIE-CHART-mouseover-is-displaying-100-value-from-nowhere/m-p/129716#M35295 <P>My search:</P> <UL> <LI>| chart max(REPORTING) as REPORTING max(MISSING) as MISSING</LI> </UL> <P>The table looks fine, 2 columns, REPORTING and MISSING, with value of 102 REPORTING and 4 MISSING.</P> <P>The pie chart looks like this:</P> <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/215iFAE17157D6D05E8A/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>Where is 100% coming from? How do I remove it?</P> <P>And if I add "| transpose" I get this chart with unwanted row/column text:</P> <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/216iF672DCA016742A64/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> Fri, 06 Feb 2015 23:33:24 GMT the_wolverine 2015-02-06T23:33:24Z https://community.splunk.com/t5/Splunk-Search/PIE-CHART-mouseover-is-displaying-100-value-from-nowhere/m-p/129716#M35295 <P>My search:</P> <UL> <LI>| chart max(REPORTING) as REPORTING max(MISSING) as MISSING</LI> </UL> <P>The table looks fine, 2 columns, REPORTING and MISSING, with value of 102 REPORTING and 4 MISSING.</P> <P>The pie chart looks like this:</P> <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/215iFAE17157D6D05E8A/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>Where is 100% coming from? How do I remove it?</P> <P>And if I add "| transpose" I get this chart with unwanted row/column text:</P> <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/216iF672DCA016742A64/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> Fri, 06 Feb 2015 23:33:24 GMT https://community.splunk.com/t5/Splunk-Search/PIE-CHART-mouseover-is-displaying-100-value-from-nowhere/m-p/129716#M35295 the_wolverine 2015-02-06T23:33:24Z https://community.splunk.com/t5/Splunk-Search/PIE-CHART-mouseover-is-displaying-100-value-from-nowhere/m-p/129717#M35296 <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/214i7C9FA416923F4C49/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>Workaround this by using transpose and rename the column and "row 1":</P> <P>| chart max(REPORTING) as<BR /> "REPORTING" max(MISSING) as "MISSING" | transpose | rename "row 1" as count "column" as STATE</P> Fri, 06 Feb 2015 23:58:21 GMT https://community.splunk.com/t5/Splunk-Search/PIE-CHART-mouseover-is-displaying-100-value-from-nowhere/m-p/129717#M35296 the_wolverine 2015-02-06T23:58:21Z