CHALLENGE 🔥 - SUMIF Function in Looker Studio | Calculate SUM based on Multiple Conditions / Rules

  Рет қаралды 19,540

Danalyser

Danalyser

Күн бұрын

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.e...
✨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....
[ 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/T6T2...
👉 Subscribe to my channel @ www.youtube.co...
👉 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.

Пікірлер: 47
@danalyser
@danalyser Жыл бұрын
Do you enjoy the challenge? Comment below if you like more of these kind of videos to be Looker Studio PRO! 🔥
@christophersandaik4944
@christophersandaik4944 10 ай бұрын
I realy love your videos... thank you so much
@danalyser
@danalyser 9 ай бұрын
@@christophersandaik4944 thank u for the support! 😊😊
@Iamgroot14344
@Iamgroot14344 Жыл бұрын
I missed you much!. nice to see you back!
@danalyser
@danalyser Жыл бұрын
Oh ! Thank you!! There are a couple videos I uploaded in the past few weeks - check'em out! 💛
@ashokkpoonia
@ashokkpoonia Жыл бұрын
You're the best. Solved the issue that was bugging me.
@danalyser
@danalyser Жыл бұрын
You’re welcome! Glad this solution is applicable for the problem you had 🙌🙌
@NestorLuis-o2v
@NestorLuis-o2v 11 ай бұрын
Gracias por la explicación y la buena practica de enseñar.
@danalyser
@danalyser 11 ай бұрын
Muchas gracias por su apoyo, me alegra que haya disfrutado el aprendizaje.
@travistai-1228
@travistai-1228 Жыл бұрын
Yes! Thank you for this! Helped me with an issue I was facing as well :)
@GabrielleFrater-Schmid
@GabrielleFrater-Schmid 7 ай бұрын
Thanks, this has been super helpful
@sivakumarak8999
@sivakumarak8999 8 ай бұрын
This is very useful! Is there a way to have the Total value is fixed even if apply filters?
@phomang1103
@phomang1103 11 ай бұрын
Very useful. Thank a lot. 😍
@danalyser
@danalyser 11 ай бұрын
Glad it was helpful!
@jyrenekleinflores5916
@jyrenekleinflores5916 Жыл бұрын
I remember the titanic challenge in kaggle.... Great video
@danalyser
@danalyser Жыл бұрын
Nice! Have you tried analysing or do some forecast with the dataset?
@jordi242
@jordi242 Жыл бұрын
Very helpful video, thanks!!! Great work
@danalyser
@danalyser Жыл бұрын
Glad it was helpful! Thanks alot Jordi!
@catncurious
@catncurious Жыл бұрын
THANKS!!! I've had way too many filters in my dashboard.🥴 This helps a lot. ✨
@danalyser
@danalyser Жыл бұрын
Haha! Time for a dashboard revamp! (Just kidding) 😄 Thank you for Watching Rosy!
@mo-zaoui
@mo-zaoui Жыл бұрын
Great tutorial thanks
@juliautomo8710
@juliautomo8710 11 ай бұрын
thank you!! if we only pun if(...) formula but created from the metrics section of calculated field. will it yield the same result? what is the difference between that and putting sum(if(...))?
@danalyser
@danalyser 10 ай бұрын
That wouldn’t works because then looker studio would show the error “cannot mix metrics and dimension” - hope this explains :)
@khaledothman4324
@khaledothman4324 Жыл бұрын
Great work Dana Thank You That helped a lot I wonder if you have a LinkedIn Profile ?
@danalyser
@danalyser Жыл бұрын
Yes I do! But I prefer not to share it at this moment as my account is currently inactive and if you message me there you’ll probably never hear back from me. So if you wanna reach me, can dm me at my instagram: @danalyser8
@khaledothman4324
@khaledothman4324 Жыл бұрын
@@danalyser ok thank you
@KAMADOGROUP
@KAMADOGROUP Жыл бұрын
hi, nicse to see you and thank you so much for your VDO. Please help me to solve this case. how to freeze 1 axis data in look studio. i mean that, if in the data file does not have data but in the looker still show on chart?
@danalyser
@danalyser Жыл бұрын
Hi! You're welcome and thanks for your support too! 💛 re. your question, I'm not very sure what do you mean, would you mind explain it further?
@KAMADOGROUP
@KAMADOGROUP Жыл бұрын
@@danalyser Thank you so much for your feedback and i can did it already. Nice to see you!
@rubengallardoreynafarje6121
@rubengallardoreynafarje6121 Жыл бұрын
Gracias!!! Cómo puedo hacer para contar las veces que aparecen valores únicos en celdas de columnas que tienen datos separados por comas
@claudioerose1
@claudioerose1 Жыл бұрын
Excelente!!!
@Leocrgr78
@Leocrgr78 Жыл бұрын
Good day, I wanted to see if you can help me with this particular formula, I can't find a way to replicate it in Looker =COUNTIFSET(Column1,"="&Criteria,Column2,""&Criteria2) I wanted to know if there is a way to replicate this function, thank you
@jeromvert
@jeromvert Жыл бұрын
Can we add and substract within the dimension values. For eg I want to calculate the difference between Sex Male 50 and Female 30, And Difference would be 20. Is there any formula for that.
@dmb4performance508
@dmb4performance508 Жыл бұрын
Great but in case you have male named differently for example males, male, MALE ....etc how would you do it?
@bulbulahmed3098
@bulbulahmed3098 Жыл бұрын
❤❤❤
@LakshyaSharma-j9b
@LakshyaSharma-j9b Жыл бұрын
MINIF function, can we do this as well
@adminbanklogo1940
@adminbanklogo1940 Жыл бұрын
😍😍😍😍😍😍
@Jayawaves
@Jayawaves Жыл бұрын
🙏🙏🙏
@danalyser
@danalyser Жыл бұрын
Thank you mate! 🙌
@achmadriandi7769
@achmadriandi7769 Жыл бұрын
Kak kalau mau buat formula contains bisa gak?
@nl2935
@nl2935 Жыл бұрын
just wanna ask right do u give class? 我也是kl 人
@danalyser
@danalyser Жыл бұрын
Hello! nice to see you here! my tutorials are all online in this channel. I dont teach physically, but planning to launch my online course soon :)
@nl2935
@nl2935 Жыл бұрын
@@danalyser the thing is.. i dunno where to start
@danalyser
@danalyser Жыл бұрын
@@nl2935 do you have a chance to check out my looker studio course? That should be a great start!
@nl2935
@nl2935 Жыл бұрын
@@danalyser alright 谢谢你啊
@danalyser
@danalyser Жыл бұрын
@@nl2935 no probs! :)
@ArvindKumar-tu2ky
@ArvindKumar-tu2ky Ай бұрын
How to sum value in looker studio based on criteria
Pivot Tables with Google Sheets & Looker Studio Dashboard Tutorial
40:32
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 25 М.
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН
The evil clown plays a prank on the angel
00:39
超人夫妇
Рет қаралды 53 МЛН
I CAN'T Read Your Looker Dashboard on My Phone (Quick Fix)
11:06
MeasureSchool
Рет қаралды 11 М.
7 ESSENTIAL Looker Studio HACKS EVERYONE Should Know!
8:22
Adam Finer - Learn BI Online
Рет қаралды 44 М.
Learn R in 39 minutes
38:56
Equitable Equations
Рет қаралды 820 М.
Cleaning Data in Excel | Excel Tutorials for Beginners
21:04
Alex The Analyst
Рет қаралды 622 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 297 М.
Excel Formulas and Functions | Full Course
52:40
Kevin Stratvert
Рет қаралды 1,8 МЛН
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН