Chapter 5: Data Studio Calculated Field Beginner Tutorial, Using Formulas for Data Transformation

Data Studio Calculated Field is powerful to help us do simple maths calculation, data transformation and logic evaluation. In this tutorial, we'll cover some simple formulas to help you develop a customised analytics dashboard in Google Data Studio.

T I M E S T A M P
00:00 Example Usage of Calculated Fields
01:25 Maths Calculation (W/O Formula)
03:42 How to know if a dimension is calculated field?
04:27 Best Practice: Data Validation & How I usually do it :)
06:41 Maths Calculation (With Formula)
07:57 Text Transformation

❤️ LIKE AND SUBSCRIBE FOR MORE CONTENT LIKE THIS !

F R E E B I E S
I used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!

[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.]

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?

#GoogleDataStudio #Danalyser

--------------------------------------------------------------------------------------------------------------------------
A B O U T M E
👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.
---------------------------------------------------------------------------------------------------------------------------

💌 W A T C H N E X T
⚈ Show current date in dashboard

⚈ Export Data from Data Studio

⚈ Automation in Data Studio (Email Delivery)

[clintonsihombing]

Hi, can we combained data from two colomn into single colomn bt create a new field? What is the right formula to do it and how? I dont mean about the concat, I hope it makes sense. Thanks

[danalyser]

Hey All!! I scheduled this at wrong time 🤣 Anyway if you enjoy this tutorial, lemme know in the comments below! :)

[fullstackdev]

great tutorial! next video please.. :D

[javierfito]

Hello Dana, i´m having a problem. I need to divide quantity of purchased items by transaction to get "average items per order" but it throws an error. Like if those 2 attributes weren´t compatible. Is there a work around?

[jasonjason]

Data studio got weakness, .it can not support combine If and Sum command