Looker Studio Tutorial Calculated Fields

Published: 14 March 2023
on channel: Analytics with Adam

15,490

In this video we provide a guide to create custom fields for data studio

There are a number of different functions that can be used to create custom fields for data studio, they are all covered in the following documentation provided by Google for looker data studio https://support.google.com/looker-stu....

We focus on 6 core data studio functions in this video which I believe are key to getting more out of static datasets.

Conditional Functions

1. The Case statement allows a new field to be created for different cases that is perfect for categorisation of numeric fields.

2. The if statement is used as both a binary classifier but also as an input in to another fields. This is great for combining with a text function to create something really powerful.

String Functions

3. The replace function can replace text in string with a new string which is great for changing names or reclassifying.

4. The contains text function returns a boolean if the text string contains a certain text or not. This is great for EDA.

5. The CONCAT function in data studio combines fields together.

Arithmetic Functions

6. We also introduce the round function and basic calculations.

On this page of the site you can watch the video online Looker Studio Tutorial Calculated Fields with a duration of hours minute second in good quality, which was uploaded by the user Analytics with Adam 14 March 2023, share the link with friends and acquaintances, this video has already been watched 15,490 times on youtube and it was liked by 92 viewers. Enjoy your viewing!

331