Sales Anomalies and Trends
The Sales Anomalies and Trends dashboard for Sage X3 provides advanced analytical visibility into margin erosion risk, abnormal daily sales activity, and temporal sales behavior. It helps executive and operational leadership detect early warning signals in customer and product performance, identify volatility-driven risks, and isolate statistically abnormal revenue events for targeted investigation.
How to use the sales anomalies and trends dashboard
- Monitor margin erosion by customer to identify accounts where net sales variance is declining.
- Monitor margin erosion by product to spot products losing margin over time.
- Map sales density by period to see when activity concentrates during the year.
- Detect daily sales anomalies by comparing actual net sales against volatility bands to flag unusual spikes or drops.
Filters
Use the filtering panel at the top of the Sales Anomalies and Trends dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Year: one value
Period: one value
Company: multiple values
Site: multiple values
Product Group: multiple values
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Customer Margin Erosion Monitor | Bubble | Plots customers by net sales variance %, with bubble size reflecting sales volume. Customers further right show stronger variance, and those with shrinking margins cluster toward the bottom. |
| Temporal Sales Density Map | Bubble | Plots sales activity by calendar period, with bubble size reflecting sales volume. Larger bubbles indicate periods with higher concentration of sales. |
| Product Margin Erosion Monitor | Bubble | Plots products by net sales variance %, with bubble size reflecting sales volume. Same structure as the customer view but at the product level. |
| Anomaly Detection in Daily Sales | Combination | Plots daily net sales alongside volatility bands (high and low). Days where sales fall outside the bands indicate unusual activity that may need investigation. |