CODEWITHSUNDEEP
azure-data-explorerkqlkusto-explorer
Milo_Dev
Milo_Dev

Reputation: 415

Kusto query help for Time chart

I am writing a Kusto query to display ths status of build results in time chart. That is the first column will display the time in 5 mins difference and the remaining columns will have the count for the respective Build status like (sucess, failed, in progress)

Once I do all the filters, I am using the below query

´´´| summarize count= count() by Status ,bin(timestamp(), 1h) | render timechart´´´

It says unknown function and I am not sure how to display a time chart. So for each status how do I get the count for every 5 mins. Thanks for any inputs.

Refer picture for the sample chart

Upvotes: 0

Views: 3176

Answers (1)

Avnera
Avnera

Reputation: 7608

It seems that the issue is that you are using the function notation when you are telling the "bin" function which column to use, instead of simply provide the name of the column. In other words, remove the parenthesis after the column name timestamp as follows:

T
| summarize count= count() by Status ,bin(timestamp, 1h) | render timechart

Upvotes: 1

Related Questions