Select Page

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 <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>.


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


More About Math Functions

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

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.