This is simply amazing. Just a point to add for level we can use function "COUNTA" in excel which will automatically count the cells which are not empty.
Using custom SQL would definitely remove the need to do any data manipulation in Excel (and hence keep the entire process in Tableau). Thanks for the concept and onwards to Part 2!
Hello great team, I have a question that my Mac doesn’t allow the legacy connection to the excel to creat or allow the cutomer SQL mode to use. How can I go in the Customer SQL in mac os? I mean different technique to use?
Thank you for sharing this method. I am tryin to use the same method however I am having trouble while removing the blanks. Let's say, my data has also blank product categories and segments. I think this is why I see more blanks everywhere and some of the groceries are blank and some are not that makes it not possible to collapse..
I wonder if I could do a similar thing, but using a treemap? Would that be easier? I just need the categories getting smaller. I don't need it to be a circle.
Thanks for sharing! Great tutorial. Question...is it possible to sort segments/slices based on the aggregate measure, so that they align with the level immediately below? I'm in Higher Ed and used your video to create a sunburst detailing sum of enrollment by campus region (level 1), building (level 2), and classrooms (level 3). Desired sort would be: level 1 sort campus region slices counter clockwise starting at 3 o'clock descending by sum of enrollment in region; level 2 similar sort by sum of enrollment for buildings aligned with campus regions in level 1; level 3 classrooms sorted descending order and aligned with buildings from level 2. I've tried various approaches to no avail. Thanks in adavnce!
Hi, thank you for the great tutorial! Is it possible to filter the sunburst chart - for example by country? I have the same categories and subcategories for 28 countries and i want to show the sunburst chart only for one country at a time.
Hi Chr, I'm glad you enjoyed the tutorial! It definitely would be possible to filter the chart by country. You will just need to have a column for Country in your data set. You will also have to be very careful in the data preparation stage so you will have each combination of Dimensions. For example, if you were just adding Country to the chart in the tutorial, you would need to have every combination of Country, Region, Segment, Product Category, and Brand. You could then add your Country field to the Filter shelf and it will filter your view for you. Hope this helps!
hi , Could you please help me why you have take padded value for second duplicated data as 203 only. IS there any specific reason behind this. Please help me understand this in better way.
Hi Sandip, The number 203 is somewhat random. The 203 sets an upper-bound on how many marks Tableau will draw on the view in the data densification process. The more you have, the smoother your curve will be. This has to be balanced against how fast you want your visualization to respond. If you include more marks, it can slow your view down. 203 is a middle-ground number chosen to try to maximize the smoothness of the circles, while balancing responsiveness on the view. You are welcome to use a smaller or a larger number, depending on your set up. Hope this helps!
Hi, Thanks for this great tutorial, the chart looks awesome. Unfortunately I'm struggling to recreate it with my own data. The only difference I can see in what I've done is that I'm using 3 levels instead of four. Would this make any difference to the calculations?
Hi Dean, Having one less level should not cause any issues. Not being certain what the exact issue is, it might be related to the data prep or perhaps the nested table calculations.
Hey, thanks for the reply! I actually managed to fix the chart so it's working perfectly. I've even taken it to another level by introducing parameters so I can switch between different measures in the chart. I'm having a new problem now though - Tooltips. I'd like to display a different tooltip for each level. However, when I create a calculated field like "IF [slice level] = 1 THEN [brand] END" (simplified version) then I get the error about mixing aggregate and non-aggregate comparisons. If i then change it to ATTR([brand]) then it shows up blank when I drag it in to tooltip. Alternatively, if I use "IF [level]=1 THEN [brand] END" then when i pull the pill for this calculation into tooltip it converts it to ATTR(tooltip calc) and again the tooltip is blank. Can you think of a way to have different tooltips for each level of the chart? Many thanks in advance, Dean
Can someone help with the script for getting the same result as from the pivot done here? I don't want the whole script just the logic or any link would be enough. I have poor programming skill, sorry for the trouble.
Hi Raju, This really depends on the of software you are using, i have including an example of data preparation using R: cran.r-project.org/doc/contrib/de_Jonge+van_der_Loo-Introduction_to_data_cleaning_with_R.pdf
@@8BiSHOP6 thank you for the article. I had a quick glance through it and it is certainly a great compact read on data cleaning. But I was more interested in what was is Excel manipulating the data when we use the pivot function. I trying a SQL script but so far no success. I will update if I get a solution for this.
This is simply amazing. Just a point to add for level we can use function "COUNTA" in excel which will automatically count the cells which are not empty.
Thank you for your suggestion and feedback Damanpreet!
Using custom SQL would definitely remove the need to do any data manipulation in Excel (and hence keep the entire process in Tableau).
Thanks for the concept and onwards to Part 2!
Have a good luck on part 2 :)
Hello great team, I have a question that my Mac doesn’t allow the legacy connection to the excel to creat or allow the cutomer SQL mode to use. How can I go in the Customer SQL in mac os? I mean different technique to use?
Any way around custom SQL? Cause they have removed it now.
padded,nested table,custom SQL...woah ..Thanks for the concepts and the explanation..Great one ...
And more is will be waiting for you every week :)
SuperDataScience what if you can't do a custom sql?
Thank you for sharing this method. I am tryin to use the same method however I am having trouble while removing the blanks.
Let's say, my data has also blank product categories and segments. I think this is why I see more blanks everywhere and some of the groceries are blank and some are not that makes it not possible to collapse..
I wonder if I could do a similar thing, but using a treemap? Would that be easier? I just need the categories getting smaller. I don't need it to be a circle.
Is there a way to change the colours per Ring?
Meaning inner ring with different colours than the ring around etc.?
Thanks!
Thanks for sharing! Great tutorial. Question...is it possible to sort segments/slices based on the aggregate measure, so that they align with the level immediately below? I'm in Higher Ed and used your video to create a sunburst detailing sum of enrollment by campus region (level 1), building (level 2), and classrooms (level 3). Desired sort would be: level 1 sort campus region slices counter clockwise starting at 3 o'clock descending by sum of enrollment in region; level 2 similar sort by sum of enrollment for buildings aligned with campus regions in level 1; level 3 classrooms sorted descending order and aligned with buildings from level 2. I've tried various approaches to no avail. Thanks in adavnce!
Hi, thank you for the great tutorial! Is it possible to filter the sunburst chart - for example by country? I have the same categories and subcategories for 28 countries and i want to show the sunburst chart only for one country at a time.
Hi Chr, I'm glad you enjoyed the tutorial! It definitely would be possible to filter the chart by country. You will just need to have a column for Country in your data set. You will also have to be very careful in the data preparation stage so you will have each combination of Dimensions. For example, if you were just adding Country to the chart in the tutorial, you would need to have every combination of Country, Region, Segment, Product Category, and Brand. You could then add your Country field to the Filter shelf and it will filter your view for you. Hope this helps!
Thank you so much for the tutorial.
You are most welcome Ashok!
Hi, Could you please help me with custom oracle sql for data preparation step with same set of data used in the video
Instead of If logic loops, I think CountA() on each row would have been an easier solution to get the levels. Right?
Hi Amrita. Indeed that will work too, nice suggestion!
hi ,
Could you please help me why you have take padded value for second duplicated data as 203 only. IS there any specific reason behind this. Please help me understand this in better way.
Hi Sandip, The number 203 is somewhat random. The 203 sets an upper-bound on how many marks Tableau will draw on the view in the data densification process. The more you have, the smoother your curve will be. This has to be balanced against how fast you want your visualization to respond. If you include more marks, it can slow your view down. 203 is a middle-ground number chosen to try to maximize the smoothness of the circles, while balancing responsiveness on the view. You are welcome to use a smaller or a larger number, depending on your set up. Hope this helps!
thank you so much for quick help.
Hi,
Thanks for this great tutorial, the chart looks awesome.
Unfortunately I'm struggling to recreate it with my own data. The only difference I can see in what I've done is that I'm using 3 levels instead of four. Would this make any difference to the calculations?
Hi Dean,
Having one less level should not cause any issues. Not being certain what the exact issue is, it might be related to the data prep or perhaps the nested table calculations.
Hey, thanks for the reply!
I actually managed to fix the chart so it's working perfectly. I've even taken it to another level by introducing parameters so I can switch between different measures in the chart.
I'm having a new problem now though - Tooltips. I'd like to display a different tooltip for each level. However, when I create a calculated field like "IF [slice level] = 1 THEN [brand] END" (simplified version) then I get the error about mixing aggregate and non-aggregate comparisons. If i then change it to ATTR([brand]) then it shows up blank when I drag it in to tooltip.
Alternatively, if I use "IF [level]=1 THEN [brand] END" then when i pull the pill for this calculation into tooltip it converts it to ATTR(tooltip calc) and again the tooltip is blank.
Can you think of a way to have different tooltips for each level of the chart?
Many thanks in advance,
Dean
Dean Thomas how did you fix your original problem?
Can someone help with the script for getting the same result as from the pivot done here?
I don't want the whole script just the logic or any link would be enough. I have poor programming skill, sorry for the trouble.
Hi Raju,
This really depends on the of software you are using, i have including an example of data preparation using R:
cran.r-project.org/doc/contrib/de_Jonge+van_der_Loo-Introduction_to_data_cleaning_with_R.pdf
@@8BiSHOP6 thank you for the article. I had a quick glance through it and it is certainly a great compact read on data cleaning.
But I was more interested in what was is Excel manipulating the data when we use the pivot function. I trying a SQL script but so far no success. I will update if I get a solution for this.