2022 release notes archive

December 21, 2022

AlloyDB Connection (Beta)

Sigma added a new data warehouse that Sigma customers can connect to. You can now configure an AlloyDB connection with Sigma. To learn more about configuring an AllloyDB connection, see Connect to AlloyDB.

December 19, 2022

Sankey diagrams (Beta)

Sankey diagrams are now available in workbooks. This visualization type demonstrates the flow and change of data between various stages, categories, and time periods. With sankey diagrams, you can compare the movement and quantity of data across different paths to analyze workflow structure, resource distribution, process efficiency, etc.

For more information, see Build a Sankey Diagram.

December 8, 2022

We released two new functions: FirstNonNull and LastNonNull. FirstNonNull repeats the first non-null value of a given column for every row in a column. LastNonNull repeats the last non-null value of a given column for every row in a column. Both functions can be used as either an aggregate or window function.

December 5, 2022

• We released a new workbook feature: synced controls.
  Synced controls are workbook control elements that have identical, synchronized copies. These copies automatically update in unison as a user changes their values. Synced copies can help maintain context when a control impacts elements across multiple workbook pages. They can also be used to encourage pre-selection of control values before data loads on other pages. Learn more
• We released a new workbook feature: required controls.
  When you mark a control required, data on the same page doesn’t load until the required control has a selection.

November 30, 2022

ArrayContains

The ArrayContains function allows you to searches for a specific value in a list (or array). If the value is found in the list, the function returns "True," otherwise it returns "False."

For more information, see ArrayContains.

November 28, 2022

• We added the option to include multiple attachments in individual sent and scheduled exports. To add an additional attachment to your export, click + Add another attachment.
  Attachment size limits vary by destination.
  an image from the send now screen listing three selected attachments. A text button below reads: + Add additional attachment.
• We added the option to send or schedule an export of all visible pages of a workbook as a single PDF. To use this option, select Entire workbook as an attachment when setting up your export or schedule.
• Sigma often performs calculations directly in the browser to help reduce the number of queries hitting your warehouse. To help you understand when this happens, we added an option to view workbook browser calculations in the query history. To try this feature, open your workbook’s query history and switch on View browser calculations.

November 22, 2022

User 360

Sigma now offers admins both a single source of truth for every user in your organization, as well as the ability to take certain actions on a user. To access this new feature, select a user on the People tab in the admin panel. This launches the new user profile. From the user profile, admins can take actions on a user, such as:

• View & edit a user's account type
• View user attributes assigned to a user
• View, edit, or add a user to teams
• Upload a profile image

To learn more about User 360, see Manage Users with User 360.

November 4, 2022

We fixed the following bugs:

• Fixed: The Share workbook modal only suggested up to 2 teams at a time. Now, it always displays up to 5 teams and/or members, when available. If there are 3 or more members, we still display at most 2 teams. But if there are less than 3 members, we display more teams.
• Fixed: Long names and email addresses were poorly rendered in the Admin Portal’s Create New API Token or Embed Secret modal.
• Fixed: In the Admin Portal, refreshing an account types’ details page resulted in the list of members containing members of different account types.
• Fixed: In some cases, the search page’s owner list did not scroll as expected.
• Fixed: In some cases, scheduled exports from embedded workbooks reflected the original workbook’s filter settings, rather than those applied to the embed.
• Fixed: In some cases, users were seeing a Duplicate dataset menu option, despite not having permission to perform the action.
• Fixed: The Recover this document dialog box appeared upon opening old links to deleted cloud data warehouse tables. This option is relevant only to Sigma documents. CDW tables must be managed directly from your CDW

We made the following change:

• The Admin managed Export Authentication feature now uses the terminology “Authorized domains” instead of “Restricted domains.” This is a terminology change only.

November 1, 2022

• Beginning 11/1/2022, all new organizations support shared, live drafts. This new feature is gradually being rolled out to legacy organizations. Organizations Admins will be notified before the change is made.
• We now provide source recommendations for workbook joins. Our recommendations give you quick access to common joins used in your organization. They can be found on the left side of the page under RECOMMENDED SOURCES when you create or edit a join.

October 18, 2022

• We added the option to include trend lines in visualizations. Trend lines are lines added to visualizations to highlight and predict patterns across multiple values in a set of data.
  Trend line configuration is accessible from a visualization’s format panel. Learn more

October 14, 2022

[Beta] We added the ability to integrate dbt jobs with Sigma. You can access the docs & metadata generated from dbt jobs directly in Sigma.

Some of the benefits of this integration are:

• Data freshness: The dbt job execution data is displayed in the Sigma which allows you to verify the freshness of the data.
• Data quality: You can view dbt quality tests on columns and models in Sigma, which provides a greater degree of transparency into data quality issues.
• Data cataloging: The dbt table and column descriptions are displayed in Sigma, providing users with additional insights into the data they will explore.

To learn more about integrating dbt with Sigma, see Configure Sigma for dbt.

October 11, 2022

We released 3 new functions for calculating subtotals and percentages of totals in workbook grouping tables, pivot tables and visualizations.

• PercentOfTotal returns the percent of total for an aggregate formula
• SubTotal returns the subtotal for an aggregate formula
• GrandTotal the grand total for the given aggregate formula. This function is shorthand for Subtotal(aggregate, "grand_total").

October 5, 2022

Fixed: The list of Scheduled Exports in the Administration portal displayed an incomplete list. Admins now see a complete list of scheduled exports.

