What's new in Sigma

Admin

Passing multiple SAML userRole values is now supported

When configuring SAML, it is now possible to pass in multiple userRole values. The first valid account type in the list of userRole values will be assigned. See Configure your IdP in Set up single sign-on with SAML.

Workbook features

Transpose a table (Beta)

Transposing a table is now supported from rows to columns or columns to rows. This feature allows you to pivot or unpivot data according to your use case.

For more details, see Transpose a table.

Limit display values in a data element (Beta)

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.

Pivot table showing Store region and store name columns with total quantity sold values. The Store name column is limited to the top 3 stores by total quantity sold, with the remainder showing as Others. Totals are hidden for the table.

For more details, see Limit displayed values in a data element (Beta).

Custom totals and subtotals for pivot tables and grouped tables (GA)

In a pivot table or grouped table, you can change the way that totals and subtotals are calculated by choosing to change the aggregate used for a subtotal, or modifying the formula for a grand total or subtotal directly.

With this update, the default names of subtotals and totals update to Column Name total for subtotals or Grand total for totals. You can change the label of any subtotal or grand total.

For more details, see Customize totals and subtotals.

Bug fixes

After deactivating a SCIM user, the folder created to contain the deactivated user's documents no longer includes a UUID and matches the behavior described in Deactivated user documents.
When revoking access to a connection, database or catalog, schema, table, or stored procedure in Sigma, you can now only revoke access from the level to which the access was granted.
When a user has inherited access to a document from a version-tagged folder, the version tag is now shown in the Share Workbook or Share Data Model modal.
When sharing a workbook, version tags now appear for all access levels as expected.
When a user has access to specific version tagged documents in a folder, you can now grant access to all versions of documents in the Share Folder modal.