> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# What's new in Sigma

> Sigma release notes for May 3, 2024: ArrayAggDistinct function, record formula support, and more.

## 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](https://help.sigmacomputing.com/docs/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](https://help.sigmacomputing.com/docs/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.