Tableau Waterfall Chart – Never doubt the insights of waterfalls
In this tutorial, we are going to learn about an interesting chart, that is, a Tableau Waterfall chart. Here, we will learn how to create a waterfall chart in Tableau software as a stepwise process. You know what you can create your first waterfall chart with us, by just following our guidance in a manner which is shown in this article. All you need, as of now is a sample data set and Tableau software in your device.
Stay updated with latest technology trends
Join DataFlair on Telegram!!
What is Waterfall Chart?
A waterfall chart represents a gradual transition of field values from a start value to end value showing a running total with successive increments and decrements. In a normal running total, we cannot see the contribution of each category or contributing factor to the whole value.
But, in a waterfall chart, we can see how each category’s positive value increments the total value and the negative ones decrement it and then finally leads to a resultant value. This allows for an insightful analysis of how individual elements of dimensions or measures are contributing to bringing a total value of something.
Have you checked the Tableau Donut Chart recipe for maintaining your data accurately?
How to Create Waterfall Chart in Tableau?
Follow the steps given below to create a waterfall chart in Tableau Desktop:
Step 1: Open a New Worksheet in Tableau Desktop
Open a new worksheet in your Tableau Desktop. Make sure that you already have your dataset downloaded.
Step 2: Add Measure Profit and Change Mark Type
This will give us individual flat marks as data points on our plot. Next, we set a quick table calculation for the measure SUM(Profit) present in the Rows section. We add a quick calculation that is running total to our Profit field values. To do this, we right-click on SUM(Profit), select Quick Table Calculation and then select Running Total.
Step 3: Create New Calculated Field
Next, we need to create a new calculated field in tableau waterfall chart. For this, right-click on the measure field, then select Create and then click on Calculated Field.
Then, an edit dialog box will open where we define the condition for our field and click on Apply. Here, we enter –[Profit] that is, negative of profit field values. Also, we named the new field as “Waterfall sizing”. You can add a name and condition as per your requirement and liking.
Step 4: Create Waterfall Bars
Step 5: Add Duplicate Measure to Duplicate the Chart
We can also increase or decrease the thickness of the Gantt bars through Size card. Now, we have two plots sharing the same x-axis and two duplicated y-axis. All we need to do next is to combine or merge these two plots into one.
Step 6: Merge the Two Plots into One
Step 7: Waterfall Chart Showing Positive and Negative Profit
In this way, our waterfall chart showing brand-wise profits incurred from the sales of electronic items is ready. On the right, there is a reference bar showing the color gradient for-profit values. As you can see, it goes from being orange to dark blue showing a negative profit to positive profit.
This concludes our tutorial on Tableau waterfall charts. Here, we learned the definition and use of a waterfall chart in analysis and then saw how to create a waterfall chart in Tableau.
Now!! This is the right moment to find out the hidden trend of your data with Tableau Scatter Plot.
We hope that our tableau waterfall chart article was helpful and easy to understand. If you have any queries regarding this article, mention your queries in the comment section. We will be happy to help you.