• 🎊 New features
• 1. Main features
• 1.a) Show totals on Stacked bars
• 1.b) Export CSV of Charts and Pivots
• 1.c) Moving Calculations in Pivots and Charts
• 1.d) Duplicate a formula
• 1.e) Capability to fix date primary keys when performing joins
• 2. Improvements
• 2.a) New UI for linked columns and linking sheets
• 2.b) Show labels inside or outside for Pie charts
• 2.c) Add formula to convert from EXCEL date to DATE (NUMBER_TO_DATE)
• 2.d) Blockly : Support for the “&” character
• 2.e) Accelerate ETLs

🎊 New features

1. Main features

1.a) Show totals on Stacked bars

In your chart view: Configure chart > Design > Select “Show totals”. 👇

1.b) Export CSV of Charts and Pivots

In your Chart or Pivot view, click on the view’s three-dots menu and select “Download CSV”. 👇

1.c) Moving Calculations in Pivots and Charts

In your pivot and chart view:

• Open the “Configure” panel and click on the “Show As” button.

• Select “Moving Calculations” in the list.

Follow the example below.👇

1.d) Duplicate a formula

In your Grid view, click on the three-dots menu of your formula column and select “Duplicate Formula”. 👇

1.e) Capability to fix date primary keys when performing joins

When performing joins, if a date column serves as one of the keys in the target data source, you can now fix the value of the column to a specific date by choosing the "Fixed Value" tab.

The fixed value can be:

• A preset selection: Last Date, Today, Yesterday
• A calendar date: e.g., "12/03/2023"
• A rolling date: e.g., -2 Months (indicating 2 months ago)

2. Improvements

2.a) New UI for linked columns and linking sheets

A GIF will appear the first time you edit a Lookup Formula, offering step-by-step guidance.👇

Additionally, an instructional image will be displayed when dragging and dropping a column into the main view. It will indicate how to edit a Lookup Formula in the new pop-up.👇

2.b) Show labels inside or outside for Pie charts

In your chart view: Configure chart > Design > Select “Labels outside”. 👇

2.c) Add formula to convert from EXCEL date to DATE (NUMBER_TO_DATE)

The formula "NUMBER_TO_DATE" is used to convert an Excel date into a standard date format. It is now available in the list of function within your formula editor. It supports the following formats: Number of days since epoch (UNIX EPOCH).

2.d) Blockly : Support for the “&” character

The character “&” is now supported in blockly formulas.👇

2.e) Accelerate ETLs

In this version, enhancements have been implemented to optimize the efficiency of our ETL processes, resulting in up to x2 speed and performance.