Starting in Looker 21.12, you can use Quick Calculations to perform common calculations on numeric fields that are in an Explore's data table without using Looker functions and operators when the Custom Fields Labs feature is enabled, and you have permission to use them.
In Looker, table calculations enable you to create calculations that operate on the data table returned in the Explore page by a SQL query. This is great for calculating metrics like running totals. You can also create a running total across rows using table calcs, which you can read more about in the topic about running totals in the Looker Community.
To create a running total using table calculations, you can use the running_total()
function:
To create a running total of the column Inventory Items Count, include this table calculation in your SQL query:
running_total(${inventory_items.count})
This will produce something like: