Sales Pulse: Why the Average Basket Value of the total baskets including at least 1 of the selected brands is lower than the Average Basket Value of baskets including each of these brands?
Our current method of calculating Average Basket Value is:
So you might be wondering, why is that the Average Basket Value of the total baskets including at least 1 of the selected brands is lower than the Average Basket Value of baskets including each of these brands?
In order to better understand this paradox let's take the below example:
Basket id | Purchased brand | Basket value |
1 | ABC, XYZ | €100 |
2 | ABC | €50 |
3 | ABC | €40 |
4 | XYZ | €20 |
So per brand, we'd have:
Brands | Baskets | Average basket value |
ABC | 3 | €63.3 |
XYZ | 2 | €60 |
Total | 4 | €52.5 |