|
USA-LA-HODGE Azienda Directories
|
Azienda News:
- KQL - make_set distinct | Microsoft Community Hub
I want to summarize an event and use make_set to minimize the results I want something like make_set() but only distinct values What I have in mind is distinct_make_set(LoginInfo) and distinct_make_set(IPVTimeGenerated) Desired summarize: | summarize LastestSignIn = arg_max(TimeGenerated,UserName), EarliestSignIn = arg_min(TimeGenerated
- KQL make_set or make_list on rows into columns [closed]
datatable(ID:int, DEPT:string, ADDRESS:dynamic) [ 8, "CSE", dynamic([1 2, "Rithwik"]), 8, "CSE", dynamic([1 3, "hello"]), 8, "ECE", dynamic([1 4, "Bojja"]) ] | summarize dep = make_set(DEPT), ipadress = make_list(ADDRESS) by ID Output: Fiddle For your query you can integrate from summarize statement
- Application Insights Kusto (KQL): How to sort items produced by make . . .
Wonder how to make items sorted in make_set You could use array_sort_asc() array_sort_desc(): For example: 'Car', '1 0 0', 'Train', '2 0 0', 'Train', '1 0 0', 'Car', '2 0 0' I'm trying to group different kinds by a version
- Kusto query ingestion (set, append, replace) - Kusto | Microsoft Learn
Learn how to use the set, append, set-or-append, and set-or-replace commands to ingest data from a query
|
|