Looker Studio Tutorial Calculated Fields

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 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.

[@colettechorley6960]

Great Tutorial Adam, love how quick and easy your tutorials are. I have text field called queries and I only want to count the queries if they have received at least one URL click. How do I do that? I used this formula count_distinct(if(Url Clicks > 0,Query, null)) but it failed because you cant mix metrics and dimensions. Queries are actually the keywords that bring people to my website, so whilst I get lots of impressions, I'm interested in seeing what queries (keywords) actually deliver people to my website every month. Any help and advice is welcome!!!!

[@analyticswithadam]

Hi Colette, what does a row of the data look like? queries - Cat url click - 2 for example? Great if you could paste a couple of example rows for each col

[@colettechorley6960]

@@analyticswithadam Thanks for coming back to me; much appreciated. Basically, I am importing my data from Google Search Console. The queries field tells me which keyword queries people searched when looking for my website. However, there over 1400 queries which had impressions and only a very small number of them actually went on to generate clicks. So I only want to see queries that have produced at least 1 or more URL click. Ive gone on to classify the queries as active or inactive based on clicks, but I'm still not sure how to count the active collum. It will not let me paste into this chat thread. Can I send to your email or a social media account? Or would you like my email and you contact me. Im so greatful for your help.
Queries are classified as text dimesions and clicks are metrics if that helps

[@analyticswithadam]

throw me a few screenshots [e-mail]. there is an easier solution with a filter and aggregate rather that a formula. Just need to get a quick look at the data.

[@colettechorley6960]

@@analyticswithadam Sent you a message. Many thanks

[@gabrieldantas5636]

I felt it more simple than power bi

[@analyticswithadam]

And it’s free which is a big bonus

[@gabrieldantas5636]

@@analyticswithadam you do a great job Adam. Love your videos.