Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Calculates the approximate rank of the value in a set, where rank is expressed as a percentage of the set's size. This function can be viewed as the inverse of the percentile.
Syntax
percentrank_tdigest(digest, value)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| digest | string |
✔️ | An expression that was generated by tdigest() or tdigest_merge(). |
| value | scalar | ✔️ | An expression representing a value to be used for percentage ranking calculation. |
Note
The type of value and the type of the elements in digest should be the same.
Returns
The percentage rank of value in a dataset.
Examples
Getting the percentrank_tdigest() of the damage property that valued 4490$ is ~85%:
StormEvents
| summarize tdigestRes = tdigest(DamageProperty)
| project percentrank_tdigest(tdigestRes, 4490)
Output
| Column1 |
|---|
| 85.0015237192293 |
Using percentile 85 over the damage property should give 4490$:
StormEvents
| summarize tdigestRes = tdigest(DamageProperty)
| project percentile_tdigest(tdigestRes, 85, typeof(long))
Output
| percentile_tdigest_tdigestRes |
|---|
| 4490 |