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(...))?
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?
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
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
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.
![Count Distinct IF criteria is met | Calculate Unique Count Where Condition [Data Studio Tutorial]](http://i.ytimg.com/vi/jDfxfMQ5Rk4/mqdefault.jpg)
Do you enjoy the challenge? Comment below if you like more of these kind of videos to be Looker Studio PRO! 🔥
I realy love your videos... thank you so much
@@christophersandaik4944 thank u for the support! 😊😊
I missed you much!. nice to see you back!
Oh ! Thank you!! There are a couple videos I uploaded in the past few weeks - check'em out! 💛
You're the best. Solved the issue that was bugging me.
You’re welcome! Glad this solution is applicable for the problem you had 🙌🙌
Yes! Thank you for this! Helped me with an issue I was facing as well :)
This is very useful! Is there a way to have the Total value is fixed even if apply filters?
Gracias por la explicación y la buena practica de enseñar.
Muchas gracias por su apoyo, me alegra que haya disfrutado el aprendizaje.
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(...))?
That wouldn’t works because then looker studio would show the error “cannot mix metrics and dimension” - hope this explains :)
Thanks, this has been super helpful
THANKS!!! I've had way too many filters in my dashboard.🥴 This helps a lot. ✨
Haha! Time for a dashboard revamp! (Just kidding) 😄
Thank you for Watching Rosy!
Very useful. Thank a lot. 😍
Glad it was helpful!
I remember the titanic challenge in kaggle.... Great video
Nice! Have you tried analysing or do some forecast with the dataset?
Very helpful video, thanks!!! Great work
Glad it was helpful! Thanks alot Jordi!
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?
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?
@@danalyser Thank you so much for your feedback and i can did it already. Nice to see you!
Great tutorial thanks
Great work Dana Thank You
That helped a lot
I wonder if you have a LinkedIn Profile ?
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
@@danalyser ok thank you
Gracias!!! Cómo puedo hacer para contar las veces que aparecen valores únicos en celdas de columnas que tienen datos separados por comas
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
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.
Excelente!!!
MINIF function, can we do this as well
Great but in case you have male named differently for example males, male, MALE ....etc how would you do it?
Kak kalau mau buat formula contains bisa gak?
How to sum value in looker studio based on criteria
just wanna ask right do u give class? 我也是kl 人
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 :)
@@danalyser the thing is.. i dunno where to start
@@nl2935 do you have a chance to check out my looker studio course? That should be a great start!
@@danalyser alright 谢谢你啊
@@nl2935 no probs! :)
❤❤❤
😍😍😍😍😍😍
🙏🙏🙏
Thank you mate! 🙌