Chapter 12: Parameters in Looker Studio
12.18. Running Calculations
In this lesson, we'll dive into running calculations in Looker Studio. These calculations can be applied to tables and time series to provide useful insights into your data.
Learning objectives
- Understand the difference between comparison and running calculations in Looker Studio.
- Learn how to apply running calculations to tables and time series.
- Explore various types of running calculations and their use cases.
- Discover the impact of sorting data on running calculations.
Comparison & Running Calculations
In Looker Studio, there are two types of calculations: comparison calculations and running calculations.
Main concepts and topics
In this lesson, you will learn about comparison and running calculations in Looker Studio.
Comparison calculations compare a value with the total, maximum, or minimum, while running calculations perform cumulative calculations, such as adding values together over time.
For instance, you might want to use a dynamic comparison parameter that allows you to adjust the comparison criteria based on user input. This can provide more flexibility in your data analysis.
Running calculations can be applied to tables and time series to provide deeper insights into data trends. However, running calculations are only shown and cannot be used in further calculations. Sorting data can also impact the way running calculations are displayed.
Comparison Calculations
Comparison calculations compare the value with the total, maximum, or minimum of the same dataset.
For example, you can apply a percentage of the total calculation to see what percentage a certain value represents of the total. This can be helpful in understanding how different values relate to the whole dataset.
Running Calculations in Looker Studio
Running calculations, on the other hand, allow you to perform cumulative calculations, such as adding values together over time. For example, you can calculate the running total of new users by date. This can be useful in identifying trends and understanding how metrics change over time.
Running Sum Calculations in Looker Studio
This calculation adds up the values cumulatively, providing a running total.
A running sum is a mathematical operation that calculates the cumulative total of a set of numbers as they are being processed. In the context of data analysis, this can be a powerful tool to analyze trends and patterns over time or across categories.
For example, a sales team may use a running sum to track their cumulative sales revenue throughout the month, or an eCommerce site may apply a running sum to monitor the total number of items sold across various product categories.
Running Sum Example with Tables
Let's consider a simple table representing the daily sales revenue for a retail store:
Date | Sales Revenue |
2023-05-01 | 1000 |
2023-05-02 | 1200 |
2023-05-03 | 1500 |
2023-05-04 | 900 |
2023-05-05 | 1800 |
Suppose you want to calculate the running sum of daily sales revenue to track the cumulative sales over time. After applying the calculation, your table will look like this:
Date | Sales Revenue | Cumulative Sales Revenue (Running Sum) |
2023-05-01 | 1000 | 1000 |
2023-05-02 | 1200 | 2200 |
2023-05-03 | 1500 | 3700 |
2023-05-04 | 900 | 4600 |
2023-05-05 | 1800 | 6400 |
The running sum of daily sales revenue is calculated by adding the sales revenue for each day, with the sum growing as new days are included.
Running Min and Max Calculations in Looker Studio
These calculations display the minimum, maximum, or count of values as you go through the data.
Running min and running max calculations are similar to running sums, but instead of computing a cumulative total, they determine the minimum or maximum value in a sequence up to a given point. These calculations can be invaluable for identifying peaks and troughs or for tracking the highest and lowest values in a dataset.
Running Min and Max Example with Tables
Let's illustrate running min and max calculations using a simple table representing daily sales data:
Date | Sales |
2023-05-01 | 100 |
2023-05-02 | 250 |
2023-05-03 | 150 |
2023-05-04 | 300 |
2023-05-05 | 200 |
After applying running min and max calculations, your table will look like this:
Date | Sales | Running Min Sales | Running Max Sales |
2023-05-01 | 100 | 100 | 100 |
2023-05-02 | 250 | 100 | 250 |
2023-05-03 | 150 | 100 | 250 |
2023-05-04 | 300 | 100 | 300 |
2023-05-05 | 200 | 100 | 300 |
As you can see, the running min and max values update as new rows are added to the dataset, reflecting the lowest and highest sales values encountered up to each date.
Running min and max calculations in Looker Studio can help you uncover trends and gain a deeper understanding of your data, making it easier to identify areas of success or improvement.
Running Average Calculations in Looker Studio
The Concept of Running Average
A running average, also known as a cumulative average, is a calculation that determines the average value of a sequence up to a given point. This can be particularly useful for smoothing out fluctuations in data and identifying trends over time.
Running Average Example with Tables
Let's consider a simple table representing the daily number of website visitors:
Date | Visitors |
2023-05-01 | 100 |
2023-05-02 | 150 |
2023-05-03 | 200 |
2023-05-04 | 250 |
2023-05-05 | 300 |
Suppose you want to calculate the running average of daily visitors. After applying a running average and a running sum calculation, your table will look like this:
Date | Visitors | Cumulative Visitors | Running Average of Visitors |
2023-05-01 | 100 | 100 | 100 |
2023-05-02 | 150 | 250 | 125 |
2023-05-03 | 200 | 450 | 150 |
2023-05-04 | 250 | 700 | 175 |
2023-05-05 | 300 | 1000 | 200 |
The running average of daily visitors is calculated by dividing the cumulative number of visitors by the number of values, providing a clearer view of the overall trend in website traffic.
Running Delta Calculations in Looker Studio
Running Delta: This calculation displays the difference between the current value and the one before it.
The Concept of Running Delta
A running delta is a calculation that computes the difference between consecutive values in a dataset. This can help you analyze how values change from one period to another and detect trends or anomalies in your data.
Running Delta Example with Tables
Let's consider a simple table representing the daily number of orders for an online store:
Date | Orders |
2023-05-01 | 50 |
2023-05-02 | 75 |
2023-05-03 | 90 |
2023-05-04 | 80 |
2023-05-05 | 120 |
Suppose you want to calculate the running delta of daily orders to analyze how the number of orders changes from day to day. After applying a running delta calculation, your table will look like this:
Date | Orders | Previous Day Orders | Running Delta of Orders |
2023-05-01 | 50 | - | - |
2023-05-02 | 75 | 50 | 25 |
2023-05-03 | 90 | 75 | 15 |
2023-05-04 | 80 | 90 | -10 |
2023-05-05 | 120 | 80 | 40 |
The running delta of daily orders is calculated by subtracting the previous day's orders from the current day's orders, revealing the day-to-day fluctuations in order volume.
Sorting Data
Sorting your data can impact the way running calculations are displayed. For example, sorting data in ascending order will show running calculations differently than when sorted in descending order. Keep this in mind when analyzing your data.
In this lesson, you've learned about running calculations in Looker Studio and how they can be applied to tables and time series to provide deeper insights into your data. Remember that running calculations are only for display purposes and cannot be used in further calculations.
📩 Receive my weekly Looker Studio tips
🖇 Connect with me on LinkedIn