SOLVED

Why won't the chart show any values even with data?

%3CLINGO-SUB%20id%3D%22lingo-sub-1569149%22%20slang%3D%22en-US%22%3EWhy%20won't%20the%20chart%20show%20any%20values%20even%20with%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569149%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20trying%20to%20grab%20network%20data%20with%20this%20query%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EPerf%0A%7C%20where%20TimeGenerated%20%26gt%3B%3D%20ago(5m)%20and%20CounterName%20%3D%3D%20%22Bytes%20Received%2Fsec%22%20%7C%20take%20100%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EIt%20returns%20100%20logs%20of%20data%2C%20several%20counter%20values.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20on%20the%20chart%20there%20appears%20to%20be%20no%20graph%20shown.%20Only%20the%20counter%20values%20at%20the%20bottom%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22nochart.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210494i2CC269122208A4A2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22nochart.PNG%22%20alt%3D%22nochart.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1569149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edashboards%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELog%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1569561%22%20slang%3D%22ja-JP%22%3ERe%3A%20Why%20won't%20the%20chart%20show%20any%20values%20even%20with%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569561%22%20slang%3D%22ja-JP%22%3E%3CP%3EIs%20this%20no%20good%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerf%3C%2FP%3E%3CP%3E%7C%20where%20TimeGenerated%20%26gt%3B%3D%20ago(5m)%20and%20CounterName%20%3D%3D%20%22Bytes%20Received%2Fsec%22%3C%2FP%3E%3CP%3E%7C%20summalize%20avg%20by%20bin%20(TimeGenerated%2C%201m)%2C%20_ResourceId%3C%2FP%3E%3CP%3E%7C%20render%20timechart%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570440%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20won't%20the%20chart%20show%20any%20values%20even%20with%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570440%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741656%22%20target%3D%22_blank%22%3E%40Jhilene%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOther%20than%20explicitly%20using%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-explorer%2Fkusto%2Fquery%2Frenderoperator%3Fpivots%3Dazuremonitor%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ethe%20render%20operator%3C%2FA%3E%2C%20you%20can%20simply%20select%20the%20right%20chart%20type%20and%20the%20column%20that%20is%20used%20for%20charting%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Annotation%202020-08-06%20144622.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210615iB7B4965CF470F71D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202020-08-06%20144622.jpg%22%20alt%3D%22Annotation%202020-08-06%20144622.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3EMeir%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Hello, I am trying to grab network data with this query:

 

Perf
| where TimeGenerated >= ago(5m) and CounterName == "Bytes Received/sec" | take 100

It returns 100 logs of data, several counter values.

 

However, on the chart there appears to be no graph shown. Only the counter values at the bottom:

nochart.PNG

 

2 Replies

Is this no good?

 

Perf

| where TimeGenerated >= ago(5m) and CounterName == "Bytes Received/sec"

| summarize avg(CounterValue) by bin(TimeGenerated, 1m), _ResourceId

| render timechart

Best Response confirmed by Jhilene (Microsoft)
Solution

@Jhilene,

 

Other than explicitly using the render operator, you can simply select the right chart type and the column that is used for charting:

Annotation 2020-08-06 144622.jpg

 

Thanks,

Meir