Pie Chart not displaying correct values (Kusto)

%3CLINGO-SUB%20id%3D%22lingo-sub-2981016%22%20slang%3D%22en-US%22%3EPie%20Chart%20not%20displaying%20correct%20values%20(Kusto)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981016%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20produce%20a%20pie%20chart%20from%20a%20simple%20hunting%20query.%26nbsp%3B%20The%20problem%20is%2C%20the%20pie%20chart%20does%20not%20match%20the%20data%20in%20the%20table-%20it%20seems%20to%20be%20cumulative.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20table%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markdown%22%3E%3CCODE%3EGB%2037%0AUS%2030%0ADE%208%0ASG%207%0AIN%206%0ABR%206%0APL%204%0ATR%203%0ABE%203%0ATH%203%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20if%26nbsp%3B%20I%20produce%20a%20chart%20(using%20the%20drop%20down%20or%20the%20render%20command)%2C%20this%20is%20what%20I%20see.%20GB%20has%20a%20value%20of%2037%2C%20US%2067%20(ie%20GB%2BUS)%2C%20and%20DE%2075%20(ie%20GB%2BUS%2BDE).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LloydAdams_0-1637250978450.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F328018i22A58793C57BEAA3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22LloydAdams_0-1637250978450.png%22%20alt%3D%22LloydAdams_0-1637250978450.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20have%20I%20missed%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3001229%22%20slang%3D%22en-US%22%3ERe%3A%20Pie%20Chart%20not%20displaying%20correct%20values%20(Kusto)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3001229%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20for%20you%20to%20share%20the%20query%3F%3C%2FLINGO-BODY%3E
Regular Contributor

I'm trying to produce a pie chart from a simple hunting query.  The problem is, the pie chart does not match the data in the table- it seems to be cumulative.

 

This is the table:

GB	37
US	30
DE	8
SG	7
IN	6
BR	6
PL	4
TR	3
BE	3
TH	3

 

And if  I produce a chart (using the drop down or the render command), this is what I see. GB has a value of 37, US 67 (ie GB+US), and DE 75 (ie GB+US+DE).

 

LloydAdams_0-1637250978450.png

 

What have I missed?

 

 

3 Replies
Is it possible for you to share the query?
Well I went to grab the saved query, and the chart now displays correctly, with no changes. The wonders of SaaS.