ntile

Description

Window function: returns the ntile group id (from 1 to 'n' inclusive) in an ordered window partition. For example, if 'n' is 4, the first quarter of the rows will get value 1, the second quarter will get 2, the third quarter will get 3, and the last quarter will get 4.

Usage

## S4 method for signature 'numeric'
ntile(x)

ntile(x)

Arguments

Details

This is equivalent to the NTILE function in SQL.

Note

ntile since 1.6.0

See Also

Other window_funcs: cume_dist, cume_dist, cume_dist,missing-method; dense_rank, dense_rank, dense_rank,missing-method; lag, lag, lag,characterOrColumn-method; lead, lead, lead,characterOrColumn,numeric-method; percent_rank, percent_rank, percent_rank,missing-method; rank, rank, rank, rank,ANY-method, rank,missing-method; row_number, row_number, row_number,missing-method

Examples

## Not run: ntile(1)