Moderator, Lightspeed Staff Posts: 86 moderator
edited July 2021

Average Basket Value is a common measure in many kinds of reports.

Typically it follows a pretty predictable formula: total sales divided by number of sales.

If used this calculation against Average Basket Value by, say, the Store...

Or by the Month...

We find that the calculation holds

However, what happens if we try using Average Basket Value by Category?

Or by Brand?

There's a lot of variance between the Average Basket Value and the Calculation of Sales Total divided by number of Sales.

So what the reason for this variance?

Let's look for a sale that has multiple Items on it. I'm going to filter the report to just one sale, and add the Categories as Dimensions on the report:

Look what numbers are returned.

The calculation is the Sale Line divided by the number of Sales; in this case, the totals and calculation are identical because we are diving by 1.

But the Average Basket Value returns the value of the whole sale.

This is because Average Basket Value is a function of the whole sale that an item was on, not just the value of the item itself.

For this reason, we can actually leverage some interesting analyses.

Say, for example, that we want to measure the upsell-value in addition to a Bike on a Sale.

With our Calculation, we can illustrate the average bike value on these sales. If we subtract this from the Average Basket Value:

We can also measure the Average Upsell Value too!

So, Average Basket value should align identically when Sales are not split: by Store, by Day, by Register, etc. But they are not expected to align identically when they are split: by Item, by Brand, or by Discount.

Calculations Home

Joseph McKeown
Lightspeed Analytics and reporting consultant
Lightspeed HQ