Apr 25 2019 06:22 PM
MsCdrView() | reduce by CallRetryId with threshold=0.9
Apr 26 2019 12:54 PM
generally speaking, getting the "last" record in each group can be achieved using "summarize arg_max(..)" or "summarize arg_min(..)".
If you'd interested in providing a sample data set (e.g. using the "datatable" operator), this forum could assist with authoring the query.
relevant links for operators/functions mentioned above:
- https://docs.microsoft.com/en-us/azure/kusto/query/arg-max-aggfunction
- https://docs.microsoft.com/en-us/azure/kusto/query/arg-min-aggfunction
- https://docs.microsoft.com/en-us/azure/kusto/query/datatableoperator