Admin

New version tag metadata in audit log (Beta)

The AUDIT_LOG > SIGMA_SHARED > DOCUMENTS dimension table now contains the following columns:

Column nameMetadata description
DOCUMENT_HAS_VERSION_TAGTrue or False
DOCUMENT_VERSION_TAGVersion tag name
VERSION_TAG_SOURCE_DOCUMENT_UUIDSource workbook ID

This metadata enables you to obtain information related to both the source workbook and the tagged version when referencing audit log entries for events like exports and downloads.

Functions and calculations

Sequence function

The Sequence function returns an arithmetic sequence as an array of integers based on a specified range and increment.

For more information, see Sequence.

Workbook features

Support for emailing exports to organization users and teams

When configuring an email export, the Recipients field now features an autocomplete dropdown that helps you search for and select an organization team or user. You can also continue to input specific email addresses for non-organization members with authorized domains.

For more information about emailing workbook content , see Export to email.

Bug fix

  • The Administration > Account Types > New Account Type page now correctly shows the Create, edit, and publish workbooks permission as auto-enabled (checkbox selected) when the Apply tags permission is enabled.

Admin

OAuth write access

OAuth with write access is now generally available (GA). No changes were made since the Beta release in May.

Configure an OAuth connection with write access to leverage the benefits of OAuth permission management with Sigma’s write-access features, including input tables, warehouse views, workbook materializations, and CSV uploads.

For more information, see Configure OAuth with write access.

API

Connection sync endpoint

Sync the connection to a specific database, schema, or table to update the data in Sigma.

For more information, see POST /v2/connections/{connectionId}/sync.

Embeds

Additional language support for workbook localization

You can now localize workbook text into Simplified Chinese, Korean, and Swedish.

For more information, see Manage workbook localization.

Workbook elements

Waterfall chart (Beta)

Build a waterfall chart to show changes in data over a period of time. Waterfall charts are perfect for financial analytics use cases where you track revenue and spend for a project, department, or an entire organization, and other use cases. You can format the shape, start, and end values of a waterfall chart as well.

Example waterfall chart

For more information, see Build a waterfall chart.

Repeat row labels in pivot tables

In pivot tables with multiple pivot rows, you can format your table to repeat row labels.

Pivot table demonstrating the use of repeat row labels

For more information, see Working with pivot tables.

Text area control element

Use the Text area control element to enable multi-line text input.

With customizable input field height and vertical scrolling to view text overflow, the Text area control element is ideal for forms and more effectively supports larger amounts of text than the Text input control element.

Example use of text area control element

Checkbox control element

Use the Checkbox control element to allow users to select or deselect a single option.

Like the Switch control element, the Checkbox control represents a binary state (true/false, on/off, etc.), but it offers a more suitable UI for presenting a list of multiple form options that users can select or deselect.

Example use of ceckbox control element

The screenshot demonstrates the use of multiple elements to create a multi-checkbox selection form. Each element supports a single checkbox field that can be selected independently of the others.

Functions and calculations

ArrayJoin function

The ArrayJoin function joins elements of an array into a single text string.

For more information, see ArrayJoin.

Workbook elements

Placeholder text in control elements

Customize placeholder text for any input-based control element (List values, Text input, Number input, Date, and Date range) to provide context about the expected input.

Go to Element format > General and update the Placeholder field. Placeholder text displays directly in the control’s input field and clears when the field contains user input.

API

Folder and document favoriting endpoints

Manage favorite documents and folders for a user:

  • GET /v2/favorites/member/{memberId} lists documents and folders favorited by a user.
  • POST /v2/favorites favorites a document or folder for a user.
  • DELETE /v2/favorites/member/{memberId}/file/{inodeId} unfavorites a document or folder for a user.

Workbook template endpoints

Manage workbook templates:

  • POST /v2/templates/{templateId}/swapSources swaps the data sources of a template.
  • POST /v2/workbooks/{workbookId}/saveTemplate saves an existing workbook as a template.

Embeds

Self-service embed usage analytics

Use a third-party tool (like Pendo) to track inbound and outbound events implemented in your embedded analytics.

By tracking iframe events, you can gain a better understanding of how customers are using your embedded data. For more information, see Implement inbound and outbound events in embeds.

Workbook elements

Control element naming updates