October 3, 2022

• In a connection table on the Lineage tab, when you hover over a document icon it now displays the document type.
• Fixed: CSV file upload is now restricted to .csv file types.
• Fixed: New user accounts created via Company Domain Signup were issued a Creator license type, regardless of the license type set in the Invitation Default field under Account Types.

September 30, 2022

We enhanced the Date Range data element filter to improve usability. It's now easier to select relative dates, such as "Last 14 Days" and "Current Month." To access the original date filters, select "Custom" from the dropdown menu.

To learn more about data filters, see Data Element Filters.

September 14, 2022

Fixed: Pivot tables could not be used as data sources for joins in workbooks.

September 12, 2022

• We enhanced the admin experience by extending the capacity of bulk actions on the People and Account Types tabs.
• We added the total selected users and buttons to deactivate or reassign account types.
• On the People tab, the list of users now loads as you scroll down and the numbers to the right of Account Type show the number of members currently displayed/total number of members.
• We added bulk actions to the detail page for Account Types.
• When you add filters to the People page, the filters are displayed in the search bar. Click the X to remove the filter.
• We added an option to name individual workbook export schedules. To create or update a scheduled export, open the workbook’s header menu (▼) and select Schedule exports.
• Fixed: Workbook themes were not applying correctly to element titles and table elements.

September 10, 2022

• We improved how permission errors are displayed in workbook lineage. Boxes representing elements or data sources with this error are now displayed with a red border.
• Fixed: In some cases, renaming links caused publishing errors.
• Fixed: In some cases, line chart x-axes started before the first value.

September 7, 2022

We added the option to resize multiple table columns at once. To do this, hold down Shift, select the columns, and use the drag handle in the column header to resize.

September 6, 2022

• We made Sigma’s default account types editable. To begin editing an account type, open the account type under Administration > Account Types.
• Fixed: In some cases, button and image elements set to “Go to top of page” did not behave as expected when clicked.
• Fixed: In some cases, Least() and Greatest() did not return expected results when passed a null value.

September 1, 2022

• Fixed: New conditional formatting rules set on single value visualizations were not successfully accepting edits.
• Fixed: In some cases, DateAdd() returned incorrect month results when numbers were negative.
• Fixed: In some cases, workbook source swapping took longer than expected. This only occurred when a significant number of edits were involved in the swap.
• Fixed: Public embeds displayed a button that shouldn’t have been there. This button, Copy URL, is only valid in Sigma, not in embeds.
• We improved the usefulness of our Databricks connection errors by displaying warehouse generated errors when relevant and available.

August 31, 2022

• Fixed: Control values applied to workbooks through their URLs were not applied to exported PDFs.
  • Fixed: Two dataset materialization menu options – Copy path and Rename view – were not responding when clicked.

August 30, 2022

• We added PDF (Landscape) and PDF (Portrait) options to workbook tabs’ caret (▼) menus. To find these options, open ▼ > Export. Previously, there was only one option: Export as PDF.
• We added PDF (Landscape) and PDF (Portrait) options to elements’ more (•••) menus. To find these options, open ••• > Download.
• Fixed: In some cases, Date functions did not return expected results when applied to data in Databricks connections. This only happened when the input value was not zero padded (e.g 1-1-2021 wasn’t accepted but 01-01-2021 was).

August 29, 2022

Fixed: The clear selection (x) button that was missing for date controls.

August 27, 2022

• Fixed: Pivot table conditional formatting rules containing a custom formula or referencing a parameter didn’t work for totals / subtotals.
• Fixed: Control filter lists with the Show search box setting disabled disregarded it, showing the search box anyway.

August 26, 2022

Fixed: In some cases, child elements could not be created from a small subset of existing workbook elements.

August 25, 2022

• Fixed: In some cases, control filters configured to use a display column instead displayed the control’s source column.
• Fixed: The zoom controls (+/-) on workbook lineage pages were broken.

August 23, 2022

• We added column freezing to workbook tables. Frozen columns are always visible, even when scrolling horizontally through the table. To freeze a column and any columns before it, open the column’s menu and select Freeze up to column.
• Fixed: In some cases, a CSV uploaded to Databricks from Sigma rendered incorrectly.

August 22, 2022

Fixed: Hyperlinks were not applied to pivot table cells when Show Totals was disabled.

August 18, 2022

• Workbook themes are now applied to highlighted text in text elements.
• We added datetime support to the Number() function. Pass a date value to Number() to convert it to a number.

August 17, 2022

• Fixed: In some cases, previews of updated CSVs did not load correctly in the Replace CSV modal.
• Fixed: Tooltip values in bar charts were not displayed in a logical order. They are now ordered based on the grouping order of the chart’s data. To understand how data is grouped in a visualization from the perspective of a table, expand the visualization to its focus view.
• Fixed: The One-Click PDF export button returned an error for user-backed embeds.

August 16, 2022

We reworded datasets’ materialization history statuses to be more reader-friendly.

August 15, 2022

• Fixed: List filters (include/exclude) briefly displayed dates in their unix/epoch time form, rather than as formatted in Sigma.
• Fixed: If exported to Excel, number columns formatted as Pounds (£) in Sigma were displayed as Dollars ($) in the exported file.

August 12, 2022

Saved embedded workbooks now trigger workbook:loaded and workbook:variables:onchange JavaScript events.

August 8, 2022

