Analytics Custom Building: Holiday Performance by Store

josephmckeownjosephmckeown Posts: 54Moderator, Lightspeed Staff moderator
edited September 12 in Reporting & Analytics

This report is one in a collection of analyses to help your store make the most of the holiday season. To see other ideas, check out our blog post: 5 Reports you need to run before the Holidays

Do our different stores see different trends during the holiday season?

We could look for this by customizing a Recent Sales report.

To begin, open up a Recent Sales report, which looks at Daily Totals since this past Sunday.

Next, let's open up the filters for the report to look, instead of at the past 1 week...


...to look at the past, say 40 weeks...

Now if we run this, we'll get Daily sales totals since last November...


To make this a bit more meaningful, let's open up the Sale Dimensions and Measures to the left of the report


and let's click on "Week" of the Sale...

This will add the "Week" field of the Sale onto our report...

Let's also hover over the "Sale Completed Date" here, which will bring up the gear icon...

and we'll select "Remove"

This way we should only get one line per week.

Let's run the report to see what the results look like so far...

Now we get sales totals per week!

Finally, let's go back to the Multi-Shop Dimensions...

Hover over "Store" and let's select "Pivot"


Now when we run, we'll get weekly totals per store!


From here, we can use a number of different visualizations to make the data more meaningful.

First the default column plot will show the weekly totals by store next to each other...

If we open up the Visualization tools to the right of the graph, we'll find other ways to plot the data...

For example, if we switch the Series Positioning from Grouped to Stacked, we'll see the store-network totals by week...


...or if we switch to Stacked Percentage, we'll see how much each store contributed towards that week's total...


Next Holiday Report Idea: Holiday Hours

Take me back to Blog post:

Analytics Calculations Home

Post edited by josephmckeown on
Joseph McKeown
Lightspeed Analytics and reporting consultant
Lightspeed HQ
Sign In or Register to comment.