January 2024: Update Data Tables API Endpoint, Workbooks Enhancements

API

Update Data Tables API Endpoint

We have introduced a new API endpoint that allows you to update a data table using an existing file.

Workbooks

Customizable Table Styles (Beta)

Customize style and format settings for table, pivot table, and input table elements.

Calculation Columns in Input Tables

Calculation columns allow you to use formulas to populate input table column data. To utilize a calculation column, open the element menu, select Add new column > Calculation, then enter a formula in the formula bar.

Duplicate Input Table Columns

Duplicate columns in input table elements the same way you can in table and pivot table elements. Click the caret () in the column header to open the column menu, then select Duplicate column.

Highlight Rows with {value}

The highlight functionality allows you to quickly identify rows with a common value. Right-click any cell containing the value you want to highlight, then click Highlight rows with {value}. Sigma automatically creates a conditional formatting rule that can be modified or deleted in the Element format panel.

Fixes

  • We are now correctly showing results of the target variable of a Goal seek with Output All Results enabled
  • After merging between models, we are now retaining the filtering on the list of model differences
  • Indirect array references are no longer getting incorrectly merged into variables