1) Main Features

1)a) Enrich data

We’ve enhanced the user experience for creating data enrichments in sheets. With a single button, users can now access multiple enrichment options, making it easier to manipulate data in various ways:

Formula: Classic formula editor, powered by AI.
Lookup Column: Easily link data from different sources using lookup functionality.
Manual input: Easily define mappings manually or bu uploading a CSV.
Python Column: Incorporate custom Python logic directly into your sheet.
Generative AI: Use AI to enrich data automatically.

1)b) Data Preparation (first version)

A new and improved data subsection within the datasource section provides detailed insights and stats about your dataset, both globally and at the column level. Users can now perform simple transformations directly from the datasource section for more streamlined workflows.

General data overview:

Column overview, when clicking on column header:

1)c) Windows functions

KAWA now supports WINDOW functions directly within the formula editor. Leverage advanced formulas like Sliding Average and Cumulative Sums for sophisticated data analysis and insights.

1)d) Dry run mode

Introducing Dry Run Mode: This feature allows you to disable automatic computations across all views. Ideal for users working with computation-intensive views, it lets you apply groups of changes and preview results before executing the final computations.

1)e) Knowledge

Introducing the Knowledge section in KAWA. This new feature enables users to connect and integrate unstructured data with KAWA, offering enhanced capabilities for data-driven decision-making. This functionality requires a connection to both an OCR (Optical Character Recognition) and a completion API.

2) Bug fixes

Impossible to show chart when sheet is shared with teams
Formula editor context switch loses the formula
Nested call expressions do not work
ABS DESC/ASC not available in pivot
Script - share dialog is broken
Expression-editor - error with AI formula generation
Problem When adding lookup columns and picking multiple columns to add
Cannot insert tokens in the first position
Formula editor - Clear error message as soon as generation works
Bug when using Blockly and new dep system
When a Python ETL fails, the error status does not propagate to the sheet
Chart - resize issue
In linked column, make configuration viewable even if not editable
Automations - hide action buttons in CP