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

Sdílet
Vložit
  • čas přidán 8. 09. 2024

Komentáře • 46

  • @danalyser
    @danalyser  Před rokem +7

    Do you enjoy the challenge? Comment below if you like more of these kind of videos to be Looker Studio PRO! 🔥

    • @christophersandaik4944
      @christophersandaik4944 Před 4 měsíci

      I realy love your videos... thank you so much

    • @danalyser
      @danalyser  Před 4 měsíci

      @@christophersandaik4944 thank u for the support! 😊😊

  • @ashokkpoonia
    @ashokkpoonia Před rokem +1

    You're the best. Solved the issue that was bugging me.

    • @danalyser
      @danalyser  Před rokem

      You’re welcome! Glad this solution is applicable for the problem you had 🙌🙌

  • @user-zp9lg4fg3s
    @user-zp9lg4fg3s Před 6 měsíci +1

    Gracias por la explicación y la buena practica de enseñar.

    • @danalyser
      @danalyser  Před 6 měsíci

      Muchas gracias por su apoyo, me alegra que haya disfrutado el aprendizaje.

  • @sivakumarak8999
    @sivakumarak8999 Před 2 měsíci

    This is very useful! Is there a way to have the Total value is fixed even if apply filters?

  • @GabrielleFrater-Schmid
    @GabrielleFrater-Schmid Před 2 měsíci

    Thanks, this has been super helpful

  • @jyrenekleinflores5916
    @jyrenekleinflores5916 Před rokem +1

    I remember the titanic challenge in kaggle.... Great video

    • @danalyser
      @danalyser  Před rokem

      Nice! Have you tried analysing or do some forecast with the dataset?

  • @Iamgroot14344
    @Iamgroot14344 Před rokem +1

    I missed you much!. nice to see you back!

    • @danalyser
      @danalyser  Před rokem

      Oh ! Thank you!! There are a couple videos I uploaded in the past few weeks - check'em out! 💛

  • @catncurious
    @catncurious Před rokem +1

    THANKS!!! I've had way too many filters in my dashboard.🥴 This helps a lot. ✨

    • @danalyser
      @danalyser  Před rokem +1

      Haha! Time for a dashboard revamp! (Just kidding) 😄
      Thank you for Watching Rosy!

  • @travistai-1228
    @travistai-1228 Před rokem

    Yes! Thank you for this! Helped me with an issue I was facing as well :)

  • @jordi242
    @jordi242 Před rokem +1

    Very helpful video, thanks!!! Great work

    • @danalyser
      @danalyser  Před rokem

      Glad it was helpful! Thanks alot Jordi!

  • @juliautomo8710
    @juliautomo8710 Před 6 měsíci +1

    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  Před 5 měsíci

      That wouldn’t works because then looker studio would show the error “cannot mix metrics and dimension” - hope this explains :)

  • @phomang1103
    @phomang1103 Před 6 měsíci

    Very useful. Thank a lot. 😍

  • @mo-zaoui
    @mo-zaoui Před rokem

    Great tutorial thanks

  • @khaledothman4324
    @khaledothman4324 Před rokem +1

    Great work Dana Thank You
    That helped a lot
    I wonder if you have a LinkedIn Profile ?

    • @danalyser
      @danalyser  Před rokem +2

      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 Před rokem

      @@danalyser ok thank you

  • @claudioerose1
    @claudioerose1 Před rokem

    Excelente!!!

  • @Leocrgr78
    @Leocrgr78 Před 7 měsíci

    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

  • @LevelUp_No1
    @LevelUp_No1 Před rokem +1

    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  Před rokem +1

      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?

    • @LevelUp_No1
      @LevelUp_No1 Před rokem

      @@danalyser Thank you so much for your feedback and i can did it already. Nice to see you!

  • @rubengallardoreynafarje6121
    @rubengallardoreynafarje6121 Před 10 měsíci

    Gracias!!! Cómo puedo hacer para contar las veces que aparecen valores únicos en celdas de columnas que tienen datos separados por comas

  • @jeromvert
    @jeromvert Před 9 měsíci

    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 Před rokem

    Great but in case you have male named differently for example males, male, MALE ....etc how would you do it?

  • @user-jx2yi8ei1h
    @user-jx2yi8ei1h Před rokem

    MINIF function, can we do this as well

  • @adminbanklogo1940
    @adminbanklogo1940 Před rokem +2

    😍😍😍😍😍😍

  • @achmadriandi7769
    @achmadriandi7769 Před rokem

    Kak kalau mau buat formula contains bisa gak?

  • @Jayawaves
    @Jayawaves Před rokem +1

    🙏🙏🙏

  • @nl2935
    @nl2935 Před rokem +1

    just wanna ask right do u give class? 我也是kl 人

    • @danalyser
      @danalyser  Před rokem

      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 Před rokem

      @@danalyser the thing is.. i dunno where to start

    • @danalyser
      @danalyser  Před rokem

      @@nl2935 do you have a chance to check out my looker studio course? That should be a great start!

    • @nl2935
      @nl2935 Před rokem

      @@danalyser alright 谢谢你啊

    • @danalyser
      @danalyser  Před rokem

      @@nl2935 no probs! :)

  • @bulbulahmed3098
    @bulbulahmed3098 Před rokem

    ❤❤❤