Analytics Calculations: A few of the limitations

josephmckeownjosephmckeown Moderator, Lightspeed Staff Posts: 66 moderator
edited June 2019 in Reporting & Analytics
As we venture out into the world of customized reports, there are some limitations to keep in mind for best results and for your emotional well-being.

Table Limits 5000 Rows

Analytics can only display 5000 rows of results,

An incomplete table with a calculated column will not let you sort by calculated results

Keep in mind that you can continue to sort by Dimensions and measures. The most common types of reports that may exceed their row limit will be Dusty Inventory or Customer Lifetime Value. 

You can sometimes avoid this by applying more filters to your reports: perhaps creating Dusty Inventory lists for only one Vendor or Category. Also limiting Customers by status, by State, or by "name begins with", etc...

Lots of data can slow or break a report

There is a threshold to how much calculation a table can take before it doesn't launch any more. 

Enough calculations (including lots of rows and lots of columns), can slow down your browser

Currently, there is not an efficient way of illustrating when a report is too calculation-heavy, This is why, in the best practices, we recommend saving different versions of your report as the calculations become progressively more complex.

Value types don't always mix

In some calculations, Analytics does not like mixing types of values. This comes up a lot when dates are involved. In some spreadsheet values, dates are considered numbers. In Analytics they are not.

To compensate for this, you can extract a number from a date and use it instead.

Filters may filter more than you expect

If you're reporting on a dimension, and no data exists with that dimension on it, the value will not appear in your results.

This often occurs in Sales reports. If we are looking at quantity sold by Category in the past week, and we also add Quantity on Hand, our Quantity on Hand will appear low

This is not because the numbers are reported incorrectly, rather, it is only looking at the Products that sold in the past week, and providing us with a total of their Quantity on Hand, by Category

This is why it's good to measure Inventory levels from an Inventory report (such as "Dusty", with the Dusty filters removed), instead of a sales report

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