12.12. Parameter Example: Dynamic Comparison

Let's take your data visualization skills to the next level with dynamic comparisons. Instead of simply allowing users to select a metric or dimension, we'll use parameters to impact the formula itself.

For instance, in Google Analytics, e-commerce conversion rates are typically calculated on a session basis. However, some prefer to calculate this metric on a user basis (number of transactions divided by the number of users). We can create a similar dynamic comparison using Looker Studio.

Learning Objectives

1. Understand the concept of dynamic comparison in Looker Studio.
2. Learn how to create a table with dynamic comparison calculations.
3. Implement interactive features to enhance the user experience.
4. Apply dynamic comparison to real-world situations.
5. Master the use of parameters and case functions in creating dynamic comparisons.

Main Concepts and Topics

In this lesson, you will learn about dynamic comparisons in Looker Studio, which allows for more flexibility and interactivity in data visualizations. Key topics include:

• Creating a table with breakdown and table metric
• Adding a "Transaction Ratio" column
• Using parameters and case functions for dynamic calculations
• Implementing CONCAT() function in Looker Studio for interactivity
• Applying dynamic comparisons to real-world examples

The Dynamic Comparison Setup

Start by creating a table with the desired breakdown and table metric. In this case, we'll be using transactions per session. The calculation will be based on the chosen metric and dimension in the table. For example, if you change sessions to page views, you'll have transactions by page views. If you change it to users, you'll have transactions by new users.

To create this dynamic comparison, add another column to the table called "Transaction Ratio." You won't be able to see the title, as it will be overlaid with another table. The calculation itself is simple: divide the value of transactions by the output of your case function. This creates a dynamic value based on the chosen metric or dimension.

Creating an Interactive Experience

To make this dynamic comparison interactive, use the CONCAT() function to combine the transaction ratio with the value of the table metric. This will come directly from the parameter, allowing users to explore different metrics and dimensions at their convenience.

For example, imagine you're analyzing an e-commerce store's data. You could use this dynamic comparison feature to explore transactions by session, users, or page views, providing valuable insights for your marketing strategy.

Using dynamic comparisons in Looker Studio can greatly enhance your data visualizations by offering more flexibility and interactivity for users. Master this skill, and you'll be able to create even more powerful data-driven insights for your organization.

Enroll in Looker Studio Masterclass →

📩 Receive my weekly Looker Studio tips

🖇 Connect with me on LinkedIn