• 🎊 New features
• 1. Automation features
• 2. Sheet features
• a. Grids - multiple groups on the same column
• b. Charts - Line chart: Be able to define the line size
• c. Charts - Horizontal zoom: Improvement
• d. New advanced computation feature: Configuration of indicators
• e. New presets in date time filters
• 3. Data features
• a. Database and table selection
• 4. Technical

🎊 New features

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

1. Automation features

When creating or editing your automation, you can now:

• Customise both the email subject and body.
• Add external mails as recipients. This means that you can send automation emails to people who do not have an account in KAWA.
• Add an option to choose wether or not to send the email when the view is empty. This is useful to configure an Alert: Send an email as soon as I have at least one row in my view.
• Add an option to choose wether or not to attach a CSV extract of the view.

New placeholders can be used in both the subject and in the body:

Here is the list of currently available placeholders that you can use:

• ${automationName}: Will be replaced by the name of your automation
• ${date}: Will be replaced with the date of the automation execution.

(The format is: Dec 22 2022)

• ${time}: Will be replaced by the time of execution
• ${numberOfRows}: Will be replaced by the number of rows in the view

Note: ${date} and ${time} will be in the timezone that was selected during the scheduling step.

2. Sheet features

a. Grids - multiple groups on the same column

In KAWA grid views, you can now use multiple times the same column in the grouping configuration. An interesting use case is to compare for each month the performance of this year and last year. Let’s assume we have a table containing a date column and a performance column. Here are the steps to perform such comparison:

💡 Steps

1. In groupings, add the Date column and select the time segmentation “MONTH”
2. Add another time the Date column and select the time segmentation “YEAR”
3. Result: For each Month, you can see the performance of this year and last year.

Example:

b. Charts - Line chart: Be able to define the line size

It’s now possible to select the line width in line charts.

c. Charts - Horizontal zoom: Improvement

1. Pre-requisite: the data source should have a date time column as key.
2. The chart should be grouped by this date time column.
3. The horizontal zoom has been improved and can be done through three different ways:
1. By using the date picker at the top left.
2. By using the zoom bar at the bottom of the chart.
3. By Selecting horizontally the range with the mouse cursor.

d. New advanced computation feature: Configuration of indicators

By clicking on the “cog” icon next to indicators, you can now Fix values for primary keys.

Example:

Consider the following grid view:

(You can import the sample data from google sheet: https://docs.google.com/spreadsheets/d/1KbL3Cv3vqeODpxWK9dPgdyYPlRLY6MEWs5XeLRq9QGk)

We have two fields:

• A stock symbol (which is the primary key of the datasource)
• A Price

What if we want to display in a new field the ratio of the price of a stock with the price of the NASDAQ ?

💡 Steps

Step 1: create a new formula as below:

Step 2: Click on the cog icon for the denominator and set the STOCK to NASDAQ

Step 3: To have a result in %:

Here is the final result:

With this feature, you can fix whatever key you wish to: Dates, Date times, texts, numbers to do powerful comparisons.

e. New presets in date time filters

You can now filter date time columns with the same options as you would a date filter.

3. Data features

a. Database and table selection

In the data source section, when importing a new table from an external system, KAWA automatically detects the databases and tables and you can select them in the dropdown as below.

4. Technical

For on premise setups, a new environment variable has been created:

KAWA_NB_DOWN_SAMPLING_POINTS

(It defaults to 100)

It defines the maximum number of points per series when performing automatic down sampling on time series.