Search code examples
azure-application-insightskql

How to exclude weekends in Kusto query?


Is there a way to exclude weekends between two dates using existing Kusto commands? I cannot find the right function in here https://kusto.azurewebsites.net/docs/queryLanguage/query-essentials/readme.html


Solution

  • You can use | where dayofweek(timestamp) < 6 to exclude Saturday and Sunday from your query. Please refer to dayofweek() doc.