BI SQL Editor Aggregation
auto_awesome What this module does
AI-generated from the code · Odoo 12.0Lets you choose how numeric columns of a BI SQL view are aggregated (Sum, Average, Minimum or Maximum) instead of always summing them. The choice is applied automatically to the generated model fields.
This module extends the BI SQL Editor so that numeric columns of a SQL view can be aggregated the way you want when Odoo groups records.
- On each field line of a BI SQL view, a new "Group Operator" option appears next to the field type. It is only visible for integer and float fields.
- You can pick Sum, Average, Minimum or Maximum. By default Odoo sums values; this setting changes that behaviour for the selected column.
- When the model fields are created or refreshed, the chosen operator is copied onto the corresponding field of the generated model, so grouping, pivot and list views use it.
- The module touches
bi.sql.view,bi.sql.view.fieldandir.model.fields, and adds the option to the existing BI SQL view form.
It does not add new menus or reports; it only enriches the existing BI SQL Editor screens with an extra aggregation choice for numeric columns.
Depends on
Models and fields (2)
- bi.sql.view · extends an existing model
- bi.sql.view.field · extends an existing modelgroup_operator (Group Operator)
Text generated by AI (DeepSeek) from reading the Odoo 12.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 1 confirmed, 8 with no information of 9 versions.
Sources · Odoo 12.0
Confirmed on 2026-11-03 in branch 12.0 of OCA/reporting-engine.
terminal Installation and usage
No verified informationInstallation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.