This post is a bit different from the others. This time, we won’t dive into Looker Studio itself, but rather review something that can greatly simplify our lives when creating fields within the tool: regular expressions. They are so important that I think it’s essential to understand what they are and see examples before we … Read more
Sometimes, our metrics in Looker Studio don’t have the data type or aggregation we want. In this post, I’ll explain how to modify both. For the examples here, I’ll use the Superstore Products dataset. 1. Changing the Data Type When creating a metric, it defaults to a number. In the examples where we created new … Read more
Sometimes, even though your dataset has many fields, it may lack one you need. In these cases, you should assess whether it can be derived from the available fields and, if so, create it. This is the first blog post on custom fields, and we’ll focus on creating metrics. I’ll walk you through some examples … Read more