Advance Dashboard — Interactive KPI Builder, Charts, TV Mode & Custom SQL for Odoo
by WebbyCrown Solutions https://www.webbycrown.com$ 228.30
Advance Dashboard for odoo 18
No-code dashboard builder — KPI tiles, charts, lists, TV mode, PDF export & custom SQL.
Drag-and-resize grid, 15 widget types, 13 layouts, live date filters, drill-down & wallboard TV mode.
Module overview
What this module adds
A dedicated advance.dashboard workspace on standard Odoo: drag-and-resize grid with 13 themed layout templates, 15 widget types (KPI, comparison, bar, line, pie, radar, funnel, progress, gauge, sparkline, list, custom SQL), dynamic date filters, drill-down to records, TV wallboard mode with auto-refresh, PDF export, JSON import/export, group & user access control, custom SQL analytics with date/company/user placeholders, 4 list view layouts, auto-refresh intervals, and 70 demo dashboards across Sales, CRM, Accounting, Project, HR, Inventory, Purchase, and more.
Core capabilities
| Dashboard builder: drag-and-resize grid, 13 layout templates, greeting bars & stats strips | Widget types: KPI, comparison, bar, line, pie, radar, funnel, progress, gauge, sparkline, list |
| Date filters: today, week, month, quarter, year, last 7/30/90 days, custom ranges | Data sources: any Odoo model with domains, group-by, measures, or custom SQL queries |
| TV mode: full-screen slideshow with configurable slide interval for office displays | Export: PDF reports with KPIs, chart tables & lists; JSON import/export between databases |
| Access control: restrict dashboards by security groups and individual users | Demo data: 70 dashboards (20 addon categories — Base, Sales, CRM, Accounting, Project, HR, Inventory, Purchase, MRP, Maintenance, Fleet, Events, Marketing, POS, Recruitment, Expenses, Timesheet, Repair, Calendar, Survey) |
Depends: base, base_setup, mail, web · OWL client action + Chart.js · Community & Enterprise |
|
Technical highlights
Models advance.dashboard & advance.dashboard.item |
| OWL client action with Chart.js widgets and drag-resize grid |
| Record rules for group & individual user dashboard access |
Custom SQL with {#DATE_FROM}, {#UID} placeholders |
| LGPL-3 · odoo 18 · v17.0.1.8.0 · WebbyCrown Solutions |
Key benefits
- No-code builder: Create dashboards from any Odoo model without writing Python or XML — configure widgets from the UI.
- Rich visualizations: 15 widget types including radar, funnel, progress bar, and KPI comparison with period-over-period trends.
- Ready-to-use demos: 70 pre-built dashboards across 20 Odoo addon categories.
- Share & present: JSON import/export between databases, PDF export, and TV wallboard mode for office displays.
- Secure access: Restrict dashboards by security groups and individual users; managers configure custom SQL analytics.
Demo dashboards by Odoo addon
70 demo dashboards in total — each with 15+ widgets. Import all at once from Settings → Advance Dashboard → Import Demo Data. Dashboards for apps you have not installed still load with Contacts-based sample widgets.
| Odoo addon | Demos | Dashboard names |
|---|---|---|
| Base / Contacts | 3 | Contacts & Directory · Blank Canvas Starter · Healthcare Insight (always available) |
| Sales | 8 | Sales Performance · Custom SQL Analytics · Analytics Hub · Sequence Banking · Minimal Insights · E-Commerce Storefront · Operations Control · Dark Pro Analytics |
| CRM | 4 | CRM Pipeline · CRM Lead Generation · CRM Sales Team Board · CRM Revenue Forecast |
| Accounting | 3 | Executive Overview · Financial Hub · Corporate Command Center |
| Project | 4 | Project Workspace · Project Portfolio · Agile Sprint Tracker · Project Deadline Monitor |
| HR | 4 | HR Workforce · HR Department Hub · HR Talent & Roles · HR Hiring Pulse |
| Inventory | 4 | Inventory Control · Stock Quantities Hub · Warehouse Dispatch Board · Stock Movement Tracker |
| Purchase | 4 | Purchase Analytics · Vendor Spend Board · PO Approval Pipeline · Procurement Operations |
| Manufacturing | 3 | Manufacturing Control · Production Floor Monitor · MRP Analytics Hub |
| Maintenance | 3 | Maintenance Requests Hub · Equipment Care Board · Maintenance Operations |
| Fleet | 3 | Fleet Management Hub · Vehicle Operations Board · Fleet Analytics |
| Events | 3 | Events Overview · Event Registration Board · Events Analytics Hub |
| Email Marketing | 3 | Email Campaign Hub · Marketing Performance Board · Mailing Analytics |
| Point of Sale | 3 | POS Sales Hub · Retail Performance Board · POS Analytics |
| Recruitment | 3 | Recruitment Pipeline · Hiring Funnel Board · Talent Acquisition Hub |
| Expenses | 3 | Expense Management Hub · Employee Spend Board · Expense Analytics |
| Timesheet | 3 | Timesheet Overview · Project Hours Board · Timesheet Analytics |
| Repair | 3 | Repair Orders Hub · Repair Operations Board · Repair Analytics |
| Calendar | 3 | Calendar Overview · Meeting Schedule Board · Calendar Analytics |
| Survey | 3 | Survey Responses Hub · Survey Results Board · Survey Analytics |
| Total | 70 | 20 addon categories · 70 demo dashboards · 15+ widgets each |
If an app is not installed, its demo dashboard is still created with Contacts-based fallback widgets so you can explore layouts immediately.
Dashboard builder & main features
Widgets & layouts
- 15 widget types: KPI tile, KPI comparison, bar, line/area, pie/doughnut, radar, funnel, progress bar, gauge, sparkline, list view, custom SQL.
- 13 layout templates: Sales, CRM, Executive, Analytics, Finance, Sequence, Corporate, Minimal, E-Commerce, Operations, Dark Pro, Healthcare, Blank Canvas.
- Drag-and-resize grid: position widgets freely; each layout includes themed headers, greeting bars, and stats strips.
- List views: 4 presentation layouts with sortable columns and configurable record limits.
Data sources & filters
- Model widgets: pick any Odoo model, set domains, group-by fields, and numeric measures.
- Date filters: today, this week/month/quarter/year, last 7/30/90 days, and custom date ranges.
- Drill-down: click chart segments or KPI tiles to open the underlying Odoo records.
- Custom SQL: cross-model queries with
{#DATE_FROM},{#DATE_TO},{#MYCOMPANY}, and{#UID}placeholders (manager only).
TV mode, export & access
- TV wallboard mode: full-screen slideshow with configurable slide interval for office displays and presentations.
- Auto-refresh: keep live dashboards current with intervals from 15 seconds to 10 minutes.
- PDF export: print-ready reports with KPIs, chart data tables, and list views.
- Access control: restrict dashboards by allowed groups and/or individual users; leave both empty for all internal users.
- JSON import/export: share dashboard layouts between databases or use as backup.
Demo data & administration
- 70 demo dashboards across 20 addons: Base (3) · Sales (8) · CRM (4) · Accounting (3) · Project/HR/Inventory/Purchase (4 each) · Manufacturing/Maintenance/Fleet/Events/Marketing/POS/Recruitment/Expenses/Timesheet/Repair/Calendar/Survey (3 each).
- 15+ widgets per demo: every dashboard is fully populated; safe to re-import from Settings → Import Demo Data.
- App-aware fallbacks: demos auto-detect installed apps; base-only installs get Contacts & Directory widgets.
- Security groups: Dashboard User and Dashboard Manager — managers configure widgets, SQL, and access rights.
- Settings: Import Demo Data, Import Dashboard (JSON wizard), and module configuration from Settings → Advance Dashboard.
FAQs
Does this require Odoo Enterprise?
No. Advance Dashboard works on odoo 18 Community with base and web modules only. Optional app modules (Sales, CRM, Accounting, etc.) unlock richer demo dashboards.
Which Odoo apps are supported for demo data?
70 demos total across 20 Odoo addon categories. If an app is not installed, its dashboards still load with Contacts-based fallback widgets. Each demo has 15+ widgets.
Can I use custom SQL queries?
Yes. Dashboard managers can write SQL with {#DATE_FROM}, {#DATE_TO}, {#MYCOMPANY}, and {#UID} placeholders for cross-model analytics.
How do I restrict who sees a dashboard?
Set Allowed Groups and/or Allowed Users on the dashboard form. Leave both empty to allow all internal users. Dashboard Managers see all dashboards regardless.
Is demo data included?
Yes. Click Import Demo Data in Settings → Advance Dashboard to load 70 sample dashboards. Safe to run multiple times — existing demos are updated, not duplicated.
Explore our other addons
Advance HR
Efficiently manage your workforce with advanced HR features, employee tracking, and organizational management.
View on Apps
Advance Project
Project management, tracking, and collaboration with advanced planning and resource allocation.
View on Apps
Advanced Import Pro
Universal multi-format import with API integration, smart field mapping, and batch processing.
View on AppsContact & support
Questions?
Sales: +91 (942) 867-7503
Website: webbycrown.com
Thank you for exploring Advance Dashboard — beautiful analytics inside Odoo.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 9787 |
| Technical Name |
odoo_advance_dashboard |
| License | LGPL-3 |
| Website | https://www.webbycrown.com |
Please log in to comment on this module