• 🎊 New features
• 1. Main new features
• a. Chart&Pivot: Show as feature
• b. Link views
• c. Filters: improvement
• 2. Other new features
• a. Create a chart from a grid
• b. Charts - multiple groups on the same column
• c. Automations: data permissions applied according to recipients rights
• d. Charts: download image
• e. Field information

🎊 New features

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

1. Main new features

a. Chart&Pivot: Show as feature

When creating a chart or a pivot table, KAWA provides advanced aggregations functions and different ways of showing the results (% of Total, % of Previous value, cumulated… ). This allows you to summarize data values in that column based on the values in other columns. Using this you will be able to do some powerful calculations on a chart like cumulative total of sales over years or calculate the difference in sales from the previous year…

b. Link views

In KAWA, it’s now possible to create a link from any column, without setting an attribute.

💡 Steps:

• On hover of any column header, a link icon appears.
• Click on the link icon. A dialog opens to configure the link.
• Select the sheet you want to link. KAWA automatically detects all the sheets from any datasource containing columns with similar values and propose them in the Suggestions section.
• Select the view to link, and configure the link. Again, KAWA automatically suggests the smartest possible links, but you can also change it manually.
• Click on the Apply button. The linked view appears at the bottom.

c. Filters: improvement

KAWA filters have been improved, to empower users with high level filtering capacities. In KAWA, it’s now possible to:

• Filter on any group level.

• Filter on any aggregation, independently from the field’s one.

-UX improvements have also been performed, to make the feature easier to understand.

2. Other new features

a. Create a chart from a grid

It is now possible to create a chart view from any grid view. 💡 Steps:

• Open the column menu of the serie you want to chart.
• Click on Create chart option.
• A chart view is created following these specifications:
• Applied filters, sorts and tops should be kept.
• The serie’s aggregation is the one of the field if numeric, otherwise COUNT (for text) or SUM (for int and decimal) or MAX (for date and datetime).
• Grouping:
• if no grouping → indicator chart
• if 1 grouping level → bar chart if text or int/ line chart if date or datetime
• if more than 2 groups → stacked bar chart if text or int/ line chart if date or datetime
• View name: field name by group1,group2

b. Charts - multiple groups on the same column

In KAWA chart 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 the group by section, 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:

c. Automations: data permissions applied according to recipients rights

In KAWA, automations can now be executed according to the recipients rights and not the sender rights. This means that an automation can be set for users with different rights (for example, in the same sheet user A can only see the clients A1, A2, A3 and user B can only see the clients B1, B2 and B3), and each user will receive the result that concerns only their own data (user A and B will receive different results based on their rights).

To do so, when creating or editing an automation, you just need to select Automation rights = “Owned by the recipients” in the “Action to run” step.

⚠️ The screen to setup data right management by user is still under construction. Managing data rights can be done using the KAWA python library. If needed, please contact the support team directly

d. Charts: download image

It is now possible to download an image of any chart view (in JPEG format). To do so, from the grid view menu, select Download chart image option.

e. Field information

Field information option has been added in the field menu. It informs the user about the origin of the field. Later statistics about the field data distribution will be added.