Aggregate FunctionsStatistical
dcount
Returns an estimate for the number of distinct values of the expression in the group.
Syntax
dcount(expr)Parameters
Prop
Type
Returns: long
Syntax
dcount(expr, accuracy)Parameters
Prop
Type
Returns: long
Syntax
dcount(expr, accuracy)Parameters
Prop
Type
Returns: long
Examples
Example 1 — Count distinct weapons
datatable(warrior:string, weapon:string)[
"Ragnar", "axe",
"Bjorn", "sword",
"Ivar", "axe",
"Floki", "axe",
"Harald", "spear"
]
| summarize dcount(weapon)| dcount_weapon (long) |
|---|
| 3 |
Example 2 — Distinct targets per region
datatable(target:string, region:string)[
"Lindisfarne", "England",
"York", "England",
"Paris", "Francia",
"Lindisfarne", "England"
]
| summarize dcount(target) by region| region (string) | dcount_target (long) |
|---|---|
| England | 2 |
| Francia | 1 |
Example 3 — With explicit accuracy parameter
datatable(warrior:string, weapon:string)[
"Ragnar", "axe",
"Bjorn", "sword",
"Ivar", "axe",
"Floki", "axe",
"Harald", "spear",
"Halfdan", "sword",
"Rollo", "axe"
]
| summarize dcount(weapon, 1)| dcount_weapon (long) |
|---|
| 3 |