| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 14682 |
| Technical Name |
do_dynamic_dashboard |
| License | OPL-1 |
| Website | https://doincredible.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 14682 |
| Technical Name |
do_dynamic_dashboard |
| License | OPL-1 |
| Website | https://doincredible.com |
The no-code, drag-and-drop Business Intelligence platform for Odoo — build unlimited dashboards from 16 widget types on any model. KPIs, charts, pivots, calendars, maps, live records and SQL, in minutes.
Why teams choose it: enterprise-grade analytics, built into Odoo, at a fraction of the cost — permission-aware, responsive and complete.
v19.0.5.0.0 · OPL-1
Overview
Dynamic Dashboard Builder turns Odoo 19 into a full self-service BI platform. Point a widget at any model, pick a measure and a group-by, and the engine renders live data as a KPI, chart, pivot, list, calendar, map, kanban or gauge — no code. Arrange everything on a drag-and-resize grid, filter the whole board with one click, then share, publish, schedule or export. Every widget runs as the viewer, so Odoo access rights and record rules always apply.

Why choose this module?
Business users build their own dashboards — no developer, no custom module, no SQL required.
Data is fetched as the current user — a shared dashboard never exposes records a viewer could not see.
Builder, SQL engine, alerts, scheduled reports, portal publishing and AI — all in one module.
Runs on plain Community (base, web, mail, portal). No Enterprise required, at a fraction of typical BI cost.
Key features
Resize and rearrange on a 12-column grid; the layout saves itself.
KPI, chart, pivot, list, calendar, kanban, map, gauge, SQL and more.
Click a chart to filter the board; open the underlying records.
A Metabase-style builder plus a read-only, audit-logged SQL library.
Private / shared / company / public, links, and Customer-Portal publishing.
Threshold & anomaly alerts, plus scheduled PDF reports by email.
Dashboard builder
Enter edit mode, drag widgets onto a 12-column grid, resize them, and configure each one with a live preview and one-click suggested metrics. The layout saves automatically.


KPI widgets
Headline numbers with a trend sparkline, period-over-period delta, target progress and threshold colours. Goal, Gauge and Bullet widgets turn the same measures into progress meters.

Chart gallery
Eleven chart layouts, switchable in one click. Every chart supports drill-down and export. Previews below are rendered from real data.

Compare categories side by side. Best for: revenue by region, count by stage.

Rank many items or long labels. Best for: salesperson ranking, top products.

Show a trend over time. Best for: monthly revenue, growth.

Trend with volume emphasis. Best for: cumulative totals.

Share of a whole, few slices. Best for: simple splits.

Share of a whole with a clean centre. Best for: product mix.

Share plus magnitude. Best for: weighted categories.

Multi-axis comparison. Best for: performance by dimension.

Stage-by-stage conversion. Best for: sales pipeline.

Cyclical categories. Best for: seasonality by month.

Progress as a ring. Best for: completion percentage.
Dedicated widgets for correlation and value-vs-target meters.
Supported views & components
Beyond charts, widgets embed record views and productivity tools directly on the board.
Sortable record tables; click a row to drill in.
Expandable cross-tab with groups, totals and multiple measures.
Records on a month / week / day calendar by date.
Native Odoo kanban — drag cards and create records.
Geographic markers from latitude / longitude fields.
Read-only SQL results no ORM aggregate can express.
Context, checklists and one-click create buttons.
Global date range, quick filters; export CSV / Excel / JSON / PNG / PDF.
Email a dashboard snapshot on a daily / weekly / monthly cron.




Gantt, Cohort and Timeline are Odoo Enterprise-only view components and are not part of this Community module; scheduling needs are covered by the Calendar widget.
Dashboard templates
Nine professional starter templates — Sales, CRM, Purchase, Project, HR, Manufacturing, Inventory, Accounting and Helpdesk — appear automatically when their app is installed. Start from one in a click, then clone, import / export as JSON, or publish your own as a template.

