Function Index

BinFixed

Computes the bin for a value among the specified number of identically sized bins within the given bounds.

Usage

BinFixed(<value>, <min>, <max>, <bins>)

value (required): The value for which the bin is computed.

min (required): The lower bound. If <value> is less than <min>, the bin will be 0.

max (required): If <value> is greater that max, the bin will be <bins> +1.

bins (required): The number of bins within the interval <min>, <max>.

Examples

BinFixed([Days Since Signup], 0, 100, 10)

  • Will assign the values in the column [Days Since Sign Up] one of 12 bins. All numbers less than 0 will be in bin 0. All numbers 100 or greater will be in bin 11. All numbers between 0 and 100 will be assigned one of 10 equally sized bins.

More About

Math Functions

These functions return well-known mathematical constants or implement common arithmetic functions.