Creating a time series with KQL
KQL makes it remarkably simple to perform time series analysis and does not require you to have a background in time series analysis, although it does help. Before we dive into creating a time series, I would like to discuss some new KQL operators and functions that we will be using as helper functions.
Introducing the helper operators and functions
The first KQL feature is variables. We briefly mentioned variables in the previous chapter, Chapter 5, Introducing the Kusto Query Language, but it is worth spending some time learning about variables. As you will see, variables can help with the readability of your queries, which is important once you progress from the simple examples we used in the previous chapter. A few decades ago, when I first started to learn about programming, one of the first things I learned was maintainability and readability and why magic numbers are bad practice. As you will see, as we write more complex queries, values...