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


BinFixed(value, min, max, bins)

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

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

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

bins (required): The number of bins within the interval , .


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.

See Also