Product tour
Every feature, built right into Odoo
From building datasets and dashboards to filtering, computing, and sharing — a complete analytics layer that lives in your Odoo, not bolted on beside it.
Custom datasets
Shape your data before it ever reaches your dashboard
- Pick only the fields you need — Odoo models carry dozens of fields — most of which you'll never need on a dashboard. Select only the fields that matter, cutting the clutter and loading your data significantly faster.
- Join datasets visually — Combine several datasets in one chart or table. Draw the join — inner, left, right, full, or union — on a visual canvas, with no SQL and no duplicate datasets.
- Custom SQL with live parameters — For the edge cases, write your own query and add date-range, as-at date, or number parameters that users change from the dashboard without touching the SQL.
- Turn any table into a dataset — Once a table is configured the way you want, save it as a reusable dataset in one click and build new charts on top of it.
Dashboard builder
Turn your datasets into beautiful, informative dashboards
- Flexible dataset-to-dashboard mapping — There are no limits on how you connect datasets to dashboards. One dataset can power many dashboards, and one dashboard can pull from many datasets — however your business needs it.
- Private by default, shared on your terms — Every dashboard you build is private to you until you decide otherwise. Share it with a specific person or an entire group — you stay in full control of who sees what.
- Pick a chart, see it live — Choose from a visual grid of chart types and watch it render with your real data while you configure it — no surprises, no back and forth.
- A default layout you control — Arrange the dashboard once as its creator. Every user starts from your layout, can rearrange it their way, and can reset back to yours at any time.
AI assistant
Build charts, whole dashboards, and answers just by asking
- Describe it, then refine it — Type “monthly sales as a bar chart” and the assistant builds it. Not quite right? Keep chatting to adjust it — the result is an ordinary chart you can fully edit.
- A whole dashboard from one sentence — Describe what you need — “a receivables overview for the finance team” — and get a complete dashboard built from your existing datasets.
- Ask your data a question — Open the AI analyst on any dashboard and ask in plain language. Every answer shows the query it ran, so you can check the work.
- Your records stay in Odoo — Queries are read-only and run inside your database. Only the table structure and summarised results are sent to the AI — never your raw records.
Dashboard library
Go live on day one with ready-made dashboards
- Prebuilt for every team — A growing library of professionally designed dashboards — Financial, Receivables, Sales, Purchase, and Inventory — ready to use.
- One-click install — Add a whole template to a new or existing dashboard instantly. No wiring, no code changes, no module upgrades required.
- Preview with your data — See every chart rendered with your live Odoo data before you add it, so you know exactly what you’re getting.
- Install all, or pick & choose — Take the whole dashboard, or copy just the tiles, charts, or tables you want — then make it yours.
Works with your Odoo
Every version, Community or Enterprise, updates included
- Odoo 14 through 19 — Every release from 14 to 19 is supported today, and older versions can be supported on request. Whichever version you are on, you are not waiting for us to catch up.
- Community, not just Enterprise — The advanced analytics Odoo keeps behind Enterprise work exactly the same on Community. No edition upgrade, no per-user Enterprise licence, just the module.
- Updates included with your plan — We ship a release every week — new features, visualizations and improvements — at no extra cost for as long as your plan is active, including support for each new Odoo version as it lands.
- Upgrade Odoo on your schedule — Moving from 16 to 19 is covered by your existing plan — no re-buying, no rebuilding. Your dashboards, datasets and filters come with you.
Two-way Odoo integration
Not just a viewer — your dashboard talks back to Odoo
- Drill down to live Odoo records — Every number on your dashboard is a doorway. Click any tile, chart, or KPI and OdooDashboards takes you directly to the matching records inside Odoo — already filtered to exactly what you were looking at. No searching, no manual filtering.
- Deep drill down across related records — Jump straight to the related records you care about — in one click, with no intermediate steps. Without going through the parent record first, you land directly on the unique customers, products, or any related data behind a summary figure.
- Trigger Odoo actions from the dashboard — Go beyond reading data — act on it. Trigger any Odoo server action directly from your dashboard without opening Odoo. Validate, approve, confirm, or any custom action — executed instantly on the records you're viewing.
- Embed dashboards inside any Odoo form view — Place any dashboard as an action inside an Odoo form view — so when a user opens a record, they can jump straight to a dashboard that is already filtered to that exact record. No smart buttons needed, no custom development required.
Visualizations
Every chart type you need to tell your data's story
- Tiles & KPIs with goals — Show the single numbers that matter, compared with the previous period. Add an optional target with a progress bar that shows how close you are and who owns the goal.
- Every standard chart — Bar, stacked bar, line, area, doughnut, and funnel charts — with multiple series on one chart, data labels, and min, max, average, or total lines.
- Change vs the previous period — Show the percentage change between periods right on bar and line charts, so trends read at a glance.
- Map views — Visualize geographic data natively. Group your data by country, state, or city fields and plot them on interactive maps where the color intensity represents your metric.
Interactive tables
Not just a data dump — a fully interactive way to explore your data
- Group by with totals — Group rows by any field, or nest dates by year, quarter, and month — with a totals row where you pick sum, average, count, min, or max for each column.
- Conditional formatting — Colour cells or whole rows with your own rules, so overdue invoices, low stock, or missed targets stand out instantly.
- Show, hide, pin & transpose — Users choose which columns they see and can flip rows into columns. Creators decide which columns stay pinned by default.
- Pivot & matrix reports — Drag and drop rows, columns, and measures to reshape your data just like Excel — or use matrix reports for several measures across days, months, quarters, or years.
Filtering
Powerful, layered filtering — from individual components to the entire dashboard
- Global dashboard filters — Set a filter once and it applies across the dashboard — even to elements built on different but related datasets. Choose which elements it drives and give it a default value.
- Contextual filters — Filters are aware of each other. When you select a value in one filter, all related filters automatically narrow down to show only relevant options — eliminating irrelevant choices and preventing impossible filter combinations.
- Multiple date filters & as-at dates — Put several date filters on one element and use “is up to” and as-at dates — enough to build a six-column trial balance in a single table.
- Filter on totals — Filter on aggregated values — customers with over $10k in sales, products with fewer than 5 orders — not just on individual rows.
Computations
Go beyond displaying data — calculate, transform, and enrich it right inside your dashboard
- Custom fields without code — Build new columns with arithmetic, IF/THEN conditions, date math, combined text, and % of total — in a step-by-step wizard.
- Running balances — Running totals with an optional opening balance — ledgers and cumulative trends without a spreadsheet.
- Conditional value transformation — Change what a row displays based on a condition — replace, relabel, or remap values dynamically so the data tells a cleaner, more meaningful story.
- Conditional row tagging — Automatically assign color-coded tags to rows based on conditions — making it instantly obvious which records need attention, are on track, or have crossed a threshold.
Targets & goals
Set targets in Odoo and track them right next to your actuals
- Plan targets by period — Enter targets by month, quarter, or year — broken down by salesperson, team, product, or any other dimension.
- Target, variance & attainment — Add Target, Variance, and % Attainment columns to any table, calculated against your live Odoo actuals.
- Pro-rated automatically — Looking at half a month? Targets are pro-rated to the date range you filter on, so the comparison is always fair.
- Goals on KPI tiles — Give any KPI a goal, a period, and an owner, and show progress towards it — including its contribution to a company-wide goal.
Performance
Built for speed — dashboards that load fast and stay fast at any scale
- SQL at the core, not Odoo ORM — Most Odoo reporting tools go through the ORM — which adds overhead, applies security rules on every field, and is not designed for analytical queries. OdooDashboards queries the database directly using SQL, making data retrieval significantly faster — especially on large datasets.
- Elements load independently — Each chart, tile, and table loads on its own with a placeholder and can be refreshed individually — nothing waits for the whole dashboard.
- Data caching with scheduled updates — Not every dataset needs to be live. For analysis that doesn't require real-time data — like last month's performance or year-to-date trends — the data can be saved in a separate optimized table and refreshed automatically by a scheduled job at whatever interval makes sense.
- Per-element load time visibility — See exactly how long each element on your dashboard took to fetch its data. Identify which charts or tables are slow at a glance and optimize only what needs attention — no guesswork.
Presentation & sharing
Take your dashboards into the meeting room — and beyond
- Presentation mode — Turn any dashboard into a full-screen slideshow, one element per slide, with autoplay, looping, thumbnails, and keyboard controls.
- Whole-dashboard PDF — Export the entire dashboard as a PDF, one element per page, ready to email or print.
- Access down to each chart — Grant access by user group per dashboard, per dataset, and even per chart — so each person sees only what they should.
- REST API — Pull dashboard data into other apps through a secure REST API protected by an API key.
Personalization & display
Make every dashboard look exactly the way you want it — and control what others see
- Drag & drop layout — Arrange your dashboard exactly the way you think. Move any component anywhere on the canvas and the layout saves to your preference — every user can have their own arrangement.
- Currency symbols — Display any monetary value with the correct currency symbol — so your numbers always look professional and contextually accurate, whether you're working in dollars, euros, or any other currency.
- Number formatter — Control exactly how numbers are displayed — choose decimal places, thousands separators, and shorthand notation so your data is always easy to read at a glance.
- Color pickers — Customize the colors of any chart, bar, line, or segment to match your brand or make specific data stand out — no design skills required.