May 26, 2021 Tableau
Waterfall charts effectively show the cumulative effects of continuous positive and negative values. /b10> It shows the beginning, end, and how incremental it is. /b11> As a result, we can see the difference in size and value of changes between continuous data points.
Tableau
needs a dimension and a measure to create a waterfall map.
With
Sample-superstore
we plan to find Sales variants of
Products
for each
Sales
/b10>
To achieve this, we follow these steps.
Drag dimension subcategories to the column frame and measure sales to the shelf. /b10> Sort the data in ascending order of sales value. /b11> For this use the sort option appears in the middle of the vertical axis when you hover over it. /b12> When this step is complete, the following chart is displayed.
Next, right-click
SUM(Sales)
value, and then select running total from the table
running total
/b10>
Change the chart type to
Gantt
bar.
/b11>
The following image appears.
Create a
-sales
and provide the following formula for its value.
Drag the newly created
(-sales)
to the size field under Marker Card.
/b10>
The chart above is now changed to produce the following chart is a waterfall chart.
Next, we can give the bars in the chart a different shade of color by dragging the sales measure to the color shelf under the marker card. /b10> We get the color waterfall map below.