In QuintaDB, it is possible to generate a report by quantity or sum when grouping data.
For example, we have a table with Sales, where there is information about who made a sale, when and for what amount.
If you open the form for grouping, you can see new options:
- Only Group Name and Count
- Total per Group
When grouping our table by the "Manager" column using the new options, we will get the following result:
The grouping result shows how many operations and for what amount each manager conducted. The result can be sorted by quantity or sum, and also saved in the Report.
The report can be used not only as a widget, a portal element, but also for generating diagrams. Below are two charts that show the number and amount of transactions per manager.
We hope that the new options will be useful to you!