How to Create an Drill Down Donut Chart [in Tableau]

Ғылым және технология

Learn How to Create a Drill Down Donut Chart in Tableau!
This type of chart is also known as Expanding Donut Chart.
In this beginner-friendly Tutorial, I am going to follow the PlayFair Data's blog and go into detail for each step of the process. At the end of the video, I provide a couple of ideas of how to insert this type of chart in a dashboard. Get ready to use your #ParameterAction and overall #Tableau skills!
PlayFair Data's blog post: playfairdata.com/how-to-make-...
Example Dashboards: public.tableau.com/app/profil...
public.tableau.com/app/profil...
Timestamps
00:34 Content Overview
How to Build a Drill Down Donut Chart
00:00 Intro
01:06 STEP 1 - How to Build a Pie Chart In Tableau
01:56 STEP 2 - Turn a Pie Chart into a Donut Chart in Tableau
03:45 STEP 3 - Duplicate the Pie Chart
04:19 STEP 4 - Create a Parameter
04:55 STEP 5 - Create the Calculated Fields
06:18 STEP 6 - Use the Calculated Fields in the View
06:52 STEP 7 - Color Categories Selected by Parameter
07:34 STEP 8 - Add Color Border
07:54 STEP 9 - Create Label
08:41 STEP 10 - Create Dynamic Labels
13:50 STEP 11 - Align Sheets in the Dashboard
15:30 STEP 12 - Order Donut Slices
17:05 STEP 13 - Match the Colors
17:36 STEP 14 - Add Parameter Action
19:08 STEP 15 - Finishing Touches
How to use an Expanding Donut Chart
20:12 Examples of Dashboards that include an Expanding Donut Chart

Пікірлер: 37

  • @rassal9862
    @rassal986211 ай бұрын

    One of the best vedios about creating donuts charts in tableau,,thank you

  • @detalkinet2878
    @detalkinet28785 ай бұрын

    Wow. That's amazing! So clear explanation for this not so easy visualization. Thank you!

  • @Jeff-pi9po
    @Jeff-pi9po4 ай бұрын

    The detailed explanation is really good. This is a perfect video. thank you

  • @nicoi7662
    @nicoi76623 ай бұрын

    Brilliant and clear and concise explanations!

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

    Awsome,that was intensive workaround, even though I considered this as a hack, but it show me what tableau can achieve.

  • @downtoearthdatatips

    @downtoearthdatatips

    Жыл бұрын

    It's definitely hacky :P

  • @ikshitchaudhari2529
    @ikshitchaudhari25292 жыл бұрын

    Wow !! Amazing tutorial Waiting For more !

  • @downtoearthdatatips

    @downtoearthdatatips

    2 жыл бұрын

    Thank you Ikshit, there's more coming up for sure!

  • @avijeetsingh1861
    @avijeetsingh186111 ай бұрын

    Amazing video! Very helpful.

  • @downtoearthdatatips

    @downtoearthdatatips

    11 ай бұрын

    thank you!

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

    Amazing work. Quite detailed explained. Thank you for sharing👍

  • @downtoearthdatatips

    @downtoearthdatatips

    Жыл бұрын

    Thank you Anand, I appreciate it!

  • @zeeshanahmed9719
    @zeeshanahmed97193 ай бұрын

    Great explaination.

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

    This is amazing!

  • @downtoearthdatatips

    @downtoearthdatatips

    Жыл бұрын

    Thank you 💝

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

    Awesome!!!!

  • @downtoearthdatatips

    @downtoearthdatatips

    Жыл бұрын

    🥳

  • @juanadearco6356
    @juanadearco63562 жыл бұрын

    this is excellent!

  • @downtoearthdatatips

    @downtoearthdatatips

    2 жыл бұрын

    Thank you so much!

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

    Great video! I tend to prefer the static version using multi-layer sunburst, but I guess it's a preference thing.

  • @downtoearthdatatips

    @downtoearthdatatips

    Жыл бұрын

    I usually prefer interactivity, which is what makes Tableau so powerful, indeed it's a matter of preference :)

  • @zubdew
    @zubdew10 ай бұрын

    Awesome video with clear steps! I ran into a problem with my implementation that I am hoping you have a solution for. I have just gotten to the step of creating the dynamic labels, and they work great. In my dataset, I have 'Brand' and 'Style' where each Brand has one or more styles (just like how each Category has multiple Sub-Categories in your video). For the brands that have several styles, the labels pop up perfectly. However, for the brands that only have one style, no label pops up at all and I cannot figure out why they wouldn't or how to get them to appear. Any advice?

  • @LP-ur7cx
    @LP-ur7cx3 ай бұрын

    I am at the create dynamic labels section and I am using COUNT instead of SUM (that is the most appropriate for the data I am using). However, it will not produce a null, it shows a zero for all false statement for the subcategory filter. Is there a way around this?

  • @wisdou2001
    @wisdou20018 ай бұрын

    Such a great video, thank you so much. I do have a small problem after I applied the "dynamic" calculations the chart display the values for the selected sub-categories but it also shows '0' for the other subcategories even thought they are greyed out. I am hoping you might know a way to display the values for the selected subcategory only. Again great video and thank you.

  • @mansi4495

    @mansi4495

    6 ай бұрын

    FACING THE SAME PROBLEM.

  • @mansi4495

    @mansi4495

    6 ай бұрын

    coined a workaround - create another calculated field that uses the 'Dynamic subcategory sales label" and use the logic as If Dynamic subcategory sales label >0 THEN Dynamic subcategory sales label ELSE Null and drag that to the label and it will show only values greater than 0

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

    It's wonderful I hope next video will be how to create interactive dashboard

  • @downtoearthdatatips

    @downtoearthdatatips

    Жыл бұрын

    Thank you for the input Gokul!

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

    nice,can u do video on LOD's in tableau

  • @downtoearthdatatips

    @downtoearthdatatips

    Жыл бұрын

    Hi Sri, thank you for your suggestion! Anything in particular you would like to see?

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

    The category pie chart moves when we have more than 4 categories. I have 4 categories and each category has 3-5 sub categories. Now when selecting the category that has more than 50% split, both the category and subcategory donut charts appear aligned However, when I select a category that is like 9% then category donut shows the angle on right side let's say while the subcategory shows the angle in the Centre. They are not aligned. Any idea how I can fix it.

  • @downtoearthdatatips

    @downtoearthdatatips

    Жыл бұрын

    Hi Gomathi, it's a bit hard for me to understand it without seeing the dashboard unfortunately. One thing I can say in general is make sure you don't have negative amounts in your measure, or that will cause some weird reaction in the pie :)

  • @ramasuryas3620
    @ramasuryas36209 ай бұрын

    Hi I tried this chart with more subcategories. However due to many subcategories all labels r not showing also tool tip is not working because category container is blocking subcategories tool tip. Can u please let me know how to show subcategories tool tip on hoover. Thank you

  • @downtoearthdatatips

    @downtoearthdatatips

    9 ай бұрын

    Unfortunately this is a limitation of Tableau...

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

    Great video! ! ! how do I contact you ?

  • @downtoearthdatatips

    @downtoearthdatatips

    Жыл бұрын

    Hi Pierre, thank you! You can contact me at gapo.inquiries@gmail.com

  • @grantk6435
    @grantk64352 жыл бұрын

    ƤRO𝓂O𝕤ᗰ 🙌

Келесі