What is the Window function in Tableau? Part1 Tableau Functions

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 58

  • @equiwave80
    @equiwave80 Рік тому +1

    This is the best explanation of Tableau's Window Function that I have ever seen!!!
    Thanks for all your efforts!!! 💯👍

  • @kcapkcans
    @kcapkcans 2 роки тому

    Absolutely amazing presentation and explanation. Can't wait to spend the next two months trying to cram this tool into every project I get assigned!

  • @anbarasuramachandran2235
    @anbarasuramachandran2235 2 роки тому

    Awesome explanation of window function in tableau.

  • @esanders
    @esanders Рік тому

    Very nice explanation and great video! As you mentioned at the end of the video, I would love to see part 2 go through some contrasting real-world examples of when you would want to use window functions.

  • @snakeboy2904
    @snakeboy2904 3 роки тому

    Great job. So glad you went to this function. I feel like this can be a 3 part vid lol.

  • @sandeepgarad1288
    @sandeepgarad1288 2 роки тому

    Awesome, I like your way of teaching... i went through lots of blogs but didn't get the concept. Thank you!!

  • @hazelyip316
    @hazelyip316 2 роки тому

    hi Tim, Great tutorial. Thank you for illustrating the techniques in managing window calculation which re excellent.

  • @sampathkumarreddy4354
    @sampathkumarreddy4354 3 роки тому

    Awesome Tim , Clear cut Explanation ..
    I am hoping you do a complete tableau software in one lengthy video ..
    thank you TIM .Love from INDIA

  • @svetlana_kapranova
    @svetlana_kapranova 3 роки тому +1

    That's the class I needed! You read my mind!
    PS: if you hold click and move the cursor of the mouse along the cells, you can select a range of cells (it is hard to explain this in words, but I tried, rsrs)

    • @TableauTim
      @TableauTim  3 роки тому +1

      I should really have known that aha. Learn somethign new every day ! Thanks for sharing .

  • @aksharjamgaonkar3672
    @aksharjamgaonkar3672 Рік тому

    Hey Tim, many thanks for the great videos you make, really helpfull. Looking forward to the part 2, it would be really great if you can explain in it more details on Compute using when we edit the tableau calculation. cheers!

  • @chrisngan8642
    @chrisngan8642 3 роки тому

    Thank you Tim! Can't wait for part 2!

  • @ameliakohm9812
    @ameliakohm9812 2 роки тому +3

    For Part 2, I'd love to see how to user the Window function to create a bar chart that shows sales per month for a selected year but has a reference line which shows the average sales per month across multiple years. This would allow the user to see, for example, how sales for January 2022 compares to average sales for January from 2017 to 2022.

    • @TableauTim
      @TableauTim  Рік тому

      A quick table calculation could do this with some modifications this sounds like a year to date or year on year on average of years

  • @aw5182
    @aw5182 3 роки тому +2

    Great video! You saved me hours trying to figure this out. Unrelated question -- what tool are you using to annotate your screen with boxes, arrows, etc. while recording?

  • @karthid9611
    @karthid9611 2 роки тому

    awesome video Tim.. watever videos u r uploading is unique.. One small advice.. try to reduce the length of video..

  • @nayabrocks8039
    @nayabrocks8039 3 роки тому

    Huge respect from my side👏
    completely cange in your English Understable now🤘
    Than Previous videos

    • @TableauTim
      @TableauTim  3 роки тому

      I haven't changed the way i speak but thanks for your feedback. ahah I'll take it on board.

  • @PatrickBateman12420
    @PatrickBateman12420 3 роки тому

    Awesome, as always Tim!

  • @kananasadov3117
    @kananasadov3117 2 роки тому +1

    Great, Thank you so much. I couldnt find part 2 though, would be very helpful

    • @TableauTim
      @TableauTim  2 роки тому +1

      havent made it yet. On the list of videos to follow up soon.

    • @yannanshen4602
      @yannanshen4602 2 роки тому +1

      Can't wait to watch part 2!

  • @jeffreyguest735
    @jeffreyguest735 Рік тому

    Your channel has been incredibly helpful to me thus far. Thank you! I was hoping you also could share what annotation tool you use for marking up your videos. Seems much better than the free gink annotator I have started to use.

    • @TableauTim
      @TableauTim  Рік тому

      Sure have the links in other videos should really add them to all videos. Apologies.
      My Screen Annotation Tool: j.mp/3HWc4Mj
      My technology Channel: j.mp/3F0d28f
      My recording gear & what's on my desk. kit.co/TableauTim/desk-setup
      My website: www.tableautim.com/

  • @ameliakohm9812
    @ameliakohm9812 2 роки тому +1

    Hi Tim: This was excellent. Like others, I'm eagerly awaiting Part 2. Any update on when it might be out?

  • @AhmerJamil
    @AhmerJamil 3 роки тому

    Nice one!! Please add some use cases too in the next video

    • @TableauTim
      @TableauTim  3 роки тому

      I gave several. There’s also so many blogs and videos out there. My main focus on the channel is to help everyone go from zero and then in the future maybe in a years time once I’ve covered the functions.

  • @shanefife5639
    @shanefife5639 Рік тому

    Thanks stud. This helped a lot!

  • @tableautaught8213
    @tableautaught8213 3 роки тому

    Great Video. Any idea if Windows now has the Help Seach feature you used at 5:42? Would be really nice to have.

    • @TableauTim
      @TableauTim  3 роки тому

      No windows would have to copy Mac OS and not sure that’s happening anytime soon. It’s not a Tableau thing that can be implemented by them. Macs have this feature enabled for all software.

  • @abhinavgoswami8983
    @abhinavgoswami8983 Місяць тому

    Just a request Part 2 Please .

  • @MrDelphine1994
    @MrDelphine1994 2 роки тому +1

    Hi Tim - what is the software/tool that you use for highlighting things with color and arrows while you present on your screen? I'm going to explain Table Calcs to users next week, and that would be super handy ! Your videos are awesome. Thanks :)

    • @TableauTim
      @TableauTim  2 роки тому

      I use this ua-cam.com/video/BzNeBaFzUVE/v-deo.html made a video on my Other channel.

  • @rajarshimaity6838
    @rajarshimaity6838 2 роки тому

    Hello, First of all this is such an amazing video. Crisp and to the point. Just wanted to know is part 2 of What is the Window function in Tableau? Part1 Tableau Functions available ?

    • @TableauTim
      @TableauTim  2 роки тому +1

      Not yet. I usually leave things to develop a little more see what comments people share or want to know more about and then plan part 2 but its due soon probably Early march. have a couple of other videos I want to do as well. Have a long list to get through after the break and a quiet finish to last year.

    • @rajarshimaity6838
      @rajarshimaity6838 2 роки тому

      @@TableauTim Awesome. The Part 1 really helped me out understanding the base idea of window function. I am trying to explore more of this with a chart. Part 2 will help me out with all such questions that currently I am not able to frame.

  • @vasireddyvishnu8012
    @vasireddyvishnu8012 3 роки тому

    Hi,Tim Window functions are similar to over() in oracle,suppose if we want to perform partition by how can we do it in tableau .

    • @TableauTim
      @TableauTim  3 роки тому +1

      The partitions are controlled by dimensions in tableau and the table calculation directions.

  • @louieboi7956
    @louieboi7956 3 роки тому

    Great explanation. Is it possible to see what calculation tableau uses when you reference their summary option under the worksheet menu ?

    • @TableauTim
      @TableauTim  3 роки тому

      It’s just a basic calculator so it only sums averages mins and maxes whatever you select. That’s all it does

  • @danielosu6615
    @danielosu6615 2 роки тому

    Hi, How can I resolve this forecast error (Time series is too short), thank you.

    • @TableauTim
      @TableauTim  2 роки тому

      Add more time to the axis range. If you search extend axis on my channel you can see a video on this topic.

  • @aniketjamode5290
    @aniketjamode5290 Рік тому

    Can you please explain about Window_percentile function?

  • @derekl2882
    @derekl2882 8 місяців тому

    I am preparing for the Data Analyst cert. and I can anticipate them just showing me a formula and asking for the expected value. It is one thing if you have the tool open and can play around, but another when you have to calc this in your head. OK maybe if the examples are as simple as shown here, but I suspect the worst of the Tableau test writers. Do you have any guidance regarding the level of familiarity one needs with WINDOW to sit this exam?
    I suppose that advocates of Tableau would champion this as being flexible, but to me this is not user friendly and is confusing.
    That said, your explanation is solid - thank you TT.

    • @TableauTim
      @TableauTim  8 місяців тому +1

      No the exam isn’t hardcore like that. You just really need context of what the calculation does. The answers will have obvious correct and wrong ones so if you get how the function works usually that’s enough to decipher the answer. Also knowing what’s wrong matters just as much.

    • @TableauTim
      @TableauTim  8 місяців тому +1

      I’ve done a video about the exam along with many others who go into detail about the type of questions you get.

    • @derekl2882
      @derekl2882 8 місяців тому

      @@TableauTim I am watching everything I can. Thanks!

  • @annatereshchuk1554
    @annatereshchuk1554 2 роки тому +1

    Where is Part 2??

  • @paragchaudhari120
    @paragchaudhari120 3 роки тому

    THANK U

  • @davidfeldman603
    @davidfeldman603 Рік тому

    thanks!
    part 2 pls?

    • @TableauTim
      @TableauTim  Рік тому

      When I have time 🕰️ 🤘🏾

  • @mashailfurqan5150
    @mashailfurqan5150 2 роки тому

    where is the part 2?

    • @TableauTim
      @TableauTim  2 роки тому +3

      Not done yet. I'm human, dad and just like you i get busy too. When i get time I'll get on the case :D

    • @mashailfurqan5150
      @mashailfurqan5150 Рік тому

      @@TableauTim HAHA sure man no problem.

  • @seanholland6707
    @seanholland6707 10 місяців тому

    Windows (Microsoft) catching strays at 5:45 in a video about Window Functions is 🤌