The Index ( ) function in Tableau

The index function essentially counts rows in a dataset and it can be controlled we using a partition, a concept I cover in this video along with creative ways of using the index function to achieve interesting filtering results.
0:00 Intro
0:21The Index () Function
4:16 Understanding how it all works
9:27 Counting Backwards
13:30 Outro -
#tableau #salesforce #analytics Share feedback and Suggestions: tableautim.canny.io/suggestions -
-
Join this channel to get access to perks:
/ @tableautim ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.

Пікірлер: 33

  • @jiancarlochua5346
    @jiancarlochua5346Ай бұрын

    thanks very much rank(index()) is helpful to get the last N number of records even in date as the filter. will check tomorrow if my filtered 1-20 will still automatically updated as the day passes by. hoping it will

  • @naveenreddyinus
    @naveenreddyinus3 жыл бұрын

    Thank you Tim for posting new content almost everyday. Appreciate your help to the Tableau Community.

  • @gabrieljeca
    @gabrieljeca3 жыл бұрын

    Awesome vid! Looking foward for that table calculations setup content

  • @reliablevariable1615
    @reliablevariable16154 ай бұрын

    I was using SOQL and the lack of window functions was driving me insane! You just saved me! Thank you!

  • @anarey1
    @anarey13 жыл бұрын

    This is a very well explained tutorial! Thank you so much!!

  • @paulwyatt8523
    @paulwyatt8523 Жыл бұрын

    Tim, thank you for this demonstration. I am always looking to re-factor and simplify where I can. The method of using (rank(index()) is a stroke of genius enabling dynamic filtering without additional, and specific or specialised , calculations. It is especially effective when used on dates (timeseries calcs and charts). I've just implemented this method to allow users the ability to 'select' menu choices (6,12 24, etc). Mate, thank you so much. This is a technique I am going to use so much from now on.

  • @TableauTim

    @TableauTim

    Жыл бұрын

    Incredible, love it when a tip from a video changes the work you're doing! That's the whole point of this channel so thanks for sharing the value its bringing you!

  • @MrCamusio
    @MrCamusio3 жыл бұрын

    Thank you Tim, your videos are so helpful!

  • @PatrickBateman12420
    @PatrickBateman124203 жыл бұрын

    Love the idea of RANK(INDEX()) to show the latest n months only. Thanks a bunch, Tim!

  • @sanagaribabu7956

    @sanagaribabu7956

    3 жыл бұрын

    But required desc order ?how to do please reply. For -5 bottom 5 top both in same view

  • @mariamkokaia5411
    @mariamkokaia54116 ай бұрын

    Thank you so much!!

  • @luciavazquez3760
    @luciavazquez37603 жыл бұрын

    Hi, Tim. Great video, learned some interesting things about Index. Is there a way to concatenate the Index result with a string, ie. Year parsed from another record field? I want to see, for example, 2020 1, 2020 2, 2021 3, etc. I keep getting must use aggregate or constant fields only error...is there a way around that?

  • @suryacharan9042
    @suryacharan90422 жыл бұрын

    Hi Tim, Great video Could you please tell is there a way to get the index based on a value in a field ? Like in general Index(chair)?

  • @lilrex2015
    @lilrex20153 жыл бұрын

    you have a great channel. Ty

  • @youmunna6452
    @youmunna64523 жыл бұрын

    super tim.... thanks tim... and need a video filter and LODS explain to that ....

  • @AhmerJamil
    @AhmerJamil3 жыл бұрын

    Nice one Tim!! Need a video on Row level Security, if you could please do that

  • @TableauTim

    @TableauTim

    3 жыл бұрын

    We're working on functions at the moment. We'll get to server and that kind of stuff once the basic stuff is done. Only so many hours in the day.

  • @atifahmad8466
    @atifahmad84663 жыл бұрын

    Hi Tim Outstanding, the content you posted has been very helpful. Can you please make a video on SSO(single sign on) authentication for tableau server/online including active directory part as well.

  • @TableauTim

    @TableauTim

    3 жыл бұрын

    Hi Atif Thanks for the suggestion. Could you share in more detail what exactly about setting up SSO you'd like to see and maybe also why the documentation form Tableau's not helping you. shrtm.nu/XC6B

  • @cesargonzalez4935
    @cesargonzalez49353 жыл бұрын

    Fantastic!

  • @davidperalta8614
    @davidperalta8614 Жыл бұрын

    Hi mate, it was very usefull, thanks a lot. I create a rank and figures are coloured by categories, nevertheless it doesn't work properly, for any reason some lines are splited in two. Have you faced something like that?

  • @fantasytalker
    @fantasytalker Жыл бұрын

    great learning session on Index(). QQ: can we create multiple top 5 sales at both Category and Subcategory level at the same time? for example: in the same table: return the top x sales on the Category level and amongst the top x category, what is the top x sales at the subcategory? I understand we can hardcoded everything in excel, but is tableau able to do that?Many Thanks.

  • @nitinshokeen6090
    @nitinshokeen60903 жыл бұрын

    Thanks for sharing important information, wou request if you can make videos on windows functions as well

  • @TableauTim

    @TableauTim

    3 жыл бұрын

    I've made videos on all the related underlying functions already. the window modifier just schanges how many rowse ahead or behind the calculation looks like. I'll make a video explaining that soon.

  • @abeavila1984
    @abeavila1984 Жыл бұрын

    How to add grand totals for each category?

  • @emiliesophietafong838
    @emiliesophietafong8383 жыл бұрын

    thank you

  • @vdn5716
    @vdn57163 жыл бұрын

    Hey Hey Tim....Pls make videos on server side also. Advanced topics like server mentoring with postgres or logs analysis. Thanks. Or Make Udemy series on server even if paid one will help us.Thanks

  • @TableauTim

    @TableauTim

    3 жыл бұрын

    Yeah sure theres lots planned this year so all i can say is stay tuned. I will make some for the channel but Infolab (where I work ;) have some ideas on this topic amongst quite a few server gurus) but just stay tuned. Performance monitoring is a big topic so deserves a playlist as well.

  • @technoscopy
    @technoscopy2 жыл бұрын

    Hello can you tell me how to take the Value in index for LOD

  • @TableauTim

    @TableauTim

    2 жыл бұрын

    Sorry not sure what you mean here. Would you like to use an index inside of an LOD? might be simpler to describe what you're doing in general and then we can see if an index or LOD is the right option for you.

  • @vrriedo9827
    @vrriedo9827 Жыл бұрын

    Top Video, but the music make me cracy

  • @TableauTim

    @TableauTim

    Жыл бұрын

    Yeah apologies you learn along the way. I don’t edit with music anymore

  • @vrriedo9827

    @vrriedo9827

    Жыл бұрын

    @@TableauTim 🥰