Forum Discussion
How to pick up records by taking last record in each group
MsCdrView() | reduce by CallRetryId with threshold=0.9
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
1 Reply
- Yoni
Microsoft
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