• 🎊 New features
• 1. Main new features
• 1.a) Multi-aggregation in pivot tables
• 1.b) Linked views in pivot tables
• 1.c) Enhanced Incremental Data Import for SQL Datasources
• 1.d) Formula: Switch case function
• 2. Improvements
• 2.a) Enhanced editing for linked columns
• 2.b) Improved formula data type handling
• 2.c) Default grid order setting for import
• 2.d) Override data source model with sheet model
• 2.e) Resizable pivot and chart panels

🎊 New features

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

1. Main new features

1.a) Multi-aggregation in pivot tables

We've added a handy new feature – multi-aggregation for your pivot tables. Here's how to use it:

💡Steps:

1. In your pivot view, simply click on the "Pivot configuration" button.
2. From the dropdown list of aggregations, choose "Multi-aggregation."

1. A window will appear with a preview table below for your reference.
2. You can now select aggregations for rows, columns, axes, and the total in your pivot table.

1.b) Linked views in pivot tables

You now have the ability to link your pivot view with any other sheet, based on row and column values. Here's how it works:

1. In the pivot configuration, simply click the three-dot icon next to a row or column field and select "Link View." A dialog will pop up, displaying all the values for that field. Choose the value you want to link.

2. On the right side of the dialog, click "Add View" to associate the selected value with any views from your sheet. You can add as many views as needed.
3. Finally, click the "Apply" button.

Example: To illustrate, we've established a connection between the pivot view and the Grid View for the value "Argentina.”

Result: If you double-click on the price value (screenshot below) where the country is set to 'Argentina' (35.85), a lower view will appear, displaying the Grid filtered specifically for records where the country is 'Argentina.'

1.c) Enhanced Incremental Data Import for SQL Datasources

This version brings a x2 speedup in all ETLs.

This improved feature for SQL datasources allows you to efficiently import data incrementally. With this update, you can now specify an SQL query to seamlessly import incremental data into your datasource. Here's what you need to know:

1. No More Key Selection: You no longer need to select a key to create a datasource with incremental updates. The new behavior ensures that new data is automatically appended to your existing dataset, whether or not the records already exist.
2. Main SQL request: The main SQL request is executed only during the initial creation of the datasource or when manually triggered. It performs a reset operation before inserting the retrieved data replacing the entire existing dataset with the new data.
3. Append Query: Subsequent to the initial setup, the Append Query request is triggered with each run, efficiently appending new data to the existing dataset. This ensures that your datasource remains up-to-date without unnecessary data duplication or complex configurations.

Example: Imagine you want to import your complete order history from the last five years initially, and then, on a daily basis, add only the new orders. Here's how you can achieve this:

Steps:

1. When creating a SQL datasource, navigate to the "Feed type" section and select "incremental feed."
2. Input your main SQL request:
Copy

SELECT * FROM public.orders

3. Specify the Append Query to capture new data:
Copy

SELECT * FROM public.orders WHERE order_date >= current_date - 5

1.d) Formula: Switch case function

In Blockly mode, you can now implement conditional logic in your data workflows. This functionality allows you to easily define different actions based on specific conditions.

Example:

2. Improvements

2.a) Enhanced editing for linked columns

Now, when you move a column from a linked view to the main view (provided you have the necessary permissions), you can edit it within a dedicated "Edit mode" view. This view displays only the relevant columns along with those used for the link.

Please note that any modifications made, such as filters and aggregations, will be applied only upon clicking the "Save" button.

2.b) Improved formula data type handling

You can adjust data types within your formulas to adapt and refine your calculations. However, if another column is created based on your formula, you won’t be able to change it anymore.

• In Grid view, click on the “Formula” button

• Create formula with numeric values
• On the new column created for your formula > edit formula
• Choose any other data type

2.c) Default grid order setting for import

The order in which you import your data will determine the initial arrangement of your data in the Grid. Any subsequent changes to the column order within the Grid won't affect this default order.

2.d) Override data source model with sheet model

With data modeler permissions, you now have the ability to directly modify indicator names, aggregations, attributes, and all model configurations within the sheet model. This is a interesting improvement, as previously, you were required to make these changes within the data source model.

2.e) Resizable pivot and chart panels

Resize your Pivot and Chart panels to easily adapt it to the length of your columns name.