{"id":1208,"date":"2017-03-06T06:25:02","date_gmt":"2017-03-06T06:25:02","guid":{"rendered":"https:\/\/blogs.scu.edu\/dataviz\/?p=1208"},"modified":"2017-03-06T06:25:02","modified_gmt":"2017-03-06T06:25:02","slug":"how-to-make-a-waterfall-chart-in-tableau","status":"publish","type":"post","link":"https:\/\/blogs.scu.edu\/dataviz\/2017\/03\/06\/how-to-make-a-waterfall-chart-in-tableau\/","title":{"rendered":"How To Make A Waterfall Chart In Tableau"},"content":{"rendered":"<p>A waterfall chart helps understand how positive and negative values of dimension members are contributing to a total.<\/p>\n<p>Here is an example\u00a0visualizes how each Sub-Category in the Sample \u2013 Superstore dataset is contributing to total profit:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"http:\/\/www.evolytics.com\/wp-content\/uploads\/Tableau-Waterfall-Chart-Feature-1024x690.jpg\" alt=\"\" width=\"1024\" height=\"690\" \/><\/p>\n<ul>\n<li>Create a vertical bar chart, make profit as measure, sub-category as dimension. Add a table calculation to the Profit measure so that it calculates a \u2018Running total\u2019 on \u2018Table (Across)\u2019.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone \" src=\"http:\/\/www.evolytics.com\/wp-content\/uploads\/Tableau-Running-Total-Bar-Chart.jpg\" alt=\"\" width=\"502\" height=\"345\" \/><\/p>\n<ul>\n<li>Change the mark type from \u2018Automatic\u2019, which is currently bar, to the \u2018Gantt Bar\u2019 mark type, like below:<img loading=\"lazy\" decoding=\"async\" class=\"alignnone \" src=\"http:\/\/www.evolytics.com\/wp-content\/uploads\/Tableau-Gantt-Bar-Chart-Profit-by-Sub-Category-1024x654.jpg\" alt=\"\" width=\"470\" height=\"300\" \/><\/li>\n<li>In order to get the Gantt bars for each dimension member to properly line up, you first have to create a new calculated field which takes the measure in the waterfall chart multiplied by negative one. (e.g: -[Profit])<\/li>\n<li>Once this calculated field has been created, this is the measure that you drag to the Size Marks Card to create the waterfall effect as we showed in the beginning.<\/li>\n<\/ul>\n<p>Reference:\u00a0<a href=\"http:\/\/www.evolytics.com\/blog\/tableau-201-make-waterfall-chart\/\">http:\/\/www.evolytics.com\/blog\/tableau-201-make-waterfall-chart\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A waterfall chart helps understand how positive and negative values of dimension members are contributing to a total. Here is an example\u00a0visualizes how each Sub-Category in the Sample \u2013 Superstore dataset is contributing to total profit: Create a vertical bar chart, make profit as measure, sub-category as dimension. Add a table calculation to the Profit &hellip; <a href=\"https:\/\/blogs.scu.edu\/dataviz\/2017\/03\/06\/how-to-make-a-waterfall-chart-in-tableau\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">How To Make A Waterfall Chart In Tableau<\/span><\/a><\/p>\n","protected":false},"author":1693,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"qubely_global_settings":"","qubely_interactions":"","kk_blocks_editor_width":"","_kiokenblocks_attr":"","_kiokenblocks_dimensions":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1208","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"gutentor_comment":0,"qubely_featured_image_url":null,"qubely_author":{"display_name":"mxu1","author_link":"https:\/\/blogs.scu.edu\/dataviz\/author\/mxu1\/"},"qubely_comment":0,"qubely_category":"<a href=\"https:\/\/blogs.scu.edu\/dataviz\/category\/uncategorized\/\" rel=\"category tag\">Uncategorized<\/a>","qubely_excerpt":"A waterfall chart helps understand how positive and negative values of dimension members are contributing to a total. Here is an example\u00a0visualizes how each Sub-Category in the Sample \u2013 Superstore dataset is contributing to total profit: Create a vertical bar chart, make profit as measure, sub-category as dimension. Add a table calculation to the Profit&hellip;","post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/posts\/1208","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/users\/1693"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/comments?post=1208"}],"version-history":[{"count":1,"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/posts\/1208\/revisions"}],"predecessor-version":[{"id":1235,"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/posts\/1208\/revisions\/1235"}],"wp:attachment":[{"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/media?parent=1208"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/categories?post=1208"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.scu.edu\/dataviz\/wp-json\/wp\/v2\/tags?post=1208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}