Data modeling

Data models (Beta)

Build data models to create collections of table and input table elements that can be reused as data sources in other Sigma documents. Use the familiar workbook-style format to easily transform and analyze reusable elements, and view key insights into data model usage across your organization.

For more information, see Intro to data models and Create and manage data models.

Functions and calculations

Advanced calculation options for metrics

Quickly convert metrics to cumulative aggregates (grand total) or relative aggregates (percent of total) in tables, pivot tables, and visualizations.

Open the relevant column menu, then hover over Advanced calculations and select an option to show the grand total or percent of total. Available percentage breakdowns (by grand total, x-axis, row, column, etc.) depend on the element type.

Workbook elements

Interactive chart legends

Interact with chart legend entries to quickly focus on specific data subsets.

Charts containing legends that represent qualitative segments (like categories or series) support the following interactive filtering capabilities:

• Hover over a legend entry to highlight corresponding data points.
• Click a legend entry label to isolate corresponding data points.
• Select or clear the checkbox of one or more legend entries to show or hide corresponding data points.
• Click anywhere (within the element) outside of the plot area or legend to reset the chart display.

📘

Changes resulting from chart legend interactions persist when you switch between workbook modes; however, they don’t persist across user sessions and aren’t saved when the workbook is published.

Bug fix

• To preserve data integrity, Sigma no longer converts Yes/No and 0/1 values to True/False boolean values in CSV uploads.

Workbook features

Customizable page tab color

Customize the color of individual page tabs for added clarity and organization in workbooks.

In the page menu, click Change color and select an option from the color palette.

Embeds

JavaScript event for saved bookmark

Sigma now listens for the following JavaScript event sent by a user to save a bookmark on an embedded workbook:

{
      type: 'workbook-bookmark-current';
      bookmarkName: string;
      isDefault: boolean;
      isShared: boolean;
}

Workbook elements

Map region improvements

Sigma now uses Mapbox to render regions in map elements. This update contributes overall performance improvements, including more precise boundaries for mapped regions.

📘

Due to updated place name specifications, Mapbox may not render some regions in existing maps. Update place names in map element data sources if needed.

Conditional formatting using hidden controls

Conditional formatting rules referencing hidden controls are now applied reliably to visible data elements in embeds and published workbook versions (View and Explore mode).

For more information about hidden controls and filter accessibility, see Create a hidden control.

Bug fixes

• Selecting the Impersonate user function for a user assigned the Embed member type no longer redirects admins to the Home page.
• Admins can now successfully update a user’s member type from Internal to Guest.
• Sigma now emits the workbook:error JavaScript event when an embed user is logged out due to a session timeout.

Admin

Account type permissions for export destinations

Account types feature separate permissions for individual export destinations, enabling granular control over members’ ability to export workbook content to Google Sheets, Google Drive, Slack, cloud storage, and webhooks.

For more information, see the account type permission availability matrix (Sharing and exports section) in License and account type overview.

Separate export warehouse

If your Sigma organization is connected to Snowflake, you can run all scheduled, direct, and on-demand exports through a separate warehouse. This practice isolates export operations to optimize performance and reduce computing costs.

For more information, see Configure an export warehouse.

Performance

SUPER data type support

Sigma natively supports the SUPER data type to seamlessly handle semistructured data from Redshift connections.

Workbook elements

Default value for empty pivot table cells

When there’s no corresponding source data for a pivot table value cell to reference (no record exists for the particular combination of dimensions), the cell is empty by default. To customize the value for all empty cells, go to Element format > Format and enter the preferred value in the Empty cell display value field.

Workbook features

Table styling in workbook settings and organization themes

Configure a default table style for an entire workbook (in the Workbook settings panel) or an organization theme (in the Administration portal).

For more information, see Customize table styles and Create and manage workbook themes.

Functions

Array function

The Array function returns an array containing specified values.

For more information, see Array.

Workbook elements

Repeat pivot values in exports

When sending or scheduling an export, you now have the option to repeat pivot values in Excel or CSV output.

In the Send Now or Schedule Exports modal, go to More options and select the Repeat pivot values checkbox. This ensures the pivot header values are populated in every applicable row or column.

Bulk column drag-and-drop

When interacting with a visualization, table, pivot table, or input table elements, you can now bulk drag-and-drop columns in the Element properties > Columns tab to reorder multiple columns or add them to groupings, calculations, and other properties.

Workbook features

Button element formatting

Button elements now feature new Style, Shape, and Size formatting options in the Element properties panel.

Admin

Updated licensing model

Sigma’s license tiers are now labeled Lite, Essential, and Pro to bring clarity and simplicity to the licensing model.

If your organization was previously subscribed to the two-license model, it will continue using two license tiers: Lite (formerly Viewer) and Pro (formerly Creator). No action is required to accommodate the update, as all user functionality and experiences will continue seamlessly.

For more information, see the Sigma Community post.

Functions

DateFormat function enhancement

The DateFormat function now supports the %q specifier that allows you to extract the quarter component from a datetime value.

For more information about the function and supported format specifiers, see DateFormat.