Is there a possibility to create a Histogram using Kusto Query Language?

Viewed 678

I was checking the kusto documentation to check if I can create a histogram but I didn't seem to find anything related to histograms. Only barcharts and columncharts.

Is there a way to create a histogram in KQL or that is not possible ?

1 Answers

Can be done using bin()

// Generation of a data sample. Not part of the solution.
range i from 0 to 100 step 1 | project i, r = sqrt(-2*log(rand()))*sin(2*pi()*rand()) 
// Solution starts here.
| summarize count() by bin(r, 0.5)
| render columnchart 

enter image description here

Fiddle

Related