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.
table calculation function groups together all the values of a pivoted row as a list.
How Does It Work?
For example, in the following table, we can use
pivot_row() to write this table calculation:
This will display a list of all the values in each pivot row:
Calculating the Row Total Using
We can then perform calculations on the previous list; for example, we can calculate the row total of this data using the
This function first grabs the pivot row of
as a list, and then sums that list together. This results in:
function can be used to aggregate across any pivoted row. For example, rather than a
sum(), we can also calculate the
mean() of the values in the list, the
min(), and so on. This section of the Looker Functions and Operators documentation page lists all the available table calculation functions and operators.
We can also perform more complex calculations across pivot rows with the
pivot_row function, including a percent of total. Read about how to use pivot_row to calculate a percent of total across rows here .