How do we transform data fields inside Looker Studio to create a new field from existing metrics and dimensions?
We can:
One of the easiest ways to create a new metric using existing fields inside Looker Studio is to use mathematical functions.
In this lesson we will see how we can use math functions to create a new metric by aggregating existing metrics or converting a dimension into a metric.
How do we know how many event categories we have in Google Analytics? Or how many product categories our eCommerce client offers?
In this lesson we differentiate count from COUNT_DISTINCT() function in Looker Studio and see how we can turn a dimension into a metric using COUNT_DISTINCT()
Let’s see how we can use basic math operations to create a new metric on chart level in Looker Studio.
In particular, we will demo how to create monthly metrics such as average monthly ad spend and monthly sales using the existing fields and math operations.
We will also cover how we can change the field type (such as applying a currency label) on a chart.