> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# BinFixed

> Use the Sigma BinFixed function to compute the bin for a value among the specified number of identically sized bins within the given bounds.

The **BinFixed** function computes the bin for a value among the specified number of identically sized bins within the given bounds.

This function isn't compatible with all data platform connections. To check if your connection supports it, see [Supported data platforms and feature compatibility](/docs/region-warehouse-and-feature-support#supported-data-platforms-and-feature-compatibility).

## Syntax

```
BinFixed(value, min, max, bins)
```

Function arguments:

* **value** (required): The value for which the bin is computed.
* **min** (required): The lower bound. If the value is less than min, the bin will be 0.
* **max** (required): If the value is greater than or equal to max, the bin will be bins + 1.
* **bins** (required): The number of bins within the interval. Bins are numbered 1 through bins. If bins is less than 1, all values will treated as belonging to bin 1.

## Example

The values in the *Days Since Signup* column are assigned to one of 5 bins:

```
BinFixed([Days Since Signup], 0, 90, 3)
```

This function places all numbers less than 0 in bin 0, all numbers 90 or greater in bin 4, and all numbers between 0 and 90 are assigned one of 3 equally sized bins. 

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/8b4687e78f80af1bc78d58112875afd0cd78a82fb30c7f667f156489ff16cdc7/assets/docs-images/79ef98d-1.png)

Using bins helps simplify a column to show the duration since the last signup:\
![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/1f61bc22e494fd5e1c1c849552c80e9a60bf1dbd29b887bce59b33430b5b7394/assets/docs-images/5bbf0f3-2.png)

## Related resources

* [BinRange](/docs/binrange)