For consistency and clarity, the control elements formerly labeled Text control and Number are now labeled Text input and Number input.

Workbook features

Zip file option for attachments in exports

Compress export attachments into a single zip file.

If you export files that are too large to send by email, choose Send as zip file to compress the attachments and ensure your reports are delivered as expected. For more information, see Compress attachments to a zip file.

Combined file option for PDF attachments in exports

Combine multiple PDF attachments when configuring ad hoc and scheduled exports.

The Combine attachments option expands the previous ability to merge Excel attachments into one file. For more information, see Merge PDF or Excel files.

Enhanced color formatting for workbook themes

Edit your workbook color settings directly from the Color section of the Workbook settings panel. You can also see a real-time preview of your workbook colors that automatically updates as you adjust the settings.

The color picker also features a new eyedropper tool that allows you to pick a color from the same workbook or a different browser window.

For more information, see Workbook settings overview.

Workbook features

Explain visualizations with AI (Beta)

Instantly generate a description of any chart with the AI Explain visualization feature. Details can include key insights, observations, data distribution summaries, and other context that can enhance your understanding of the visualized data and help drive informed decisions.

For more information, see Explain a visualization with AI.

Admin

OAuth write access (Beta)

Configure an OAuth connection with write access to leverage the benefits of OAuth permission management with Sigma’s write-access features, including input tables, warehouse views, workbook materializations, and CSV uploads.

For more information, see Configure OAuth with write access.

Embeds

Inbound event for bookmark update in embeds

Use the workbook:bookmark:update inbound event to communicate and interact between embedded content and the host application.

For more information, see Implement inbound and outbound events in embeds.

Workbook features

Default version tags

Users with Can edit workbook permission can now designate a tag as the default tag for a workbook. As a result, any user who does not have access to the Published workbook will see the default tagged version. Applying default tags to workbooks with multiple tags results in a more consistent viewing experience.

For more information, see Set a default tag for a workbook.

Bug fixes

  • A user’s Sigma access token now expires when the OAuth access token expires, ensuring the user is logged out when the OAuth session has ended.

  • Updates to filters and sorting in tagged workbook versions are now reflected in exports and no longer trigger errors.

Admin

SUPPORT_CHATS audit log dimension table

Reference information about user interactions with Sigma's live chat support feature.

The SIGMA_SHARED schema in the Sigma Audit Logs connection now features a SUPPORT_CHATS dimension table containing information about individual live chat conversations, including timestamp, user name, user email, and the full chat transcript.

Embeds

nodeType property for workbook:selectednodeid:update

Determine whether a selected node is a page or an element by referencing the nodeType property in the workbook:selectednodeid:update inbound event.

For more information, see Available inbound events.

Workbook elements

Data labels in maps

Add one or more columns to generate data labels in point and region maps. This update makes it easier to quickly view at-a-glance details directly in the element.

For more information, see Display chart data labels.

Custom formula aggregations in chart reference marks

Specify a custom formula aggregation when configuring reference marks in charts.

For more information about reference marks, see Display chart reference marks.

Donut hole value in donut charts

Display an aggregate value within the hole of a donut chart to add more context to your visualization.

For details about adding a donut hole value, see Pie and donut charts.

Workbook features

Custom SQL editor (Beta)

Use the new SQL editor—featuring a more integrated and collaborative experience—to build workbooks, datasets, and elements (tables, pivot tables, and visualizations) with custom SQL.

The Beta release includes the following enhanced capabilities:

  • Toggle to an inline SQL editor view within any SQL-based workbook element, and expand the element to enter full screen mode.
  • Collaborate with other workbook developers in a live editing environment.
  • Use search and replace functionality within the custom SQL.
  • Apply autocomplete suggestions featuring improved performance.
  • View and access custom SQL from the workbook Lineage view.

For more information about using custom SQL directly in Sigma, see Write custom SQL.

Bug fixes

  • In the Administration > Embeds page, you can now successfully preview an embed in the Embed Sandbox when you click More and select Test embed.

  • When viewing an individual embed user's profile in the Administration > People page, the Edit member and account type modal now displays "Embed user" in the Account type field instead of “Invalid selection.”

Admin

Organization translation files

Serve Sigma users in your organization and consumers of embedded analytics with content in their preferred language.

