Scalar FunctionsOther Functions

row_number

Returns the current row number in the serialized row set.

Syntax

row_number()

Returns: long

datatable(weapon:string)[
  "axe",
  "sword",
  "axe",
  "spear",
  "sword",
  "axe"
]
| summarize count() by weapon
| extend r = row_number()

percentile_tdigest

Calculate the percentile from a t-digest representation.

Introduction to Tabular Operators

Tabular operator overview and categories