Technical Specifications & Compatibility
Technical Module Name
Supported Odoo Versions
v19.0
License
Odoo
Deployment Support
Odoo OnlineOdoo.shOn Premise
Lines of Code
755 lines (Python / XML / JS)
Overview & Description
Odoo 19 Odoo 20 Community and Enterprise OPL-1 Version 19.0.1.0.0 Dashboard Builder Build your own spreadsheet dashboards without Enterprise. Describe the tiles you want, press Build, and get a real Odoo dashboard rendered by Odoo's own Dashboards app. KPI scorecards, bar, line, pie and map charts, pivot tables, and global filters wired into every tile automatically. No code and no second renderer. Module Overview What this module solves. Community can view dashboards but not make them Odoo Community opens spreadsheet dashboards and ships a dozen of them. It cannot create one, because the whole editing experience lives in the Enterprise spreadsheet-edition modules. There is no supported way to add a dashboard of your own. A dashboard is a declarative document Underneath, a dashboard is JSON on an ordinary record, and the parts that matter are declarative: a model, a measure, a grouping, a domain. So describe the tiles in a normal Odoo form and let the module compile them into that document. It writes the format Odoo already reads. The output is the same kind of dashboard record a Sales dashboard is, so it inherits favourites, sections, access groups, search, click-through to records and the mobile layout for free. There is no second renderer to maintain or style. Key Features Everything included in the module. Six Tile Types KPI scorecard: one number, with the change since last period Bar chart, grouped one way Line chart, usually over a date Pie chart Map, coloured by measure Pivot table with rows and columns, on its own sheet Describing A Tile Pick any model in the database, with no view to prepare first Pick a measure, or leave it empty to count records Group by any stored field; dates take an interval Pivot tiles group two ways at once, rows and columns A domain per tile, so one tile can narrow while another does not Width in plain terms: a quarter, a half, or the full row Global Filters A period filter with ten presets Record filters by salesperson, category, country, anything One filter drives every tile at once, across different models The field each filter drives is worked out per tile Override the date field per tile when the guess is wrong Ignore a filter on a chosen tile, for a total beside a breakdown KPI Comparison The change since last period, as an arrow and a percentage Computed as the same pivot with the period offset by one The technique Odoo's own shipped dashboards use Green up and red down, matching those dashboards Switched off automatically when there is no period to offset Switchable off per tile Building And Rebuilding One Build button; the output is a real dashboard record Rebuilding keeps the same record, so bookmarks and links survive Editing a definition marks it stale, with a banner and a Rebuild button Section, access groups and companies passed to the dashboard Deleting a builder takes its dashboard with it, leaving no orphan Every build logged in the chatter Guard Rails A chart without a grouping is refused at save A malformed domain is refused at save A field belonging to another model is refused A record filter without a model is refused Building with no tiles is refused Only dashboard managers can build, using core's own group Business Benefits Why it matters. Dashboards Without Enterprise Your own KPI boards on Odoo Community, with no subscription and no third-party analytics service in the middle. Built By The Business A tile is a model, a measure and a grouping chosen in a form. Nobody writes XML, JSON or a view to add a chart. Filters That Wire Themselves Matching one filter to a field on every tile by hand is the part of the Enterprise editor that makes people give up. Here it is derived. Nothing New To Learn The result opens in the Dashboards app your users already know, with favourites, search and click-through intact. Screenshots A tour of the interface. Builder Form Screenshot Placeholder The dashboard definition, its tiles and its filters in one form. Describing A Tile Screenshot Placeholder Type, model, measure, grouping, domain, width and colour. The Generated Dashboard Screenshot Placeholder Scorecards, charts and the filter bar in Odoo's Dashboards app. Filters Tab Screenshot Placeholder A period filter and a record filter driving every tile at once. Workflow From an empty form to a live dashboard. Create a builder. Dashboards, then Configuration, then Dashboard Builder. Name it and choose the section it should appear under. Add the tiles. For each one pick a type, a model, a measure or nothing for a count, and what to group by. Set a domain if that tile should be narrower. Add the filters. A period filter with a default preset, and record filters for the things people slice by. Each one wires itself into every tile. Press Build. The definition is compiled into a real dashboard record, and the build is logged in the chatter. Open Dashboard. It appears in the Dashboards app under its section, rendered by Odoo's own spreadsheet engine. Change and rebuild. Editing marks the definition stale rather than silently republishing. Press Rebuild when you are ready, and the dashboard keeps its identity. Tile Types And Their Defaults Tile Grouping Default width KPI None required; one number, optionally compared Quarter Bar chart One grouping, required Half Line chart One grouping, usually a date Half Pie chart One grouping, required Half Map One grouping, coloured by measure Half Pivot table Rows and columns, on its own sheet Full Configuration Where it lives, and what you can set. Where To Find It Menu Purpose Dashboards, Configuration, Dashboard Builder Create and rebuild dashboard definitions Dashboards, the app itself Where the built dashboards appear, under their section The builder sits inside the Dashboards app's own Configuration, next to the dashboards and sections it edits, rather than adding a separate top-level app away from the thing it builds. Filter Options Filter What it drives Period Each tile model's date field, chosen automatically or set by you Record The first field on each tile pointing at the chosen model Ten period presets: Last 7 days, Last 30 days, Last 90 days, Last 12 months, Month to date, Quarter to date, Year to date, This month, This quarter, This year. Access Who Can do Dashboard managers Create, edit and build dashboard definitions Everybody else See the built dashboards, subject to the dashboard's own access groups Multi-company A record rule keeps builders to the companies they belong to No new group is created. Building uses the dashboard manager group that already owns dashboards in core, because inventing a second one would mean two different answers to the question of who may publish a dashboard. Technical Details Models, dependencies and design. Module Information Technical Name spreadsheet_dashboard_builder_aura Version 19.0.1.0.0 Category Productivity / Dashboard License OPL-1 Dependencies spreadsheet_dashboard, mail External Libraries None beyond a standard Odoo installation External Service None. No data leaves your Odoo instance. Models Added Three, and no new security group Automated Tests 50 tests, including a browser tour Models Model Description spreadsheet.dashboard.builder The definition, with chatter and the Build action spreadsheet.dashboard.builder.tile One tile: type, model, measure, grouping, domain, width spreadsheet.dashboard.builder.filter A period or record filter, and how it finds its fields Design Notes It emits, it does not render. The compiler writes the workbook Odoo already knows how to draw, so there is no second viewer to keep in step with core. Filters derive their field matching. A period finds each model's date, a record filter finds the first link to its model, and a filter with nothing to attach to simply leaves that tile alone rather than inventing a join. Two sheets, on purpose. Figures are absolutely positioned so scorecards and charts share the dashboard sheet, while their formulas live on a data sheet; a pivot spills a whole table, so it gets a sheet each. Filter ids are stable across rebuilds. A dashboard never detaches from its own filters when it is rebuilt. Tested through Odoo's own reader. One test runs the compiled output through the exact serialization path the dashboard viewer uses, and a browser tour opens the result in the real Dashboards app to confirm the scorecard, the chart and the filter actually draw. Every other test inspects a dictionary; only the browser can say whether the dictionary is a dashboard. Compatibility Where the module runs. Item Supported Odoo Version 19.0 Current Hosting Odoo.sh, On-Premise and any self-managed deployment Models Supported Any non-transient model in the database Multi-Company Yes, with a record rule on builders and companies passed to the dashboard Multi-Language Yes, tile titles and filter labels are translatable Mobile and Tablet Yes, the built dashboard uses the standard mobile layout Access Groups Yes, the dashboard's own groups are honoured by core Supported Editions Both editions, one code base. Community Edition Supported The edition this module exists for. It adds the ability to create dashboards that Community can already display. Enterprise Edition Supported Runs on Enterprise as a faster way to lay out a repeatable dashboard, alongside the full spreadsheet editor. Odoo.sh Supported No extra Python packages to install, so it deploys with no change to your build configuration. Installation Four steps to your first dashboard. Copy the module. Place the spreadsheet_dashboard_builder_aura folder in your Odoo addons path, then update the apps list from developer mode. Install Dashboard Builder. The Dashboards module is installed with it as a dependency. Open the builder. Dashboards, then Configuration, then Dashboard Builder, then New. Give it a name and a section. Add tiles and build. Describe a couple of tiles, add a period filter, press Build, then Open Dashboard. Nothing existing is modified on install: the module adds three models, one menu under the Dashboards app and no new security group. Dashboards you already have are untouched. Frequently Asked Questions The questions asked most often. No, and it does not pretend to be. It builds dashboards from aggregates: count, sum or average of a field, grouped one or two ways. There is no free-form cell entry, no formula bar and no chart styling beyond a title and a background colour. Those are what Odoo Enterprise sells. Yes, an ordinary dashboard record of exactly the kind the shipped Sales and Inventory dashboards are. It opens in the Dashboards app, rendered by Odoo's own spreadsheet engine, and inherits favourites, sections, search, access groups, click-through to records and the mobile layout without this module implementing any of them. Each filter works out which field it drives on each tile's model. A period filter finds that model's date field; a record filter finds the first field pointing at its model. Where a tile has nothing suitable the filter simply leaves it alone rather than inventing a join. You can override the date field per tile, or tell a tile to ignore a filter entirely. The same dashboard record is rewritten, so bookmarks and menu links survive and the filters keep their identity. Editing a definition marks it stale and shows a Rebuild button rather than republishing silently while somebody is halfway through describing a tile. Edit the builder, not the dashboard. The module writes the dashboard but does not read it back, so the next Build overwrites whatever is in there. Deleting a builder removes its dashboard too, leaving no orphan nobody can maintain; deleting the dashboard by hand simply lets the builder make a new one. It is the same pivot with the period offset by one, which is how Odoo's own sales dashboard produces its comparison. Green for up and red for down, to match. With no period filter there is nothing to offset, so the comparison switches itself off rather than showing a permanent zero per cent. Any non-transient model in the database, including those added by other modules and your own customisations. No view has to be prepared first, and different tiles on one dashboard can come from different models. Dashboard managers, using the group core already defines for people who own dashboards. No new group is added, because two groups would mean two answers to the same question. Who can then see a built dashboard is governed by that dashboard's own access groups, as with any other. Changelog Release history. Version 19.0.1.0.0 Initial Release Six tile types: KPI, bar, line, pie, map and pivot table Any non-transient model, any stored field, measure or count Date groupings by day, week, month, quarter or year Two-way grouping on pivot tiles, rows and columns A domain, a width and a background colour per tile Period filters with ten presets, and record filters on any model Field matching derived per tile, overridable and skippable KPI comparison as the same pivot offset by one period Comparison disabled automatically when no period filter exists One-button Build producing a real dashboard record Stale-definition banner and explicit Rebuild Stable filter ids and a preserved dashboard id across rebuilds Validation of groupings, domains, fields, filters and empty builds Three models, one menu, no new security group 50 tests, including a browser tour of the rendered dashboard Support We answer, and we keep our modules current. Email odooaura@gmail.com Website www.auraodoo.tech YouTube youtube.com/@Auraodoo Free support for bug fixes on the Odoo version you downloaded. Customisation and installation help available on request. Aura Odoo Tech Odoo modules built to be understood, not just installed. Odoo 19 OPL-1 spreadsheet_dashboard_builder_aura www.auraodoo.tech | odooaura@gmail.com | youtube.com/@Auraodoo
Key Capabilities & Features
- KPI scorecard: one number, with the change since last period
- Bar chart, grouped one way
- Line chart, usually over a date
- Pie chart
- Map, coloured by measure
- Pivot table with rows and columns, on its own sheet
- Pick any model in the database, with no view to prepare first
- Pick a measure, or leave it empty to count records
- Group by any stored field; dates take an interval
- Pivot tiles group two ways at once, rows and columns
- A domain per tile, so one tile can narrow while another does not
- Width in plain terms: a quarter, a half, or the full row
- A period filter with ten presets
- Record filters by salesperson, category, country, anything
- One filter drives every tile at once, across different models
- The field each filter drives is worked out per tile
- Override the date field per tile when the guess is wrong
- Ignore a filter on a chosen tile, for a total beside a breakdown
- The change since last period, as an arrow and a percentage
- Computed as the same pivot with the period offset by one
- The technique Odoo's own shipped dashboards use
- Green up and red down, matching those dashboards
- Switched off automatically when there is no period to offset
- Switchable off per tile
- One Build button; the output is a real dashboard record
- Rebuilding keeps the same record, so bookmarks and links survive
- Editing a definition marks it stale, with a banner and a Rebuild button
- Section, access groups and companies passed to the dashboard
- Deleting a builder takes its dashboard with it, leaving no orphan
- Every build logged in the chatter
- A chart without a grouping is refused at save
- A malformed domain is refused at save
- A field belonging to another model is refused
- A record filter without a model is refused
- Building with no tiles is refused
- Only dashboard managers can build, using core's own group
- Create a builder. Dashboards, then Configuration, then Dashboard Builder. Name it and choose the section it should appear under.
- Add the tiles. For each one pick a type, a model, a measure or nothing for a count, and what to group by. Set a domain if that tile should be narrower.
- Add the filters. A period filter with a default preset, and record filters for the things people slice by. Each one wires itself into every tile.
- Press Build. The definition is compiled into a real dashboard record, and the build is logged in the chatter.
- Open Dashboard. It appears in the Dashboards app under its section, rendered by Odoo's own spreadsheet engine.
- Change and rebuild. Editing marks the definition stale rather than silently republishing. Press Rebuild when you are ready, and the dashboard keeps its identity.
- It emits, it does not render. The compiler writes the workbook Odoo already knows how to draw, so there is no second viewer to keep in step with core.
- Filters derive their field matching. A period finds each model's date, a record filter finds the first link to its model, and a filter with nothing to attach to simply leaves that tile alone rather than inventing a join.
- Two sheets, on purpose. Figures are absolutely positioned so scorecards and charts share the dashboard sheet, while their formulas live on a data sheet; a pivot spills a whole table, so it gets a sheet each.
- Filter ids are stable across rebuilds. A dashboard never detaches from its own filters when it is rebuilt.
- Copy the module. Place the spreadsheet_dashboard_builder_aura folder in your Odoo addons path, then update the apps list from developer mode.
- Install Dashboard Builder. The Dashboards module is installed with it as a dependency.
- Open the builder. Dashboards, then Configuration, then Dashboard Builder, then New. Give it a name and a section.
- Add tiles and build. Describe a couple of tiles, add a period filter, press Build, then Open Dashboard.
- Six tile types: KPI, bar, line, pie, map and pivot table
- Any non-transient model, any stored field, measure or count
- Date groupings by day, week, month, quarter or year
- Two-way grouping on pivot tiles, rows and columns
- A domain, a width and a background colour per tile
- Period filters with ten presets, and record filters on any model
- Field matching derived per tile, overridable and skippable
- KPI comparison as the same pivot offset by one period
- Comparison disabled automatically when no period filter exists
- One-button Build producing a real dashboard record
- Stale-definition banner and explicit Rebuild
- Stable filter ids and a preserved dashboard id across rebuilds
- Validation of groupings, domains, fields, filters and empty builds
- Three models, one menu, no new security group
- 50 tests, including a browser tour of the rendered dashboard
- The author can leave a single reply to each comment.
- This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
- If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Screenshots & Previews
1 image availableExpand Preview
The AuraOdoo Quality Guarantee
100% Tested
Verified with Odoo 17, 18, and 19 test pipelines for stability and no conflicts.
Clean Architecture
Built according to official Odoo guidelines and PEP 8 standards with zero bloat.
Dedicated Support
Free installation assistance and quick bug turnaround from our team.