How to use SUM + IF formula in Looker Studio? (a.k.a. Google Data Studio). In this video, we cover 4 EXAMPLES to help you understand how to translate your business rules into formulas.
I decided to make today's video more interesting, by incorporating a popular Data Science dataset. I'll come out with 4 questions (quiz) that you could answer using the dataset. I hope it makes your GDS learning easy and fun!
✨BEST EXERCISE FOR YOU✨
4 SUMIF examples & tutorial are included, so you'll learn to write the sum + if function, from simple ones to the PRO level using a mix of multiple operators:
1) Logical operators (AND, OR)
2) Comparison operators (i.e. greater than, equal to, greater than or equal to, lesser than...)
GRAB DATASET HERE: [Source: Stanford.edu] web.stanford.edu/class/archiv...
✨Challenge yourself! ✨
For each question, pause the video and find the answer, then come back to this video again to check your answer! 🔥 Let me know if you got all the questions right!
📒 ADDITIONAL RESOURCES
COUNT DISTINCT + IF - • Count Distinct IF crit...
⭐️ NEW TO GOOGLE DATA STUDIO
Check out our FREE GDS Course (2022) here 👉 • FULL Google Data Studi...
We uses practical approach and covers almost everything you need to get started in Google Data Studio! Take the course now and shine ✨
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!
Try Canva Pro FREE for 30 days: partner.canva.com/danalyser
[ 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.]
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ ko-fi.com/T6T25PD0A
👉 Subscribe to my channel @ ru-vid.com?s...
👉 Shop Danalyser Templates Collection
@ www.danalyser.com
#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
👉 • Display TODAY's DATE a...
⚈ Export Data from Data Studio
👉 • How to Export Data Fro...
⚈ Automation in Data Studio (Email Delivery)
👉 • How to automate data s...
Keywords:
SUMIF with multiple criteria, SUMIF Google Looker Studio, Data Studio SumIf with Examples, Case SUM function, Calculated Field for Sum If, Without Error, SUMIFS in Looker Studio, Google Looker Studio Calculated Field Tutorials, Looker Studio Function Tutorials, How to Use Logical Operators in Looker Studio, How to use Comparison Operators in Looker Studio.
31 июл 2024
