A number without context does not tell you whether you are doing well or badly. A good dashboard shows few indicators, compared against a target or the previous period, and says which decision to take. This guide brings together the method to define KPIs, record sales targets and build dashboards in Odoo with its native tools.
Define what to measure before building
- A KPI is only valuable when compared with a reference: a target, the previous period or an average.
- Remove everything that does not help you decide. A dashboard with a few well-chosen indicators gets used; one with dozens of charts gets ignored.
- Think in levels: management sees strategic indicators, regional managers see tactical metrics and operational leads see detailed data, each with the permissions that apply.
- Design each board so that whoever looks at it knows which action to take or which question to ask their team.
Step 1: record targets in a structured way
Before the dashboard you need the targets in the system. There are four paths, which are not mutually exclusive and which many companies combine:
- Targets per sales team: in the CRM sales team settings you define each group's monthly invoicing target.
- Budgets in Documents and spreadsheets: if you need detail by salesperson or by product, you create budgets linked to sales data, with planned (manual) and actual (automatic) in the same view.
- Gamification: native challenges with rules, participants and rewards, to add motivation to targets.
- Target apps from the Odoo app store: they let you define targets per salesperson, product or category, in quantities and amounts, with built-in analysis reports.
Step 2: build the dashboard with the native tools
Identify the data sources
In Odoo the sources can be individual records, lists or, most commonly, pivot tables. Give each table the shape your analysis needs: the right measures, such as planned and actual, grouping by salesperson or month, and the initial filters.
Fixed and dynamic pivots
When inserting data into an Odoo spreadsheet you can choose between fixed and dynamic pivots. Dynamic ones, created through formulas, update their structure and content when new salespeople or products appear, which makes them easier to maintain.
Calculated measures
For metrics such as missing visits or percentage of compliance, you can create calculated measures directly in the pivot, without leaving for an external sheet.
Charts and global filters
Insert bar, line or pie charts linked to the pivots, customize colors and labels, and add global filters by date, salesperson or region that affect every source on the board.
Three target dashboards worth having
| Dashboard | What it answers | How it is built |
|---|---|---|
| Target by product in units | Which products drive or hold back target achievement | Target analysis filtered by product and grouped by salesperson, with the quantity target and the execution percentage |
| Target by category in value | How financial performance is going per product family | Same analysis with a category filter and the monetary execution percentage measure |
| Global target with monthly trend | How much was achieved versus the target, by salesperson and by month | Built from the target records, with an aggregated and time view |
Dashboard of planned and executed visits
If your team works in the field, the same method applies to visits: a pivot with planned and actual measures, grouped by salesperson and month, a calculated measure of missing visits and a chart with filters by date and salesperson. For how to organize and control visits, see the guide to sales routes and field visits.
Do not edit the native dashboards: clone them
The dashboards that ship with Odoo work as examples and references. Instead of editing them, download them as a JSON file with developer mode, create a new dashboard, import the file as a base and customize it: remove irrelevant metrics, add your own and order the display. That way you keep the original version and define your own permissions.
- Turn on developer mode.
- Open the native dashboard closest to what you need and download it as JSON from the file menu.
- Create a new dashboard and import the JSON as a base.
- Customize metrics and visualizations.
- Set permissions per user or group, for example each salesperson seeing only their own sales and management seeing the consolidated view.
The default dashboards are enough for a small company that is just starting or for a proof of concept.
Boards that refresh themselves
To show an Odoo view on a shared screen, such as visits completed, orders in preparation or the day's sales per branch, you can make the page reload at regular intervals with a browser extension. That way the team sees progress without refreshing manually.
When you do need Power BI
For most sales reports, Odoo's native tools are faster to implement, easier to maintain and integrate with your processes. Consider an external tool when you need to combine sources outside Odoo or run analyses that Odoo spreadsheets do not cover.
Implementing it with Ganemo
Ganemo is an Odoo partner. If you want us to review what to measure and how to build it in your database, see how we run an Odoo implementation in Peru or write to us through contact or at +51 946 377 197.