Continuing the discussion from Reporting of aggregated data:
Rational
Users have the need to analyze aggregated data of the sales over a period.
Proposal
The most common aggregated data are:
- revenue
- number (of line)
- quantity (when same unit)
There are many kind of axis but the most common are:
- per customer
- per product category > template > product
- per product
- per country > subdivision
The contextual filtering keys are:
- from/to date (required)
- company (required)
- warehouse
The contextual keys for data computation are:
- Sparklines resolution:
- yearly
- monthly
- daily