No video
How To Show Top N vs Others In Tableau
Рет қаралды 14,114
Күн бұрынThis tutorial will guide to show top N subcategories and group remaining subcategories in "Others" in Tableau.
Tableau Workbook: public.tableau...
Watch more videos on Tableau helpful tips here: • Tableau Helpful Tips
Please like, share and subscribe to my channel.
Thank you to every single person who has already subscribed to the channel.
@shekharanalytics9337 Жыл бұрын
Hi Darpan , it seems this approach does not wok when filters are applied
@helpful_tipss Жыл бұрын
Which filters are you using? Try adding those filters to context. After that, I guess the filters should work correctly on the view.
@shekharanalytics9337 Жыл бұрын
@@helpful_tipss ...thank you for the prompt reply
@helpful_tipss Жыл бұрын
Did it work?
@shekharanalytics9337 Жыл бұрын
@@helpful_tipss .It worked like charm. Thank you again for quick response I wont hesitate to ask any further doubts :)
@khandelwalshubham67 Жыл бұрын
Hi Darpan, just wanted to ask if we have more than one dimensions, then how are we going to select the pane down option in this approach ? If i want top N vs others at pane level ?
@ZimDataNative 4 ай бұрын
Today i was asked to create a similar view ,and i bumped into your video,you just saved my job ! Great video Darpan.
@helpful_tipss 4 ай бұрын
Glad I could help! 🙂
@ArojitDas-kt2ix 2 ай бұрын
Good Job
@AkshayParulekar-cm7hx 2 жыл бұрын
I'm just making notes of this tutorial: Drag sales to column shelf Create Parameter > Top N Create Set of State > Top > By field > Select Parameter we created Create Calculated Field > IF [State Set] then [State] ELSE "Others" END Drag that Calculated Field to Row Shelf Show Parameter (Top N) Done 👍🏻
@helpful_tipss 2 жыл бұрын
Thanks Akshay for the notes 👍🏻
@aishwaryakannaujia6653 Жыл бұрын
You're a genius! This was very helpful for my assignment.
@helpful_tipss Жыл бұрын
Thanks Aishwarya. Keep sharing the videos with others 👍🏻
@aishwaryakannaujia6653 Жыл бұрын
@@helpful_tipss sure and keep up the good work
@puspanjaliprasad2644 Жыл бұрын
Thank you Darpan... Easy to understand 👍👍👍
@helpful_tipss Жыл бұрын
Glad to hear that. Keep watching the videos 🙂
@yogendrameena1607 2 жыл бұрын
Darpan, It is really a usefull video, thank you :)
@helpful_tipss 2 жыл бұрын
Thank you Yogendra 👍🏻
@user-og7fg4qt1d 6 ай бұрын
You saved me
@mefistofeles_miau Жыл бұрын
it was so helpful
@helpful_tipss Жыл бұрын
Thank you Nallely 👍🏻
@shaba9100 2 жыл бұрын
Bro nice video thank u for making ...🙏
@helpful_tipss 2 жыл бұрын
Thank you 🙂
@shaba9100 2 жыл бұрын
@@helpful_tipss bro need video like what is Dimension and measure some interview questions and answers...make simple video
@vummadis 2 жыл бұрын
Very good video
@helpful_tipss 2 жыл бұрын
Thanks Srinivas
@MrChamago Жыл бұрын
How to do it in case of multi dimensions? For each Category -> TOP N Sub-category and Others
@helpful_tipss Жыл бұрын
You can add the second dimension as the first field in the row shelf. Then you will get a view that will show top N vs others at pane level. You can check this video: kzfaq.info/get/bejne/hLGWbMypx-DGZYE.html
@sandeshshetty4282 2 жыл бұрын
instead of "top N based on sales", can we show flexibilty of multiple measure. eg if sales number are same for both sub category then it should consider other measure like profit for that 2 subcategory.
@helpful_tipss 2 жыл бұрын
It will consider only the sales measure.
@shaikbasha5396 2 жыл бұрын
bro need more videos on calculation part.
@helpful_tipss 2 жыл бұрын
Sure. I will upload more videos 👍🏻
@shashanknegi1255 11 ай бұрын
How will we do this along with Sub Category wise Rank ?
@anishagarwal2998 2 жыл бұрын
If we use filters, this does not work accurately
@helpful_tipss 2 жыл бұрын
Which filters are you using? Try adding those filters to context. After that, I guess the filters should work correctly on the view
@ramseslandaverde1378 2 жыл бұрын
Great video, muy bueno.
@helpful_tipss 2 жыл бұрын
Thank you Ramses👍🏻
Rayapati
Рет қаралды 10 М.