• Dynamic text now carries over its formula when copied and pasted into a text element.
• Fixed: True/false control filters did not work correctly when their Allow multiple selection option was deselected.
• Fixed: In some cases, unions (beta) did not work with aggregated data.

August 5, 2022

Dynamic text is now included in the warning message displayed upon attempted deletion of a parent data element. This warning message, which appears only when an element has one or more child elements, lists all elements that may be impacted by its deletion.

August 4, 2022

Elements that have been commented on now include the number of associated comments next to the Comment list item in their more (•••) menu.

August 3, 2022

• We added "Deactivated" to the filter on the People tab in the Administration portal. Previously, "Disabled" and "Inactive" were both available.
• Fixed: Custom plugin queries consistently ran before other data element queries, regardless of placement. This caused a delay in the display of non-plugin elements. Non-plugin elements are now queried before plugins.
• Fixed: Lookups containing any additional custom formula logic were not displayed correctly in their workbooks’ lineage diagrams. This included Rollups.

August 2, 2022

[Beta] User-backed embed users can now export a doc to email, slack, or cloud storage before saving their work.

August 1, 2022

You can now copy a data element’s formatting and paste it to another element. To copy or paste a format: select the element, open its format panel, and select either Copy format or Paste format from the panels more (•••) menu.

July 28, 2022

• You can now hide underlying data from embed users with explore access by adding :showUnderlyingData=false to the URL.
• We added a recents section to the custom color picker.
• Fixed: Custom formatting was not available for dynamic text.

July 26, 2022

We added an option to use Monday as the start of a week for relative date filters. To use this option, select Week starting Monday under the filter’s Relative tab.

July 25, 2022

• We made the /new document URL shortcut work regardless of authentication status. This shortcut automatically creates a new workbook in your organization. To use it, add /new at the end of your organization's URL (e.g. app.sigmacomputing.com/mycoolcompany/new). Users not logged into the organization will be prompted to log in before being redirected to the new document flow.
• Fixed: Empty workbook page sections could not be deleted.

July 24, 2022

• We improved button navigation to elements on the same workbook page. The page now auto scrolls to the element, in addition to the element being selected.
• Fixed: In some cases, duplicating a summary value would initially display incorrect data. Refreshing the page or data would correct the issue.
• Fixed: An issue was encountered when expanding and collapsing groupings in some tables with many groupings.

July 21, 2022

• ​​We added a new formatting option to visualization legends: Label text color. To use this option, open the elements format panel and go to LEGEND > Label text color.
• We updated the workbook comments panel to respond to data element selection, when open. Select an element, and the panel filters to show only comments associated with that element.
• Fixed: In some cases, Count() returned incorrect values when passed a column containing null values.
• Fixed: In some cases, SumIf() returned 0 when it should have returned null.

July 20, 2022

• User backed embedding (beta) now includes a Favorites folder for users with save permission.
• Fixed: Occasionally, data elements would not respond to their filters. This issue was tied specifically to elements sourced by small parent elements.

July 19, 2022

• Control elements now recognize values in comma separated lists as independent values.

July 18, 2022

• We made a slight modification to the Controls section of the Scheduled Exports modal. The + Select Control button was replaced with a simpler search bar.
• Columns set to Today() are now automatically auto formatted to display just the date (e.g. 2022-18-22). Previously, they were formatted as date/time, with time set to 00:00:00.
• Columns set to Now() or Today() are now auto named accordingly.
• Element duplication was reverted to a single menu option: Duplicate. User feedback suggests this is preferable to the nested Duplicate to submenu.

July 15, 2022

Fixed: Some visualization titles were cut off in View and Explore mode.

July 14, 2022

• We added a way for you to identify where a parameter is used in a workbook. To see a list of referencing elements, select the parameter and in the editor panel under SOURCES, look for the section titled Currently referenced by.
• We added a custom domain color scale option to map charts. This option allows you to define a color scale’s minimum, middle, and maximum values. To enable this option from a map’s editor panel, look under MARKS > COLOR, select By scale from the dropdown, click on the color scale menu, and select Customize domain from the popup.
• Filter options selected from a cell’s right-click menu are now automatically applied to any associated control elements.
• Fixed: In some cases, if you clicked Select Control to customize control values for a scheduled export, the list would be unusable.

July 10, 2022

• [Beta] Users can now pause scheduled exports by clicking on Scheduled Exports > click the more ••• menu in the Actions column > select Pause.
  We also added a Status column so users can monitor the status of their Scheduled Exports. If a Scheduledxport fails more than 5 times in 7 days, Sigma will pause the export and the user will receive an email notification. Users can manually resume the export.
• We added multi-select functionality to maps. To use this feature, press Cmd (for mac) or Ctrl while clicking areas on the map.
• Fixed: In some cases, area charts were clipped due to an underlying sort issue.

July 7, 2022

• User Attributes are now generally available to all organizations. This allows you to enforce row-level security by creating a user attribute and assigning it to teams.
• We also added capacity for admins to use Custom SQL with User Attributes. Once User Attributes are configured, you can use them in a Custom SQL dataset to provide security. This allows you to leverage Custom SQL to switch the schema based on the user.
• Fixed: Some attempts to upload CSVs failed with an error.

July 5, 2022

• We made workbook divider elements more customizable. You can now edit their color, width and direction (horizontal or vertical)
• We improved control to target element navigation in workbooks. If you have a control element selected with its editor panel open, clicking an element listed under TARGETS will redirect you to that target element.
• Fixed: In some cases, formulas that contained a Date function passed to a Text function did not output the up-to-date results until the page was refreshed.