Workspaces
A role-based analytics home that pairs a dashboard with a side rail of quick actions, favorites and recents. Six presets ship ready — CEO, Sales, CRM, HR, Accounting, Inventory.

Security & permissions
Every widget queries with the user's own rights — record rules always apply.
Dashboard User and Manager groups, plus a separate SQL Author group.
Private / shared / company / public with View, Edit and Owner roles.
Single SELECT/WITH, denylist, timeout, row cap, read-only cursor, audit log.
Company isolation via record rules and per-company branding.
Published dashboards are read-only and scoped to the portal user.
Responsive design & theming
The 12-column grid reflows to 6 columns on tablets and 1 column on phones, and charts resize live. The backend uses a clean, stable light theme; the Customer Portal additionally honours the visitor's OS dark-mode preference.



Performance & scale
Grouped reads (read_group), never a query per record.
Read-only queries with forced row caps and statement timeouts.
Grid, chart and map libraries load only when needed.
A TTL cache for unfiltered loads keeps repeat opens instant.
OWL components render charts in the browser for a snappy UI.
GridStack reflows and charts resize without reloading.
Aggregations and limits keep big tables fast; index filter fields.
Security is enforced in-query, not bolted on after.
Company scoping is part of every domain, not a post-filter.
Industry solutions
Works on any model, so it fits any industry. Nine ship as ready templates; the rest you build the same no-code way.
Revenue, margin, pipeline funnel, win-rate, product mix.
Lead funnel, conversion, activities, salesperson ranking.
Receivables ageing, cash position, overdue invoices.
Stock value, low-stock alerts, warehouse maps, valuation.
MO throughput, on-time rate, scrap, work-centre load.
Spend by vendor, lead times, PO status, savings.
Headcount, attendance, leave, recruitment funnel.
Payroll cost trend, cost by department, overtime.
Daily sales, top products, sales by store and hour.
Caseloads, appointment calendars, programme KPIs.
Enrolment, attendance, fees, course performance.
Occupancy, pipeline, property maps, rent roll.
Occupancy, booking calendars, revenue per room.
Sales by category, basket size, store comparison.
On-time delivery, route maps, cost per shipment.
Project milestones, budget vs actual, site maps.
Programme KPIs, grant tracking, caseloads, geo maps.
Screenshots






FAQ
Open BI Studio → My Dashboards → New, name it, then click Open and Edit to start adding widgets.
Add a KPI widget, pick a model and a measure (sum / average / count), and optionally a target and trend comparison.
Add a Chart widget, choose a group-by and a layout; switch between 11 layouts in one click.
Nine templates appear when their app is installed; pick one to instantiate a ready dashboard, then customise.
Set an access mode (private / shared / company / public), add view or edit users, or publish to the Customer Portal with a revocable link.
Yes. It is standalone on Community (base, web, mail, portal) and runs equally on Enterprise.
Through Odoo groups and record rules — every widget runs as the viewer, so access is enforced automatically.
Yes — any Dashboard User can build, save and share their own, scoped by their access rights.
Yes — the grid is fully responsive across desktop, tablet and phone.
Click a chart segment to cross-filter the board, or Ctrl / Cmd-click to open the underlying records.
Changelog
v19.0.5.0.0 — Odoo 19 Community
- 16 widget types incl. visual SQL builder and saved-query library.
- Cross-filtering, drill-down, global date ranges and quick filters.
- Sharing, deep clone, JSON import / export and 9 industry templates.
- Customer-Portal publishing (dark-aware), scheduled PDF reports and alerting.
- Privacy-first AI assistant (opt-in), multi-company, RTL and translations.
Support
Our team is happy to help with setup, configuration and custom dashboards.
Odoo 19 Community · Version 19.0.5.0.0 · License OPL-1
By Do Incredible · support@doincredible.com · https://doincredible.com
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module