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

# What's new in Sigma

> Sigma release notes for Jun 20, 2025: New options for the Create a member endpoint, new DayOfYear function and day of year DatePart argument.

## API

### New options for the Create a member endpoint

The [Create a member](/reference/create-member) (`POST /v2/members`) endpoint includes a new option to add users to teams when adding them to Sigma. Specify the `teamId` in the `addToTeams` option to add a user to one or more teams when you create them in Sigma, and optionally use the `isTeamAdmin` option to make the user an admin of the team.

## Functions and calculations

### New **DayOfYear** function and `day_of_year` **DatePart** argument

Return the day of the year as a number (1-365, or 1-366 in leap years) from a date using the [DayOfYear](https://help.sigmacomputing.com/docs/dayofyear) function. You can also return the day of the year as a number using `day_of_year` in the precision argument of the [DatePart](https://help.sigmacomputing.com/docs/datepart) function.

### RegressionSlope function

The **RegressionSlope** function calculates the slope of the linear regression line. The function is now supported for Databricks, Snowflake, and PostgreSQL.

See [RegressionSlope](https://help.sigmacomputing.com/docs/regressionslope).

### RegressionIntercept function

The **RegressionIntercept** function calculates the y-intercept of the linear regression line. The function is now supported for Databricks, Snowflake, and PostgreSQL.

See [RegressionIntercept](https://help.sigmacomputing.com/docs/regressionintercept).

### RegressionR2 function

The **RegressionR2** function calculates the R2 value, or coefficient of determination, of the linear regression line. The function is now supported for Databricks, Snowflake, and PostgreSQL.

See [RegressionR2](https://help.sigmacomputing.com/docs/regressionr2).

## Infrastructure

### Azure Canada region

Sigma is now deployed in Azure Canada. Located in Toronto, this deployment gives customers in Canada more control over data storage while enabling compliance with internal policies and external data residency requirements.

See [Supported regions, data platforms and features](https://help.sigmacomputing.com/docs/region-warehouse-and-feature-support).

## Workbook elements

### Configure data labels per series on Cartesian charts (GA)

If your Cartesian (bar, line, area, or scatter) or combo chart visualizes multiple series of data, you can configure different data label settings for each series. See "Format and show data labels" in  [Display chart data labels](https://help.sigmacomputing.com/docs/display-chart-data-labels#format-and-show-data-labels).

## Workbook features

### Limit display values in a data element (GA)

Limit the number of values displayed in a grouped table, pivot table, or chart, and group the remaining values in an "Others" category. You can transform an existing column or use the [VisibilityLimit](https://help.sigmacomputing.com/docs/visibilitylimit) function with a sorted table.

For more details, see [Limit displayed values in a data element](https://help.sigmacomputing.com/docs/limit-displayed-values-in-a-data-element).

### New supported workbook locales

English (Canada), English (Ireland), Spanish (Mexico) and Chinese (Traditional) are now supported workbook locales. This includes language, date format, number format, and currency. You can preview a workbook in\
en-ca, en-ie, es-mx, or zh-tw.

See [Manage workbook localization](https://help.sigmacomputing.com/docs/manage-workbook-localization).

## Bug fixes

* After copying and pasting a workbook or data model element with one or more columns that use metrics, those columns display correctly.
* You can now successfully tag and swap the sources of a workbook version that uses a data model with data from multiple connections.
* When the signature of a stored procedure used in a stored procedure action is changed, the action now validates that the signature is the same and uses the new signature if possible.
* When viewing a workbook lineage in an embed, the **Shared with me** link now launches the embed modal instead of the native Sigma modal.
* When you disable automatic user creation for embeds, you can now manage embed users in the Administration portal.
* When Sigma encounters errors during a data source swap involving custom SQL and input tables, Sigma now show the error messages at the bottom of the page.