31 lines
1.1 KiB
Markdown
31 lines
1.1 KiB
Markdown
# Spreadsheet Dashboard POS Cooperative
|
|
|
|
Publishes spreadsheet-based dashboards in Odoo's *Dashboards* menu, in
|
|
a dedicated *Cooperative* group. Built on top of o-spreadsheet, the
|
|
same technology used by Odoo's official `spreadsheet_dashboard_*`
|
|
modules (`spreadsheet_dashboard_sale`, `spreadsheet_dashboard_purchase`,
|
|
etc.).
|
|
|
|
Depends on `pos_dashboard_cooperative` for the underlying data model
|
|
(`report.pos.order` extended with member / category / time
|
|
dimensions).
|
|
|
|
Four dashboards are bundled:
|
|
|
|
| Dashboard | Contents |
|
|
|---|---|
|
|
| POS Overview | Sales, Orders, Avg ticket, Margin + monthly chart |
|
|
| POS Members | Members vs non-members KPIs + monthly chart + TOP 50 buyers |
|
|
| POS Categories | Members contribution + TOP 10 families / subfamilies / products |
|
|
| POS Sales by Time | Sales by day of week + sales by hour of day |
|
|
|
|
The JSON files under `data/files/` are hand-authored and intentionally
|
|
diff-friendly. To redesign one of them visually, install
|
|
`spreadsheet_oca`, edit in the o-spreadsheet UI, export to JSON and
|
|
replace the matching file.
|
|
|
|
See `readme/USAGE.rst` for the full procedure and metric definitions.
|
|
|
|
## License
|
|
|
|
AGPL-3.0 or later.
|