Aggregate FunctionsStatistical

binary_all_and

Returns the bitwise AND of every non-null value in the group, or null for a group without one.

Syntax

binary_all_and(val)

Prop

Type

Returns: long

binary_all_and(val)

Prop

Type

Returns: int

datatable(num:long)[
  4294967295,
  4294963215,
  3489660925,
  4211015679
]
| summarize result = toupper(tohex(binary_all_and(num)))

result (string)
CAFEF00D

avgif

Calculates the average of values in the group for which the predicate evaluates to true.

binary_all_or

Returns the bitwise OR of every non-null value in the group, or null for a group without one.