{"id":391,"date":"2014-11-07T21:23:35","date_gmt":"2014-11-07T21:23:35","guid":{"rendered":"http:\/\/arunethan.com\/?p=391"},"modified":"2015-12-01T16:27:52","modified_gmt":"2015-12-01T16:27:52","slug":"creating-a-donut-chart-in-tableau","status":"publish","type":"post","link":"http:\/\/arunethan.com\/?p=391","title":{"rendered":"Creating a Donut chart in Tableau"},"content":{"rendered":"

Use-case<\/span><\/h2>\n

Steps for recreating the Donut chart example shared in Tableau community site.<\/p>\n

http:\/\/community.tableausoftware.com\/docs\/DOC-5511<\/a><\/p>\n

A donut chart representing the percentage of top customers by profit across product categories<\/p>\n

Steps<\/span><\/h2>\n

1. Create a new Tableau workbook and connect to “Sample – Superstore – English (Extract) data source<\/p>\n

\"Capture\"<\/a><\/p>\n

2. Created a Calculated field “zero” with value 0<\/p>\n

\"Capture\"<\/a><\/p>\n

3. Create a calculated “% of Profit top customers” “Top customers by Profit” Sets is used with measure “Profit”<\/p>\n

SUM(\r\n IF\r\n [Top Customers by Profit]\r\n THEN\r\n [Profit]\r\n ELSE\r\n 0\r\n END\r\n )\/SUM([Profit])<\/pre>\n
\u00a0<\/address>\n
\"Capture\"<\/a><\/address>\n
4. Drag the dimension “Category” and measure “zero” (calculated field we just created) to the column shelf<\/p>\n
\"Capture\"<\/a><\/p>\n
5. Make “Top customers by Profit” sets as COLOR mark and select PIE chart under the drop down<\/p>\n
\"Capture\"<\/a><\/p>\n
6. Make SUM(Profit) the angle marks<\/p>\n
\"Cap\"<\/a><\/p>\n
7. Add “zero” measure again to the column shelf<\/p>\n
\"Capture\"<\/a><\/p>\n
8. Remove all the marks from the SUM(Zero) (2) Marks selection<\/p>\n
\"Capture\"<\/a><\/p>\n
9. Reduce the size of the marks in \u00a0SUM(Zero) (2) add\u00a0“% of Profit top customers” as label and make the second sum(zero)(2) as dual axis<\/p>\n
\"Capture\"<\/a><\/p>\n
add\u00a0“% of Profit top customers”<\/p>\n
\"Capture\"<\/a><\/p>\n
Dual axis selection<\/p>\n
\"Capture\"<\/a><\/p>\n
10. Format the colors accordingly and remove the headers<\/p>\n
\"Capture\"<\/a><\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"
Use-case Steps for recreating the Donut chart example shared in Tableau community site. http:\/\/community.tableausoftware.com\/docs\/DOC-5511 A donut chart representing the percentage of top customers by profit across product categories Steps 1. Create a new Tableau...<\/p>\n","protected":false},"author":1,"featured_media":412,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[105],"tags":[63,28],"_links":{"self":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/391"}],"collection":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=391"}],"version-history":[{"count":8,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/391\/revisions"}],"predecessor-version":[{"id":413,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/391\/revisions\/413"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/media\/412"}],"wp:attachment":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=391"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}