What's new in Sigma
Admin
Self-serve audit logging features (GA)
The Administration portal now includes an Account > General Settings > Audit Logging section that supports the following self-serve features:
- Sigma Audit Logs: Enable audit logging by activating the Sigma Audit Logs connection.
- Create, update, or delete an Audit Logs Storage Integration: Add, update, or delete a cloud storage integration specifically for exporting audit log data to AWS, Azure, or GCP
Audit logs functionality also has improved SLIs for data freshness and delivery. Fresh event data is available within an hour 99.9% of the time, and new audit log events are available at least once 99.9% of the time.
For more information, see Enable audit logging and Create, update, and delete an audit logs storage integration.
API
New workbook bookmarks API endpoints
The following endpoints to work with bookmarks in workbooks, including version tagged workbooks, are now available:
- List bookmarks in a workbook (
GET /v2/workbooks/{workbookId}/bookmarks
) - Add a bookmark to a workbook (
POST /v2/workbooks/{workbookId}/bookmarks
) - Get a bookmark (
GET /v2/workbooks/{workbookId}/bookmarks/{bookmarkId}
) - Update a workbook bookmark (
PATCH /v2/workbooks/{workbookId}/bookmarks/{bookmarkId}
) - Delete a bookmark from a workbook (
DELETE /v2/workbooks/{workbookId}/bookmarks/{bookmarkId}
)
The same endpoints are available for tagged workbooks:
- List bookmarks in a tagged workbook (
GET /v2/workbooks/{workbookId}/tags/{tagName}/bookmarks
) - Add a bookmark to a tagged workbook (
POST /v2/workbooks/{workbookId}/tags/{tagName}/bookmarks/
) - Get a bookmark in a tagged workbook (
GET /v2/workbooks/{workbookId}/tags/{tagName}/bookmarks/{bookmarkId}
) - Update a bookmark in a tagged workbook (
PATCH /v2/workbooks/{workbookId}/tags/{tagName}/bookmarks/{bookmarkId}
) - Delete a bookmark from a tagged workbook (
DELETE /v2/workbooks/{workbookId}/tags/{tagName}/bookmarks/{bookmarkId}
)
New response output for List templates shared with your organization endpoint
The entries array includes one additional property in the response for the List templates shared with your organization (GET /v2/shared_templates/shared_with_you
) endpoint:
- createdAt: When the template was shared with your organization
New endpoint for workbook version history
The following endpoint for retrieving the version history of a workbook is now available:
- Get version history for a workbook (
GET /v2/workbooks/{workbookId}/version-history
)
Embeds
Embed SDK for React (Beta)
The Embed SDK for React offers a developer-friendly interface that simplifies integration into applications. Developers can access detailed installation and usage guides on Github.
See Embed SDK for React (Beta) or follow this QuickStart for an in-depth guide to using the SDK.
Functions and calculations
Write, correct, and explain formulas using the AI formula assistant (Beta)
Sigma’s formula assistant uses AI to write new formulas, correct formula errors, and explain existing formulas applied to elements in workbooks and data models. These AI capabilities can help enhance productivity and accuracy, ensuring you get the most out of custom calculations and available functions.
For more information, see Use AI with formulas (Beta).
Workbook elements
Format segmented control alignment
You can now format the alignment of a segmented control. Align the control to the left or right, or stretch the control to the full width of the control element.
For more details, see Create and configure a segmented control.
Expanded text formatting options for conditional formatting
When you apply conditional formatting to a table or pivot table, you can format the style of the text. Conditionally apply underline, italics, or a specific text color to text.
Workbook features
Updated workbook theme colors and settings
The colors used for organization and workbook themes have been updated, and there are new settings to override the canvas color or element background color for a workbook theme.
Workbooks using existing themes have been migrated to the new colors. As a result, existing theme colors might have an override canvas color or override element background color already set. If your workbook does not look as expected, review the following known issues and workarounds:
- If your background is no longer white or black, set override colors for both the Canvas and Element.
- If your workbook is oddly pastel and bright, adjust the Surface color. Open the color picker and drag the color picker to the bottom of the color field.
- If your workbook has a tinted color instead of gray, adjust the Surface color. Open the color picker and drag the color picker all the way to the left of the color field.
- If your theme was originally based on a preset theme, reapply the preset and adjust the Primary color.
If the colors in your workbook appear overly saturated, adjust the Theme colors to use less saturated colors.
See Theme settings for more details. For further assistance, contact Sigma Support.
Specify color palette with hex codes
To more precisely specify the visualization color palette for your workbook, you can specify a custom color palette with hex codes.
See Workbook settings overview.
Custom sort null values in pivot tables
Specify the sort order of null values in a pivot row or pivot column using custom sort. Choose from the default option, which mimics your data warehouse sort order for null values, listing all null values first, or listing all null values last.
For more details, see Customize the sort order of data elements.
Bug fix
- When tagging a version of a workbook that contains only input tables, you can now swap data sources successfully.