• 🎊 New features
• 1. Workspace features
• a. Workspace : create, rename.
• b. Workspace permissions
• 2. Data features
• a. Data providers
• b. Data source : UX improvement
• 3. Sheet features
• a. Data formatting
• b. Column management
• c. Sheet information
• d. Automations
• e. Transformations
• 4. Charts features

🎊 New features

1. Workspace features

a. Workspace : create, rename.

• Create new workspace
• Open to the workspace selector at the bottom left and click on Create new workspace.

• Input a name for your workspace and click on Create button.
• Rename workspace
• Click on the setting icon at the bottom left.
• In General section, you can rename the workspace and click on Apply button. Only the workspace owner can rename the workspace.

b. Workspace permissions

You can now manage the permissions of the members of your workspace. To do so, click on the setting icon at the bottom left to open the workspace setting dialog and go to the Permissions section. For each member and each permission type, you can activate or not the concerned permission by checking the associated box.

The list of permissions is the following:

• Data management
• Sheet management
• Dashboard management
• Shared directories management

2. Data features

a. Data providers

In KAWA, any member with data management permissions can now create connections to external systems directly within the application. These connections are named data providers.

The available connections are:

• MongoDB
• JDBC
• PostgreSQL
• Microsoft SQL Server

💡 Steps

1. In the data source section, click on + Data source button and select Connect to an external system
2. In the DATA IMPORT area, a dropdown allows to select the data provider to use to import the data. If no provider has been created yet, the dropdown is empty.
3. In order to create a new data provider, click on the blue + button next to the dropdown. A dialog opens allowing to configure and test your connection thanks to the Test connection button at the bottom left.
4. Once you connection is configured and successful, click on Create. The newly created data provider is added in the dropdown. You can still edit it by clicking on the edit icon next to the dropdown.

b. Data source : UX improvement

The creation and edition workflow has been improved.

3. Sheet features

a. Data formatting

In KAWA, you can now configure the format of your data.

1. In grid views, open the field menu and click on customize field.

2. Customize your data format and click on apply.
3. If the type of the aggregation is different from the type of your field (example: Text field with aggregation COUNT), you can also configure its format by selecting the type of the aggregation in the dropdown list next to the field name (in our example, it would be Integer).

b. Column management

You can now rename or move to trash the computed columns created in a sheet. Indicator columns (coming from data sources) can’t be renamed or removed.

Computed columns are:

• Formulas
• Mapping columns
• Columns from linked views

💡 Steps

1. In a Sheet, open the sheet menu and select Manage columns.

2. Rename column: Click on the rename icon that appears on hover next to the column name to rename it.
3. Move to trash: Click on the trash icon. The concerned column will be moved to the Trash section. The columns that are moved to trash will be removed from all the column lists of the sheet (Filter columns, chart and pivot table columns, formula editor columns, dashboards…)

4. Restore columns: you can always restore a column by going to the trash section and clicking on the restore icon.

5. Click on the Apply button to apply the changes.

c. Sheet information

In KAWA sheets, you can now have information about the data source refresh status and last refresh.

To do so, open the sheet menu and select Sheet info. A dialog with these information opens.

For more details about a specific data source, you can click on the data source name and you will be redirected to the data source page.

d. Automations

In KAWA sheets, you can now Create automations in order to get scheduled reports by Email. An email with an attached CSV will be received by the selected recipients.

💡 Steps

1. In a Sheet, click on the robot icon next to the sheet name.
2. Select your automation type or start with a template. Currently only Scheduled automations and Daily summary template are available.
3. Schedule your automation
4. Select the recipients that will received the email.
5. Configure the grid that will be sent as a CSV attached to the email.

e. Transformations

In KAWA sheets, from any grid you can create a new data source that takes into account all the grid configurations such as filters, grouping, new formulas, aggregations…

Only members with data management rights can use this feature.

💡 Steps

1. In a grid view, open the view menu and select Transform into a data source.

2. Give a name to the data source and click on Create button.
3. The data source has been created in the data source section and you can navigate to it by clicking on Go to data source.

4. Charts features

Charts have been improved especially for time series.

• Automatic down sampling: always displays 100 points max for each group.
• WARNING: you need to use AVG or MEDIAN aggregation to have meaningful values
• X-axis improvement and custom x-axis configurations.
• Max number of labels.
• Labels rotation.
• When Show data zoom is enabled, the user can:
• select a custom range directly in the chart.
• Use horizontal zoom in the chart.
• The user can show the grid lines.