> 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.

# Array functions

> Browse Sigma array functions available in formulas and calculations.

Array functions create, manage, and manipulate arrays (lists of indexed values).

| Function                                     | Description                                                                                                                  |
| :------------------------------------------- | :--------------------------------------------------------------------------------------------------------------------------- |
| [Array](/docs/array)                         | Returns an array containing specified values.                                                                                |
| [ArrayCompact](/docs/arraycompact)           | Removes nulls from an array.                                                                                                 |
| [ArrayConcat](/docs/arrayconcat)             | Combines multiple arrays into one array.                                                                                     |
| [ArrayContains](/docs/arraycontains)         | Searches for a specific value in an array. If the value is found, the function returns `True`, otherwise it returns `False`. |
| [ArrayDistinct](/docs/arraydistinct)         | Returns the array without duplicate values.                                                                                  |
| [ArrayExcept](/docs/arrayexcept)             | Returns an array of all unique elements from one specified array not included in another specified array.                    |
| [ArrayIntersection](/docs/arrayintersection) | Compares two arrays and returns an array of all overlapping elements, without duplicates.                                    |
| [ArrayJoin](/docs/arrayjoin)                 | Joins elements of an array into a single text string.                                                                        |
| [ArrayLength](/docs/arraylength)             | Determines the number of entries in an array, or list.                                                                       |
| [ArraySlice](/docs/arrayslice)               | Returns a portion of an array, defined by the starting index and length.                                                     |
| [RaggedHierarchy](/docs/raggedhierarchy)     | Constructs a hierarchy with the values of the specified columns.                                                             |
| [Sequence](/docs/sequence)                   | Returns an arithmetic sequence as an array of integers based on a specified range and increment                              |
| [SplitToArray](/docs/splittoarray)           | Splits a specified string by a given delimiter and returns an array of substrings.                                           |
| [Sparkline (Beta)](/docs/sparkline)          | Generates sparkline charts from an array of JSON objects.                                                                    |
| [SparklineAgg (Beta)](/docs/sparklineagg)    | Generates sparkline charts by aggregating values over time.                                                                  |

The following [aggregate functions](#aggregate-functions) also create arrays:

|                                            |                                                                                                       |
| :----------------------------------------- | :---------------------------------------------------------------------------------------------------- |
| [ArrayAgg](/docs/arrayagg)                 | Identifies non-null row values in a column or group and aggregates them into a single array.          |
| [ArrayAggDistinct](/docs/arrayaggdistinct) | Identifies distinct non-null row values in a column or group and aggregates them into a single array. |