July 4, 2022

• The workbook editor panel is now resize-able. To resize it, hover your cursor over its right border. Then click and drag left or right.
• List controls’ Show null option setting is now available for all manually-created lists and lists with logical( true/false) values. Previously, this option was only available for automatically generated lists. This setting is available from the editor panel when the control is selected.

June 30, 2022

• Fixed: Drilling down on a bar chart's x-axis caused errors if the plotted column contained date values and referenced a parameter.

June 29, 2022

• Button and image elements can be used to redirect users to other elements and pages in the workbook. To use this option, select the element to open the editor panel. Click Go to target on this workbook. Then select a target.
• New columns can now be added to all pivot table fields. To add a new field, click the plus (+) button located to the field header in the editor panel. Then click New column.
• Fixed: Some attempts to UUID columns stored in Postgres resulted in errors. This could be triggered in a few scenarios, including usage of Min(), Max(), and Lookups.

June 27, 2022

• [Beta] We added a new data warehouse that Sigma customers can connect to. You can now configure a Databricks connection with Sigma. To learn more about configuring a Databricks connection, see Connect to Databricks.
• All functions that accept a constant value now take parameter controls for those arguments. Example: DatePart, which accepts three arguments — procession, date, and time zone — now accepts parameters for precision and time zone.
• Workbook tables now support custom background colors. This option is available in the elements Format panel under BACKGROUND > Background color.
• New function alert: MaxIf returns the maximum value in a column if all of the conditions are true.
• New function alert: MinIf returns the minimum value in a column if all of the conditions are true.
• New function alert: CountDistinctIf counts the number of unique values in a column or group that satisfy all given conditions.
• New function alert: AvgIf calculates the numerical average of a column of values that satisfy all given conditions.
• On the workbook Create Join preview page (beta), key column previews now live below the column statistics in the top right of the page. Previously, they were displayed to the left of the JOIN OUTPUT preview at the bottom of the page.

June 24, 2022

• You can now deactivate users in bulk and reassign their documents to specific users. To do this, go to Admin Portal > People > Members tab and check the users to deactivate.
• Double clicking on a visualization without a predefined drill path now automatically opens the visualization’s Drill down modal. The existing behavior for visualizations with predefined drillpaths has not changed.
• You can now bold data element titles. This option is available in the element’s Format panel under TITLE.
• Basic categorical structure was added to the dashboard dropdown list on the Admin Portal’s Usage page.
• Our Confirm Deletion modal has a fresh new look. No functionality has changed.
• Fixed: New control elements set to filter by text match did not automatically include nulls. This did not align with the default behavior for text match filters created directly on individual elements. All new text match filters and controls now default to include nulls. To exclude nulls, open the filter’s menu and uncheck Include nulls.
• Fixed: When enabled, control filters’ Show null option removed 0s from the value list.

June 22, 2022

• You can now add hyperlinks to any column type in workbook tables and pivot tables. Previously, this feature was only available for text columns.
• You can now select whether a filter control list includes an “All” option. This option (Show All option) is available from the editor panel when the control element is selected in Edit mode. This option is only included in the list when the list has less than 200 values.
• Fixed: In some cases, the Create Workspace modal couldn’t be dismissed.
• Fixed: In some cases, the Lag() function displayed the following error in a pivot table. Window function lag requires an order by clause.

June 17, 2022

• You can add a new page in a workbook between two existing pages, rather than at the end of the pages. To do this, right-click between two pages and click Add New Page.
• Custom plugin elements are now included in workbooks’ lineage when applicable.
• Fixed: Pivot table columns transformed to include hyperlinks instead displayed null values.
• Fixed: In some text boxes, format changes for date or numeric values revert to the default value.
• Fixed: Some custom account types failed to display special characters when viewed in Account Types.
• Fixed: In some cases, if you create parameters in a workbook it will result in an error.
• Fixed: When users were marked as inactive in Okta, they were added to the count in the Account Type page summary in Sigma.

June 16, 2022

• An element’s filter popup now differentiates between element-specific filters and filters associated with a control element.
• Attention Admins — A new Sigma usage dashboard, Materializations, is now available in your Admin Portal. This dashboard aims to show you how your organization is using dataset materializations. To view this dashboard, go to Administration > Usage > Materializations.
• Workbook page tabs now support right-click to open their menu. This menu offers page actions, including but not limited to delete, hide, duplicate, and export as PDF.
• Sigma’s formula bar now accepts all forms of quotation marks, reducing possible friction when you paste in text.
• Fixed: In some cases, parameter lists showed stale data.
• Fixed: In some cases, blank pages were added to the end of PDF exports.

June 14, 2022

• A set of Snowflake usage templates are now available in your template gallery. To begin using these templates with your own data, first add your snowflake usage data to your connected warehouse. Then use Sigma’s new source swapping beta feature to inject your organization’s Snowflake data directly into any of the templates. The following templates are available: Snowflake Compute Cost, Snowflake Performance Monitoring, Snowflake Reader Cost, and Snowflake Storage Cost.
• [Beta] A source swapping option is now available for all workbooks. This new feature allows you to see all of a workbook’s sources in one spot and swap them out with new sources, mapping the old columns to the new. To begin swapping a workbook’s data source(s): open the workbook’s header menu and click Swap data sources.
• Fixed: Workbook creators and editors could not see other users’ export schedules within a document.

