{"id":11749,"date":"2018-03-26T04:48:47","date_gmt":"2018-03-26T04:48:47","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=11749"},"modified":"2025-03-01T21:44:26","modified_gmt":"2025-03-01T16:14:26","slug":"tableau-sankey-chart","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/","title":{"rendered":"Tableau Sankey Chart – Build Sankey Diagram in Tableau"},"content":{"rendered":"

In this Tableau tutorial<\/a><\/strong>, we are going to study what is Tableau Sankey Chart, how to build a Sankey chart in tableau diagram and a stepwise description with Sankey chart example.
\nSo, let us start with Sankey Chart in Tableau.<\/p>\n

Tableau Sankey Chart<\/h3>\n

Tableau\u00a0Sankey chart diagram is a visualization used to depict a flow from one set of values to another. The things being connected are called nodes and the connections are called links. Sankeys is best used when you want to show a many-to-many mapping between two categorical dimensions.<\/p>\n

Sankey chart in tableau is a good alternative to bar charts<\/strong><\/a> or pie charts<\/strong><\/a> for flow quantities. In Sankey diagrams, the width of the arrows is proportional to the flow quantity it represents. So, attention is drawn immediately to the most important flows in the processing system.<\/p>\n

Create Sankey Chart in Tableau<\/h3>\n

These are the following steps to build a Sankey Diagram in Tableau.<\/p>\n

Step 1:<\/strong>
\nCreate a Calculated Field T
\n(INDEX ()-25)\/4
\nSo, once your Index is one it’ll provide you with \u2013 half-dozen, after you index is going to be a pair of it’ll provide you with -5.75 soon.<\/p>\n

Step 2:<\/strong>
\nAs per Zen Master Jeffrey Shaffer, if we tend to take forty-nine points for every dimension, we are able to simply plot the form of swish curve line.T ought to be in between -6 and half-dozen and if we tend to take .25 increments we’ll get forty-nine values.<\/p>\n

So, produce a Calculated Field \u201cTo pad\u201d
\nIF [Order Date] = THEN one else forty-nine finish<\/p>\n

So once your Order Date matched with Min (Order date) it’ll assign worth|a worth|a price} one and for all alternative dates value are going to be forty-nine.<\/p>\n

Step 3:<\/strong>
\nNow we’d like a \u201cS” formed curve (sigmoid curve). thus produce another calculated field referred to as sigmoid perform
\n1\/ (1+EXP (1) ^-[T])<\/p>\n

Step 4:<\/strong><\/p>\n

Create a replacement Bin of Size one referred to as cushioned.<\/p>\n

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

Step 5:<\/strong>
\nBuild our Ranking Calculation. We square measure making a running total of a variety of records and dividing by the general Total which is able to offer the United States of America an additive proportion.<\/p>\n

[Rank 1] = RUNNING_SUM (sum ([Number of Records]))\/ TOTAL (sum ([Number of Records]))
\n[Rank 2] = RUNNING_SUM (sum ([Number of Records]))\/TOTAL (sum ([Number of Records]))<\/p>\n

For Example-<\/strong>
\nRegion\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Running_Sum(sum ([Number of Records]))\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0TOTAL (sum ([Number of Records]))
\nCentral\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2,323\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2,323
\nEast\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2,848\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2,848
\nSouth\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1,620\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1,620
\nWest\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a03,203\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a03,203<\/p>\n

Region RUNNING_SUM (sum ([Number of Records])) TOTAL (sum ([Number of Records]))
\nCentral a pair of,323 a pair of,323
\nEast a pair of,848 a pair of,848
\nSouth one,620 one,620
\nWest three,203 three,203<\/p>\n

Step 6:<\/strong>
\nCreate a Curve Function:
\n[Curve] = [Rank 1] + (([Rank 2] \u2013 [Rank 1])*[Sigmoid Functions])
\n[Rank 1] + (([Rank 2] –\u00a0[Rank 1])* [Sigmoid Function])<\/p>\n

Step 7:<\/strong>
\nDrag cushioned Bin on row shelf. Right Click and choose \u201cShow missing Values\u201d. modification the Marks Card choice from \u201cAutomatic\u201d to \u201cLine\u201d. Choose the cushioned field that is on the market on Row shelf and place it into path marks card<\/p>\n

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

Step 8:<\/strong>
\nDrag T calculated Field on Row Shelf and \u201cCompute using\u201d cushioned (which is on the market on Path Marks card)<\/p>\n

Step 9:<\/strong>
\nDrag Region and class at the same time and place it into the color marks card.<\/p>\n

Step 10:<\/strong>
\nDrag the Curve calculated field on Column shelf. Our [Curve] calculation has 3 components thereto, [Rank 1], [Rank 2] and [T]. We need every of those to handle over completely different dimensions.<\/p>\n

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

Step 11:<\/strong>
\nWe currently have to be compelled to vary the lines by size, supported the number of records. Adding add ([Number of Records]) to Size won\u2019t look smart because the cushioned marks haven’t any records related to it. thus produce a calculated field referred to as Size that should be computed victimization cushioned bins. this could solely be potential if we tend to use some Table calculation.<\/p>\n