Admins can create organization-wide translation files to translate custom strings that are common across workbooks in an organization, saving time and ensuring a consistent experience. Workbook owners inherit the organization-level translations and can override and supplement them with translations unique to an individual workbook. For more information, see:

API

API reference documentation and recipes

The API reference documentation has moved to https://help.sigmacomputing.com/reference. The new structure for the API reference offers better in-line documentation for endpoints and interactive code samples in a variety of languages.

The API reference docs are supported by new Recipes and QuickStarts that walk you through real-world code examples using the API.

GIF showing use of new interactive API reference documentation

Translations API endpoints

A new collection of endpoints allows admins to manage organization translation files to support localized content.

  • GET /v2/translations/organization lists all the translation files that have been defined at the organization level.
  • POST /v2/translations/organization creates a new organization translation file.
  • GET /v2/translations/organization/{lng} retrieves the translations for the specified locale without a custom variant.
  • PUT /v2/translations/organization/{lng} updates the translation file for a specified locale without a custom variant.
  • DELETE /v2/translations/organization/{lng} deletes the translation file for the specified locale without a custom variant.
  • GET v2/translations/organization/{lng}/{lng_variant} retrieves the translations for the specified custom translation for a locale.
  • PUT v2/translations/organization/{lng}/{lng_variant} updates the translations file for the specified custom translation for a locale.`
  • DELETE /v2/translations/organization/{lng}/{lng_variant} deletes the translation file for the specified custom translation for a locale.

Embedding

New outbound events in embeds

Use two new outbound events, workbook:exploreKey:onchange and workbook:bookmark:onchange, to communicate and interact between embedded content and the host application.

For more information, see Implement inbound and outbound events in embeds.

Workbook elements

Improved data source selection UI

Select data sources for workbook elements using a new popover UI. With the new experience, you can search for data sources, review a list of suggested sources, and preview data sources. Preview a data source to review the source data and choose specific columns to apply to the element.

For more information, see Create a data element.

CSV input tables (Beta)

Pre-populate a new input table with uploaded CSV data you can edit at the cell level.

Like empty input tables, CSV input tables support data entry independent of existing data, enabling you to add editable rows and columns to construct the table as you see fit.

For more information, see Intro to input tables and Create new input tables.

Dynamic button text

Add dynamic values to button elements. When configuring the button text, enter = to include a dynamic value defined by a formula expression.

For more information about buttons, see Create a button element.

Bug fix

  • Sigma no longer throws an error when multiple embeds attempt to add a new user at the same time.

Embeds

New inbound and outbound events in embeds

Use new inbound and outbound events to communicate and interact between embedded content and the host application.

Inbound events:

  • workbook:bookmark:create
  • workbook:fullscreen:update
  • workbook:selectednodeid:update
  • workbook:variables:list
  • workbook:variables:update

Outbound events:

  • url:onchange
  • workbook:bookmark:oncreate
  • workbook:chart:error
  • workbook:dataloaded
  • workbook:error
  • workbook:fullscreen:onchange
  • workbook:id:onchange
  • workbook:pageheight:onchange
  • workbook:pivottable:oncellselect
  • workbook:published

For more information, see Implement inbound and outbound events in embeds.

Workbook features

Sigma documentation in embed elements

Embed Sigma documentation pages in workbooks (using the embed UI element) or any other applications that support iframe content.

For more information, see Embed element.

Bug fix

  • Administrators can no longer circumvent UI restrictions to raise privileges of guest and embed users.

Formulas and operations

ArrayAggDistinct function

The ArrayAggDistinct function identifies distinct non-null row values of a column or group and aggregates them into a single array.

For more information see ArrayAggDistinct.

Record formula support

Use record formulas to generate structured objects (like JSON) directly in workbooks and data models.

When processing structured objects, Sigma preserves individual field data types and enforces type constraints. While this practice ensures data integrity and accuracy, it also allows you to easily access and manipulate object values without performing type conversions.

For more information, see Generate and access structured objects.

Bug fixes

  • In embeds, the workbook:chart:onvalueselect event no longer sends an empty value property.

  • Users no longer encounter false permission errors when accessing permitted tagged workbook versions.

  • Sigma now displays an error when an admin attempts to generate a signed embed URL for a public embed.

  • Bookmark selection for exports is now available only when all attachments are PDF or PNG files.