June 13, 2022

• Fixed: Some PDF exported pivot tables with text wrapping applied displayed overlapping text.

June 10, 2022

• Fixed: Edit mode was broken for custom SQL generated datasets.

June 9, 2022

• [Beta] User-Backed Embedding is now available. Built as an extension of application embedding, this feature treats each embed consumer as an individual with individual and team permissions. Embed creators can choose to allow embed users to save and edit copied versions of their embeds. This feature pairs well with Sigma’s new User Attributes feature and other forms of row-level security (RLS).
• [Beta] We added a User Attribute tab in the Sigma Admin portal which allows you to enforce row-level security by creating a user attribute and assigning it to teams. This functionality allows admins to limit the information users can see based on the attribute value. Once you create and assign a user attribute to teams, you can use this functionality in a workbook to enforce row-level security using the function CurrentUserAttributeText in a formula.
  To configure User Attributes, go to Admin portal > User Attributes > Create Attribute.
• New function alert: CurrentUserAttributeText returns the attribute value for the current user as text.
• Fixed: Touch screen devices always showed elements’ inline toolbars. They are now accessible when the element is selected. Non-touchscreen devices still display them on hover.
• Fixed: Lag([Col], N, Null) was incorrectly sending a type error.

June 7, 2022

• Fixed: Attempts to delete users with an active API key failed with an error.

June 6, 2022

• Workbook element filters have moved. They can now be accessed from the filter button in the element's inline toolbar. Each element's popup filter list is draggable. The popup includes both element filters and references to controls associated with the element.
• Workbook comments are now received instantly in open workbooks, allowing you to communicate on the spot. You can watch the comment button in your workbook’s header for comment notifications. There’s no need to leave the comment panel open.
• Fixed: Workbooks’ select source flow displayed incorrect schemas for warehouse tables listed under the IN USE tab.
• Fixed: In some cases, pivot table sorting was not applied correctly to exported versions.

June 3, 2022

• Workbook table summary columns now fully support column descriptions.
• A new empty state has been added to blank workbooks in explore and view mode.
• Fixed: Under certain conditions, some pie charts were not responding correctly to filtering.

June 2, 2022

• You can now include bar percentages in stacked bar chart tooltips. This option is listed in the editor panel’s format tab under TOOLTIP for all stacked bar charts with a column on their COLOR mark.

June 1, 2022

• You can now drag to reorder grouping key (GROUP BY) columns in a table grouping.

May 31, 2022

• The Updated Sources modal, which appears when an underlying dataset or warehouse table’s columns change, previously required that replacement columns have the same column type as their predecessor. This requirement has been removed.

May 29, 2022

• Auto-generated names of Lookup columns now update to match a change in formula.

May 26, 2022

• Workbook tables now support multiple grouping keys per grouping.
• A shareable template URL is now available on the first tab in templates’ Share modals. The link itself does not share the template; it will only work for users already granted permission to access the template.
• A keyboard shortcut — Cmd+Enter — was added for the SQL Runner’s Run button.
• Fixed: When creating/editing a custom account type, selecting the Creator type did not switch on feature permissions for editing workbooks.

May 24, 2022

• Workbook editors can now add descriptions to data element columns. To do this, open the column’s menu and click Set description. To view an existing column description, hover your cursor over the column header.
• Fixed: Rank window functions, such as RankDense(), were not evaluated correctly when applied to columns within a workbook table grouping.

May 23, 2022

• Users with Can Edit or Can Explore access to a workbook can now download the underlying data for pivot tables and visualizations.
• Maps now accept both text and number columns as zip code data.
• Fixed: Case sensitivity is no longer considered for invited user email addresses.
• Fixed: Map titles were not updating in response to custom locale translations in embedded workbooks.

May 19, 2022

• Lookup and linked column cell popups are now draggable.
• Fixed: Some popups were not opening on mobile devices.

May 18, 2022

• The Add/Edit Lookup popup is now draggable.
• Fixed: Filters referring to dataset links were not working in embedded workbooks.

May 17, 2022

• Fixed: Scheduled exports to Google Sheets were not being saved with their user-defined control values.

May 16, 2022

• You can now access a data element’s source options directly from the element’s menu. These options can also be found at the bottom of the editor panel when the element is selected. This feature is only available for users with Edit or Explore access to the workbook, and options vary between these modes.
• Fixed: Right-click filter options were not working for null value bars in bar charts.

May 13, 2022

• Fixed: In some cases, filtering a pivot table column could result in accidental display of null values. Refreshing the browser would correct the table.
• Fixed: Visualizations using drill controls were being removed as control targets whenever any of their columns were deleted.

May 12, 2022

• [Beta] Organizations using Snowflake can now export elements in their workbooks to cloud storage in machine-readable and (optionally) gzipped CSVs. Standard scheduled export functionality like conditional scheduling, controls, etc. work for this export type as well.
• A new keyboard shortcut — Shift + F — will focus the element filter for a selected column
• Fixed: In some cases fixed-precision values were losing their precision, leading to incorrect data.

May 11, 2022

• Fixed: Folder permission levels were displayed using document permission level names.
• Fixed: Bar chart formatting options included Bar width, even when the option was not supported. This format option is only available for charts with ordinal scales.
• Fixed: In some cases, deactivated users were displayed as “active” on the Admin Portal’s People page.

May 9, 2022

