Tables provide visual grouping by a single column by default. However, a more functional tool is required for in-depth data analysis. When using advanced grouping, you can perform calculations on columns.

For example: there is a table with expenses (Category, Amount, Date). We want to calculate the sum of operations for each category for each year. To do this, we need to group records by Date and Category, while rounding the Date of each record to the year, and summing the values in the Amount column.

For Date, we used an operation from system variables. This way, all records within the same year and category will fall into the same group.

Advanced grouping is available in flows, which can be connected as a data source for a chart. This makes it easy to build grouping chains. For example, first calculate the sum for a month, and then calculate the average values by months for a year.

📌 Next step: Flows →

📌 Also useful: Commands | System Variables