The Index ( ) function in Tableau
HTML-код
- Опубликовано: 8 авг 2024
- 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.
Thank you Tim for posting new content almost everyday. Appreciate your help to the Tableau Community.
Awesome vid! Looking foward for that table calculations setup content
This is a very well explained tutorial! Thank you so much!!
Thank you Tim, your videos are so helpful!
Love the idea of RANK(INDEX()) to show the latest n months only. Thanks a bunch, Tim!
But required desc order ?how to do please reply. For -5 bottom 5 top both in same view
I was using SOQL and the lack of window functions was driving me insane! You just saved me! Thank you!
Thank you so much!!
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.
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!
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
you have a great channel. Ty
super tim.... thanks tim... and need a video filter and LODS explain to that ....
Fantastic!
Nice one Tim!! Need a video on Row level Security, if you could please do that
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.
thank you
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?
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)?
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.
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
Thanks for sharing important information, wou request if you can make videos on windows functions as well
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.
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?
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
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.
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.
How to add grand totals for each category?
Hello can you tell me how to take the Value in index for LOD
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.
Top Video, but the music make me cracy
Yeah apologies you learn along the way. I don’t edit with music anymore
@@TableauTim 🥰