around()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Creates a bool value indicating if the first argument is within a range around the center value.

Syntax

around(value,center,delta)

Name	Type	Required	Description
value	int, long, real, datetime, or timespan	✔️	The value to compare to the center.
center	int, long, real, datetime, or timespan	✔️	The center of the range defined as [(`center`-`delta`) .. (`center` + `delta`)].
delta	int, long, real, datetime, or timespan	✔️	The delta value of the range defined as [(`center`-`delta`) .. (`center` + `delta`)].

Returns true if the value is within the range, false if the value is outside the range. Returns null if any of the arguments is null.

The following example filters rows around specific timestamp.

range dt 
    from datetime(2021-01-01 01:00) 
    to datetime(2021-01-01 02:00) 
    step 1min
| where around(dt, datetime(2021-01-01 01:30), 1min)

Output