What's new in Sigma

API

New options for the Create a member endpoint

The Create a 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 function. You can also return the day of the year as a number using day_of_year in the precision argument of the 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.

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.

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.

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.

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.

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 function with a sorted table.

For more details, see 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.

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.

API