Analytics Custom Building: eCom Sales trajectory

josephmckeownjosephmckeown Moderator, Lightspeed Staff Posts: 59 moderator
edited November 1 in Reporting & Analytics

This report is one in a series of five discussing ways to measure performance of your eCom shop. To see other ideas, check out 5 Lightspeed Analytics eCom Reports for Optimizing Online Sales

How does your eCom store performance trend compared to your brick and mortar store? We could find this out using Analytics to see how both platforms evolve over time.

To begin, launch the Recent Sales report, which will show you daily totals for this week. Instead of leaving the totals for just this week though, let's open the filters to go back to the beginning of this year...

Again, let's add the Sale Dimension of Is Ecom (Yes/No) as a Pivot...

So our report will look like

Let's run the report to see what it looks like so far...

And we get a list of sales totals by date

Now to plot the trend, let's add a Custom Field Table Calculation


let's look for the word running...


...and we'll select Running Total.


Between the brackets, we'll look for "Total"'

and we'll select "${sale_lines.total_sales_no_tax}"

So now when we save our calculation

We'll get a green column that adds each days' total to the previous totals...

Finally, let's hide the Sale Line total from visualization...

So that when we open the visualization

We can see how the two platforms compare!


Next Report: eCom Sales by day of week

Go back to Blog post: 5 Lightspeed Analytics eCom Reports for Optimizing Online Sales

Analytics Calculations Home

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