39 lines
1.7 KiB
ReStructuredText
39 lines
1.7 KiB
ReStructuredText
Open *Point of Sale → Reporting → Cooperative Dashboards* and pick one
|
|
of the predefined analyses:
|
|
|
|
* **Overview** — sales, margin and order count grouped by month.
|
|
* **Members vs Non-members** — same axes split by cooperative
|
|
membership at the order date.
|
|
* **Top Members** — sales aggregated per cooperative member, sort by
|
|
total to obtain the top buyers.
|
|
* **By Category** — sales by product family (root category); drill down
|
|
to subfamily and product from the *Group By* menu.
|
|
* **Top Products** — sales per product.
|
|
* **By Day of Week / By Hour of Day** — temporal distributions.
|
|
|
|
In every view, additional dimensions are available from the *Filters*
|
|
and *Group By* menus: ``Members``, ``Non members``, ``Member``,
|
|
``Product Family``, ``Product Subfamily``, ``Day of Week``,
|
|
``Hour of Day``.
|
|
|
|
Time dimensions
|
|
===============
|
|
|
|
* ``day_of_week`` is the ISO day number (``EXTRACT(ISODOW FROM
|
|
date_order)``): **1 = Monday, 2 = Tuesday, 3 = Wednesday, 4 =
|
|
Thursday, 5 = Friday, 6 = Saturday, 7 = Sunday**.
|
|
* ``hour_of_day`` is the integer hour in the order's timezone
|
|
(``EXTRACT(HOUR FROM date_order)``), 0..23.
|
|
|
|
These are deliberately exposed as integers rather than translated
|
|
labels so they aggregate cleanly in pivots, charts and spreadsheet
|
|
formulas. Map the numbers to weekday names in the consumer (for
|
|
example, in the o-spreadsheet dashboards) if a localized label is
|
|
needed.
|
|
|
|
Pivot views support the ratios defined by ``web_pivot_computed_measure``
|
|
(e.g. average ticket = total sales / order count). Click *Insert
|
|
Computed Measure* in the pivot's *Measures* menu.
|
|
|
|
For curated dashboards rendered in Odoo's *Dashboards* menu, install
|
|
the companion module ``spreadsheet_dashboard_pos_cooperative``.
|