• Attention Admins: you can now create guest user accounts. Guest user accounts are password authenticated and allow you to enforce strictly limited access to your organization. This feature is particularly helpful if you are interested in giving external vendors limited team-based access to Sigma.
• Workbook editors can duplicate elements to any page in their workbook. Previously, the Duplicate action — available from an element’s menu — automatically created the duplicate on the same page. It now contains a submenu with multiple options.
• Query history now contains a link to the workbook element associated with each individual query. This link can be found next to the query’s request type.
• A shareable workbook URL is now available on the first tab in workbooks’ Share modals. The link itself does not share the workbook; it will only work for users already granted permission to access the workbook.
• Fixed: Workbooks sometimes appeared jittery. This only happened in very specific circumstances.
• Fixed: Sigma’s custom color picker did not display dates values in their correct format.

May 4, 2022

• There’s a quicker way to add links to workbook text. Hit Cmd + k on your keyboard to open the link modal.
• Fixed: Some controls were not responsive to touch on Android mobile devices.

May 2, 2022

• We removed the Link Sharing tab from the workbook Share modal. This tab, which acted as an alternative way to share with “All members”, was causing confusion for some users. For the same effect, share your workbook with “All members.”
• Fixed: Lookup columns in embedded workbooks were not calculated correctly if they referenced data on a hidden page.
• Fixed: Deleted documents temporarily could not be recovered.

April 29, 2022

• Workbook export schedules are now visible only to their creator and admins. This will prevent you and your teammates from accidentally modifying each others’ schedules.
• A new color palette is available for visualizations.
• Fixed: Parameters were not working correctly in SQL-based datasets.

April 27, 2022

• [Beta] You can now create joins in workbooks. This feature allows you to join combine data from multiple sources based on matching columns.

April 24, 2022

• Workbooks’ lineage pages now show details about lookups.

April 22, 2022

• Stacked area charts now support AREA SHAPE formatting. Previously, this format category was only available for unstacked area charts.
• Fixed: Folders and workspaces were temporarily missing their delete and rename menu options.

April 21, 2022

• You can now export up to 1M rows of data, an increase from the previous 150k limit. This new limit automatically applies to all manual exports and scheduled exports to Google Sheets. To apply this new limit to any existing scheduled CSV (.csv) or Excel (.xlsx) exports created before 10am PT on April 22nd, please recreate the schedule.
• Fixed: Map legends displayed low value percents (0%-10%) as 0% for columns added under MARKS > COLOR.

April 20, 2022

• We've added keyboard shortcuts for text alignment in text elements:
  • Text align left: Option+Cmd+L
  • Text align center: Option+Cmd+T
  • Text align right: Option+Cmd+R
• Embedded workbook translations are available for three more languages: Polish (pl), Spanish (es), Russian (ru), German (de), Japanese (ja), and Thai (th).
• Attention Admins — A new Sigma usage dashboard, Scheduled Exports, is now available in your Admin Portal.
• Fixed: In some cases, the Admin Portal's People page was failing to load.

April 19, 2022

• Fixed: Adding new value options to a list control force unwanted setting changes on the control.
• Fixed: Deactivated accounts were included in the license type counter in the Admin Portal.

April 18, 2022

• We've added two new shortcuts for cell selection in workbook tables:
  • To select a row of cells, select one or more individual cells in the row, and hit Shift+Space on your keyboard.
  • To select a column of cells, select one or more individual cells in the column, and hit Ctrl+Space on your keyboard.
• Fixed: In some cases, embedded workbooks displayed dates in the wrong time zone.

April 15, 2022

• Table groupings displayed in the workbook editor panel now have individual GROUP BY headers. Grab any group by its header to drag it to a different position in the grouping hierarchy.
• Attention Admins — If your organization has a lot of users, you will likely see improved load times on your Admin Portal's People page.

April 14, 2022

• You can now select all cells in a workbook table by selecting the element and hitting Cmd/Ctrl + a on your keyboard.
• Fixed: Keyboard shortcuts for multi-selection of columns were not behaving as expected. To select multiple columns, hold down Shift while clicking each column.
• Fixed: Some exports to Excel (.xlsx) were missing data.
• Fixed: We fixed a series of display issues encountered in PDF exports.

April 13, 2022

• Fixed: Column format annotation was not displaying correctly for a specific set of numbers.

April 11, 2022

• Fixed: Edits to custom account type descriptions were not saving.
• Fixed: Function-generated dynamic text was not respecting inherited formatting.

April 7, 2022

• Embedded workbook translations are now available for three more languages: European Portuguese (pt), Brazilian Portuguese (pt-br), and Italian (it).
• Map visualizations now store their zoom position when saved.

April 2, 2022

• Element filters and filter control elements now support alphanumeric sorting. This option is available when the filter’s type is set to either Include Values or Exclude Values.

April 1, 2022

• Visualizations targeted by one or more drill controls now automatically drill when double clicked. Each double click drills down to the next entry in the drill path or combined drill path.
• Fixed: In some cases, pie charts incorrectly paired colors and values in their legends. This was an edge case triggered by the presence of null values.

March 29, 2022

• Conditional scheduling is now available for workbook exports to Google Sheets.

March 28, 2022

• Fixed: In certain cases, workbook PDFs were displayed with illegible text.
• Fixed: After adding a new connection, users saw an error instead of schemas / tables in their Sigma data catalog. Their warehouse's content would only appear after manually refreshing the page.

March 24, 2022

