rand

The rand function returns a random double value between 0 (inclusive) and 1 (exclusive).

Spec

rand()

Parameters

None.

Return Value

A random double value in the range [0, 1).

Example

Generate random values for each row:

range x from 1 to 5 step 1
| extend r = rand()

x	r
1	0.123456
2	0.987654
3	0.543210
4	0.678901
5	0.234567

(Actual values will vary each run.)

rand

Returns a random number in the range [0.0, 1.0).

Syntax

rand()

Examples

Sample 10% of events:

events
| where rand() < 0.1

Assign random buckets:

datatable(x:int)[1,2,3,4,5]
| extend bucket = floor(rand() * 3)