Home > Enterprise >  Azure kusto unable to create chart
Azure kusto unable to create chart

Time:04-22

The error I got is "The Line can't be created as you are missing a column of one of the following types: int, long, decimal, or real"

enter image description here this is my query" I am looking the chart will display "number of unique resource IDs over time, with an aggregation timespan of 5m"

syslog_CL
 | where data_s contains "Reject" 
 | where hostname_s contains "Network1"
 | where TimeGenerated > ago(1hr)

is there any suggestion I can add to the query to get the time chart?

CodePudding user response:

you could try something like this:

syslog_CL
| where data_s contains "Reject" 
| where hostname_s contains "Network1"
| where TimeGenerated > ago(1hr)
| summarize dcount(_ResourceId) by bin(TimeGenerated, 5m)
| render timechart
  • Related