• Fixed: New elements were always being added to the first page of their workbook, regardless of which page they were being added from.
• Fixed: New tables included all columns from their data source, rather than only the selected columns.

March 23, 2022

• Fixed: In specific cases, workbooks were causing the browser to crash. This happened if the workbook contained an unstacked bar chart with data label formatting applied.

March 19, 2022

• Sigma now supports French (fr-fr) translations for embedded workbooks.

March 17, 2022

• Include and exclude filters on columns with > 200 distinct values now display a message stating that only the top 200 values are listed. This is a statement only; functionality remains unchanged.

March 16, 2022

• When adding a new data source to a workbook, you will now see the Select source modal overlaying the workbook. Previously, this content was displayed as an independent page. All displayed content is unchanged. The Select button is now located in the bottom right corner instead of the top right.
• Fixed: In some cases, custom fallback fonts were not always applied when expected.

March 15, 2022

• Workbook drafts now offer Preview as explorer and Preview as viewer options. Both options are available from the Editing menu, located in workbooks’ headers when in edit mode.
• Errors caused by broken custom SQL will now direct you to the broken source.
• Workbook parameters can now be referenced in dynamic text formulas.
• When editing dynamic text formulas, you can now click a column to automatically include it in the formula.
• When editing table summary formulas, you can now click a column to automatically include it in the formula.
• Fixed: Bar charts with conditional formatting defined for one of multiple columns plotted on their y-axis were applying the rule to all columns.
• Fixed: Switching between two text elements in a workbook would sometimes cause formatting to be applied to the recently unselected text element.

March 11, 2022

• Map visualizations with plotted columns containing one or more unmappable values now provide a list of all unmappable values. This information can be accessed in the bottom right corner of the map element. It is only visible to users with edit or explore access to the workbook.
• Attention Admins and developers: A new set of API endpoints is available. These endpoints primarily serve to automate onboarding and management of users and teams in your organization.

March 9, 2022

• Fixed: In some cases, pivot tables were cut off in exported PDFs.

March 8, 2022

• Admins — Guest user invites (beta) are now sent anonymously from your organization, rather than identifying you as the sender.
• Fixed: Workbooks' updated sources modal was appearing sporadically.

March 7, 2022

• Workbook editors can now display their data as dynamic text in text elements.
• Fixed: Workbook drafts were not autosaving, causing unpublished changes to be lost.
• Fixed: In some cases, private embed links redirected already authenticated users back to the Sign in page.

March 4, 2022

• Fixed: Some pivot tables were displayed incorrectly. This was caused by a change made on February 23rd, which increased pivot tables' row limits. The change has been reversed.

February 28, 2022

• Fixed: CSV and Excel based scheduled exports were not properly reflecting control element selections.
• Fixed: Individual workbook pages could not be exported in application embeds. This action is available from a page tab's Export as PDF menu option.
• Fixed: In some cases, account types could not be deleted.

February 25, 2022

• Fixed: Data elements were not able to reference their parents' hidden columns.

February 24, 2022

• We've updated how lookups are represented in workbooks' lineage display.
• Fixed: Embedded workbook URLs were not successfully passing parameter values to hidden pages.

February 23, 2022

• Number columns now support currency formatting by locale. This option is available from columns' menus, under Format > Custom.
• Pivot tables now support displaying larger quantities of data.
  • Pivot tables that display just rows OR just columns have no size limit. Large sets of data will load as you scroll.
  • Pivot tables that display both rows AND columns have a 1,000 column value limit. Rows have no limit. If you have more than 1,000 column values, Sigma will display a message informing you that the pivot table is incomplete.
• We've added a shortcut for calculating percentile aggregates. All aggregate columns now include a percentile option in their column menu, under the Set aggregate submenu.
• You can now see a list of details for all data sources in a workbook's lineage. This includes cloud data warehouse tables, custom SQL, and Sigma datasets. To access these details, open your workbook's lineage display, and click on the data source you want to know more about.

February 21, 2022

• Users with Can View access to a workbook can now expand and collapse columns in pivot tables.
• Fixed: Conditional formatting disappeared from workbook table subtotals when underlying groups were collapsed.

February 15, 2022

• Users with Can View access to a workbook can now expand and collapse columns in tables.
• You can now apply conditional formatting to totals and grand totals in workbook tables.
• CountIf() is now used as the default aggregation type for logical (true/false) values.
• When clicking the preview option in workbooks, editors will now see the preview displayed in Edit mode.

February 13, 2022

• Fixed: Pivot tables’ conditional formatting Apply to values option was not working with custom formula based rules.

February 10, 2022

• If you have edit access to a workbook, you will now see an Edit button in the workbook’s header. The workbook will remain in Explore mode unless they explicitly click the Edit button.

February 9, 2022

• Bar charts support a new data label formatting option. Show stroke supports three options: Auto (default), on, and off. When applied, labels are colored black with a thin white border to enhance visibility.
• You can now filter the values of multiple selected cells at once.
• Fixed: Exported PDFs were displayed slightly differently when exported from Send Now vs. scheduled exports.
• Fixed: The Remove color option for workbook theme custom color palettes was not working.
• Fixed: Our exported PDF table formatting options were misleading. We displayed the text Show all table rows but only expanded the first 1k rows. We've updated the text to reflect this feature's actual behavior.
• Fixed: Users assigned the Viewer account type were able to see template, dataset, and warehouse table names listed in search results. These objects are not available to users with Viewer accounts.

