Aggregate FunctionsMake / Collect
make_set_if
Returns a dynamic (JSON) array of distinct values of `expr` for the rows in the
Syntax
make_set_if(expr, predicate)Parameters
Prop
Type
Returns: dynamic
Syntax
make_set_if(expr, predicate, max_size)Parameters
Prop
Type
Returns: dynamic
Syntax
make_set_if(expr, predicate, max_size)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1
datatable(warrior:string, clan:string, elite:bool)[
"Ragnar", "Lothbrok", true,
"Bjorn", "Lothbrok", true,
"Floki", "Lothbrok", false,
"Ragnar", "Lothbrok", true,
"Harald", "Fairhair", true,
"Halfdan", "Fairhair", false
]
| summarize elite_warriors = make_set_if(warrior, elite) by clan| clan (string) | elite_warriors (dynamic) |
|---|---|
| Fairhair | ["Harald"] |
| Lothbrok | ["Ragnar","Bjorn"] |
Example 2
datatable(span_name:string, trace_id:string, is_orphan:bool)[
"checkout", "t1", false,
"charge_card", "t1", true,
"send_receipt", "t1", true,
"lookup_user", "t2", false,
"render_template", "t2", false
]
| summarize orphan_spans = make_set_if(span_name, is_orphan) by trace_id| trace_id (string) | orphan_spans (dynamic) |
|---|---|
| t1 | ["charge_card","send_receipt"] |
| t2 | [] |