Tableau Quick Tip - SUM vs WINDOW_SUM vs TOTAL

Поделиться
HTML-код
  • Опубликовано: 9 сен 2024
  • Do you know the difference between SUM, WINDOW_SUM and TOTAL?

Комментарии • 25

  • @iamanda6666
    @iamanda6666 10 месяцев назад

    Big fan of all your videos. The way you explain has made it so much easier to understand. Wondering if some day you can make a video on how to manage the data security/access of Tableau? :)

  • @larissaroberta3641
    @larissaroberta3641 6 месяцев назад

    So happy to see this type of video created by a woman ❤ the explanation is wonderful! thank you so much for this @sqlbelle

    • @sqlbelle
      @sqlbelle  5 месяцев назад

      Thank you so much Larissa! Your comment means a lot :)

  • @VizWithVictory
    @VizWithVictory 5 месяцев назад

    This is great 😃. I am practically sleeping on your chamnel 😅😅😅

  • @SebAnt
    @SebAnt 10 месяцев назад

    Among all the Tableau teachers I’ve encountered in 2 years, I prefer your teaching style and content the most!

    • @sqlbelle
      @sqlbelle  10 месяцев назад +1

      Thank you for such kind words, @SebAnt !

  • @DataVizcovery
    @DataVizcovery 10 месяцев назад

    Great explanation as always 👍

    • @sqlbelle
      @sqlbelle  10 месяцев назад

      Thank you @DataVizcovery!

  • @adamland12345
    @adamland12345 15 дней назад

    half understood, but what I mostly don't understand is why is this useful?

  • @sankalpjain6435
    @sankalpjain6435 10 месяцев назад

    Great explanation!

    • @sqlbelle
      @sqlbelle  10 месяцев назад

      Glad it was helpful!

  • @manwendersingh5749
    @manwendersingh5749 10 месяцев назад

    Thanks you so much, @sqlbelle! I'm looking more video like this.

  • @alainponroy2621
    @alainponroy2621 10 месяцев назад

    Thank you for this very interesting video 🙂

    • @sqlbelle
      @sqlbelle  10 месяцев назад

      Thank you @alainponroy2621 :)

  • @yashishkarkera5543
    @yashishkarkera5543 10 месяцев назад

    Your explanation was perceptive and enlightening!!!

    • @sqlbelle
      @sqlbelle  10 месяцев назад

      Thank you @yashishkarkera5543

  • @dancefever2500
    @dancefever2500 10 месяцев назад

    Thank you for this great explanation. Do you offer training? I need help with Tableau calculations.. especially how to create calculated fields out of any requirement.

  • @santhosh16081990
    @santhosh16081990 10 месяцев назад +1

    The result of WINDOWS_SUM we can achieve by usinf LOD functions also...
    What is the difference and what are the correct scenario to use LOD and windows functions?

    • @sqlbelle
      @sqlbelle  10 месяцев назад +1

      LODs are used when you don't need the calculation to be affected by other fields/filters in the canvas. LODs also don't get affected by scope and direction. For example computing table across/table down/pane across etc.
      For example if you need to calculate a running total - this will be harder to do in an LOD because you may choose to change the fields in your running total (for example, running total along days, or weeks, or months, or years). Or to even reset this per year. Much easier to accomplish in table calcs.
      Does this help? There are a number of other common use cases. Perhaps I can create some samples in another video.

    • @santhosh16081990
      @santhosh16081990 10 месяцев назад

      @@sqlbelle
      @sqlbelle
      I really appreciate you, spending your valuable time answering my question.
      Yes, it would be helpful if you create another video for different scenarios.
      Thanks

  • @cloudshippingservices9942
    @cloudshippingservices9942 2 месяца назад

    I still didnt get it, do you have another example?

  • @piyushk3652
    @piyushk3652 10 месяцев назад

    Awesome 👍

    • @sqlbelle
      @sqlbelle  10 месяцев назад

      Thank you 🤗

  • @jackieyu5675
    @jackieyu5675 10 месяцев назад

    Belle, you are the best teacher! Please consider opening a member channel, I’ll pay ❤🫶🏻

    • @sqlbelle
      @sqlbelle  10 месяцев назад

      Thank you so much @jackieyu5675 ... this means a lot. I very much appreciate the kind thoughts and words.