February 2, 2022

• Fixed: Exported PDFs were displaying excess spacing on the left side of the page, causing wider elements to be cut off on the right.
• Fixed: Edits to custom SQL caused lookup-generated columns to break.

February 1, 2022

• Sigma’s DatePart function now supports epoch and weekday precision.
• Columns plotted as a visualization’s Tooltip Mark are now included in the visualization’s sort menu.
• Fixed: Map alerts were displayed for workbook viewers.

January 31, 2022

• [Beta] Our new cache duration beta feature allows organization admins to set cache durations on workbooks.
• [Beta] Our new warehouse redirect beta feature allows organization admins to redirect workbook data queries to different warehouses in their connected Snowflake CDW.
• Fixed: Some embedded tables were displaying columns with incorrect headers.
• Fixed: Custom SQL-generated elements were not responding to changes made to their underlying SQL.
• Fixed: On occasion, maps displayed blank with a frowny face in their top left corner

January 29, 2022

• Top N filters now exclude null values by default. Filters created prior to this change have not been impacted.
• Fixed: Number values in map legends were automatically rounding to whole numbers. This created inaccurate results for percentage formatted values.

January 26, 2022

• Bar charts with data labels now automatically display fewer labels when overcrowded. This is a default setting and can be overridden from the visualization’s format panel.
• You can now export workbook pivot tables directly to Google Sheets.
• Users with explore access to a workbook can now right click tables to filter data.
• Users with explore access to a workbook can now add linked columns to tables without first expanding the table.

January 25, 2022

• Lookup-based relationships between data elements are now displayed in their workbooks’ lineage.
• Pie and donut charts now support the option to display data labels either on the chart itself or on its legend. This option is editable from the chart’s format panel.

January 21, 2022

• Are you new to Sigma or onboarding new team members? We’ve added an introductory tutorial. To open the tutorial, click the help button located in the bottom left corner of any Sigma page. Then click Try a Tutorial.
• Table columns added from workbook lookup links are now auto named based on the table and column they are mapped from (eg. [Column Name – Table Name]).
• [Beta] Workbooks now support a limited version of localization for embeds.
• Fixed: Column-based hyperlinks were not displaying correctly.
• Fixed: Input parameters in embedded workbooks were being cleared when data elements were expanded.

January 18, 2022

• You can now filter your data by Top N. This filter type ranks and limits data in the target column based on your specifications.
• You can now send workbook drafts to email and Slack. Previously this feature was only available for published versions.
• Workbook editors can now set control element titles to be hidden. This option is available from the editor panel when the element is selected.
• Table summary values now include a Copy value to clipboard option in their dropdown menu.
• A set of existing column actions (Transform, Delete, etc.) are now available to workbook explorers without having to expand the element to its focus view.
  Attention Admins: You now have the option to disable comments across your organization. Learn how
• You can now copy cell values across multiple columns.
• When creating a new embed url, you will now see element type icons displayed next to each listed element.
• Admins, Creators, and users with custom account types that support document badging, can now badge any document they have access to.
• Fixed: Very large pivot tables were not successfully exporting to .xlsx (Excel).

January 14, 2022

• Fixed: Non-UTC dates were exported incorrectly for Postgres-housed data.

January 11, 2022

• [Beta] You can now view ancestry and relationships between workbook data elements, using Sigma’s new beta feature: lineage.
• Workbook drafts can now be sent to email and Slack via the Send now option, located in your workbook’s header.
• Columns used in custom plugins can now be rearranged in the editor panel using drag and drop.
  Worksheets’ data element filter bars now respect theme settings.
• Bar charts support a new data label formatting option: Show stroke. When selected, labels are colored black with a thin white border to enhance visibility.
• Fixed: In some cases, the DateDiff function did not correctly calculate “week" units.

January 6, 2022

• You can now upload CSVs to Postgres connections, if the option is enabled by an organization Admin.
• Fixed: The data source selection page was not properly updating data previews when switching between data sources.

January 4, 2022

• Bar charts now automatically hide data labels for very short bars, preventing excess cramping. This is part of an ongoing effort to improve visualization data label formatting.
• You can now copy multiple selected cells in a table without duplicate values being automatically removed the list.

January 3, 2022

• You can now export workbook tables directly to Google Sheets.
• You can now duplicate workbook control elements. To do so, (1) open the element’s ••• menu (2) click Duplicate element.
• Attention Admins: You can now set a default account type for all email-based member invites. This setting — Invitation default — is located at the top of your Admin Portal’s Account Types page. It is only used when you invite new members through your Sigma Admin Portal; it is not used as a default account type for Single Sign On (SAML or OAuth) initiated invites.
• Maps’ legends now display null values as null. Previously, a blank space was left in their place.
• Workbook elements’ inline toolbars now adhere to editor-defined theming.
• Workbook editors can now customize individual list-based (include/exclude) control elements to include any of the following options: Show null option, Show search box, and Show histogram.
• Workbook editors can now customize individual true/false control elements with the following options: Allow multiple selection, and Show histogram.
• You can now move workbook page sections between pages, using their menus’ Move to page submenu.
• Number columns in visualizations are now sorted descending by default, rather than ascending.
• [Beta] We are currently conducting beta testing of guest user accounts. Guest user accounts are password authenticated and allow you to enforce strictly limited access to your organization. Please contact your Sigma Sales Representative if you are interested in participating in this beta.