RUNNING_AVG ( MIN (fastened [Region], [Category] : SUM([Number of Records]) }) )
\nNow drag that calculated Field on size marks card and cypher victimization [Padded]<\/p>\n

Step 12:<\/strong>
\nThe final result can appear as if the below image.<\/p>\n

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

Step 13:<\/strong>
\nAs per the definition of Tableau Sankey chart, it depicts a be due to one set of values to a different. It\u2019s forever smart if you show the flow in your chart. So, we’ll produce 2 single bar stacked chart sheets showing the breakdown of a variety of records for every dimension. If you would like you’ll use the share still.<\/p>\n

Drag \u201cNumber of records\u201d on Row shelf and Region on \u201cColor\u201d still as on \u201cText Label\u201d cards. Duplicate the sheet and replace the Region Dimension by your class Dimension. The sheet can appear as if the below image.<\/p>\n

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

Step 14:<\/strong><\/p>\n

Drag all the 3 sheets into Tableau dashboard<\/strong><\/a>. Placed your Region Sheet on the manus aspect and class sheet on the proper aspect. Place Tableau Sankey chart in between each the sheets.<\/p>\n

Go to Dashboard->Actions->Add Actions->Select Highlight Action. Certify you ought to choose \u201cHover\u201d Action. This will highlight the whole Tableau Sankey chart on Mouse hover.<\/p>\n

Step 15:<\/strong><\/p>\n

The Final output can appear as if the below image.<\/p>\n

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

This was all on Tableau Sankey Chart. Hope you like our Explanation.<\/p>\n

Conclusion<\/h3>\n

Hence, in this tutorial we learned about the What is Sankey chart in Tableau. We also saw how to make Tableau Sankey chart, and a stepwise procedure to create them. Furthermore, if you have any query, feel free to ask in a comment box.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this Tableau tutorial, we are going to study what is Tableau Sankey Chart, how to build a Sankey chart in tableau diagram and a stepwise description with Sankey chart example. So, let us...<\/p>\n","protected":false},"author":5,"featured_media":11768,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[11878,11879,11880,11881,12870,14280,14380,14404,16336],"class_list":["post-11749","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-sankey-chart-in-excel","tag-sankey-chart-in-tableau","tag-sankey-diagram-in-tableau","tag-sankey-diagram-r","tag-sigmoid-function-tableau","tag-tableau-flow-diagram","tag-tableau-process-flow","tag-tableau-sankey-chart","tag-youtube-sankey-tableau"],"yoast_head":"\nTableau Sankey Chart - Build Sankey Diagram in Tableau - DataFlair<\/title>\n<meta name=\"description\" content=\"What is Sankey chart, Tableau Sankey chart, How to build a Sankey chart in tableau, easy Sankey diagram tableau, Tableau Sankey chart example\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tableau Sankey Chart - Build Sankey Diagram in Tableau - DataFlair\" \/>\n<meta property=\"og:description\" content=\"What is Sankey chart, Tableau Sankey chart, How to build a Sankey chart in tableau, easy Sankey diagram tableau, Tableau Sankey chart example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-26T04:48:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-01T16:14:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sankey-Chart-in-Tableau-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tableau Sankey Chart - Build Sankey Diagram in Tableau - DataFlair","description":"What is Sankey chart, Tableau Sankey chart, How to build a Sankey chart in tableau, easy Sankey diagram tableau, Tableau Sankey chart example","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/","og_locale":"en_US","og_type":"article","og_title":"Tableau Sankey Chart - Build Sankey Diagram in Tableau - DataFlair","og_description":"What is Sankey chart, Tableau Sankey chart, How to build a Sankey chart in tableau, easy Sankey diagram tableau, Tableau Sankey chart example","og_url":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-26T04:48:47+00:00","article_modified_time":"2025-03-01T16:14:26+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sankey-Chart-in-Tableau-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Tableau Sankey Chart – Build Sankey Diagram in Tableau","datePublished":"2018-03-26T04:48:47+00:00","dateModified":"2025-03-01T16:14:26+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/"},"wordCount":904,"commentCount":9,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sankey-Chart-in-Tableau-01.jpg","keywords":["sankey chart in excel","Sankey Chart in Tableau","Sankey Diagram in Tableau","sankey diagram r","sigmoid function tableau","tableau flow diagram","tableau process flow","Tableau Sankey Chart","youtube sankey tableau"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/","url":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/","name":"Tableau Sankey Chart - Build Sankey Diagram in Tableau - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sankey-Chart-in-Tableau-01.jpg","datePublished":"2018-03-26T04:48:47+00:00","dateModified":"2025-03-01T16:14:26+00:00","description":"What is Sankey chart, Tableau Sankey chart, How to build a Sankey chart in tableau, easy Sankey diagram tableau, Tableau Sankey chart example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sankey-Chart-in-Tableau-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sankey-Chart-in-Tableau-01.jpg","width":1200,"height":628,"caption":"Tableau Sankey Chart"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-sankey-chart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"Tableau Sankey Chart – Build Sankey Diagram in Tableau"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=11749"}],"version-history":[{"count":9,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11749\/revisions"}],"predecessor-version":[{"id":144428,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11749\/revisions\/144428"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/11768"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=11749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=11749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=11749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}