How to Use Count Operator in Kusto Query | Kusto Query Language Tutorial (KQL)

 Topic: How to Use Count Operator in Kusto Query

How to use count operator in Kusto Query Language | Kusto Query Language Tutorial (KQL) Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. The query uses schema entities that are organized in a hierarchy similar to SQL's: databases, tables, and columns. A Kusto query is a read-only request to process data and return results. The request is stated in plain text, using a data-flow model that is easy to read, author, and automate. Kusto queries are made of one or more query statements.

 //Returns the number of records in the input record set.  
   
 //Get the Row Count of Table  
   
 TotalSale  
 | count   
   
   
 //Get the Record Count for Filtered Expressions  
 TotalSale  
 | where SalePersonFName =="aamir" | count  
   
 // using Distinct with Count - Single column or Multiple columns  
 TotalSale  
 | distinct City | count  

Video Demo: How to Use Count Operator in Kusto Query