• 🎊 New features
• 1. Main new features
• 1.a) Puzzle like Formula Editor (Blockly)
• 1.b) Conditional formatting
• 1.c) Python powered automations
• 2. Improvements
• 2.a) Multiple aggregation in pivot tables
• 2.b) Configurable colour Palette
• 2.c) View settings
• i. Auto hide empty fields
• ii. Compute overall aggregation
• 2.d) Improved Python client

🎊 New features

This release brings a lot of bug fixes and UI improvements.

1. Main new features

1.a) Puzzle like Formula Editor (Blockly)

When you create or edit a formula, you now have two different modes. Choose Blockly to open the new puzzle like editor:

You can build your formulas by composing blocks:

• The left toolbar has the same function as the text input mode
• The top toolbar gives access to value blocks (such as constant numbers or texts), logical operator (OR, AND), math expressions (+, - , …. ), comparaison operators ( =, > , < … ).

1.b) Conditional formatting

To configure conditional formatting on Grids, click on the Color button in the top toolbar.

To create a new rule, click on +Rule

For your new rule,

• set a name
• set a colour

You can then aadd conditions that will decide wether or not to apply the selected colours.

For example, the following condition will apply the selected color if profit is greater than 100 AND sales is greater than 400.

Each rule can be applied either to GOUPED values or to ROW values.

The conditions can be combined together with OR or AND operators.

The last step is to configure which fields to colour when the conditions are verified.

1.c) Python powered automations

V1.17.X introduces the possibility to configure one runner per workspace.

Refer to this document for additional details about setting up python support:

Python automations and script runners

In your workspace settings, you can see wether or not Python support is enabled for this particular workspace:

When Python is enabled, you can access the SCRIPT section in automation configuration:

(You need the Automation permission Flag to access automation configuration)

⚠️ Automations created by users who lose the Automation Permission Flag will no longer run.

2. Improvements

2.a) Multiple aggregation in pivot tables

The record aggregation will be applied to the values inside the Pivot. The total aggregation to the computed totals.

Here for example, the Totals will be the AVERAGE of the SUMS.

2.b) Configurable colour Palette

You can configure the colour palette that will be used in charts and conditional formatting for each of your workspaces.

In this screen, you can manage the colours of your palette, by adding, removing and reordering them.

2.c) View settings

For Grid views, some new options were introduced. To access them, either right-click on a grid or use the view menu:

i. Auto hide empty fields

When turned on, this feature will automatically hide empty fields in grid views.

ii. Compute overall aggregation

When turned off (it will be off by default when the computation takes place on an external warehouse), the overall aggregations will not computed.

In this example, all the overall aggregations below the grid are left empty.

2.d) Improved Python client

cf this doc for additional features:

Python API for data analytics