How To Show Top N vs Others In Tableau

Подписаться 2,8 тыс.

Просмотров 14 тыс.

50% 1

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.

Опубликовано:

17 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 39

@shekharanalytics9337 2 года назад

Hi Darpan , it seems this approach does not wok when filters are applied

@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.

@shekharanalytics9337 2 года назад

@@helpful_tipss ...thank you for the prompt reply

@helpful_tipss 2 года назад

Did it work?

@shekharanalytics9337 2 года назад

@@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 5 месяцев назад

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 5 месяцев назад

Glad I could help! 🙂

@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 👍🏻

@puspanjaliprasad2644 2 года назад

Thank you Darpan... Easy to understand 👍👍👍

@helpful_tipss Год назад

Glad to hear that. Keep watching the videos 🙂

@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

@yogendrameena1607 2 года назад

Darpan, It is really a usefull video, thank you :)

@helpful_tipss 2 года назад

Thank you Yogendra 👍🏻

@ArojitDas-kt2ix 2 месяца назад

Good Job

@VigneshRamesh-b6d 7 месяцев назад

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 2 года назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NKf9ixbzb5M.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.