Format
Format aggregation and total
Aggregate first category to a total
Total your first category by aggregating. This will give you your starting point to run through the series. This could be the total of the previous years sales to then compare to the current year. If you want to just see the progressive sales from the start, show all values with a separate total.
Show cumulative values
Here you have the options to show cumulative values of your dimension through your series of dimensions or to compare the values in the series to the previous category. You may need insight over one series of which products or departments are performing well or may need to see how those performed compared to the series before. Both possible here.
Options for totals
Choose how totals are displayed in the Waterfall chart.
Show total at the end of every category Displays a total bar after each category in the Waterfall chart.
No, show no totals Hides all total bars from the Waterfall chart.
Choose which categories show totals Allows you to select specific categories where a total bar should be displayed. When this option is selected, the Categories with totals list appears. Select the categories that should include a total bar.
Y-Axis min (%)
Y-Axis Min (%) – if set, the minimum value of the y-axis will be set from the specified percentage of the first category (first bar in the chart).. Configuring the Y axis to start at your specified level will allow you to focus on each value of your Waterfall Chart.
Bar width
Use this setting to make the bars narrower or wider to improve readability and fit the chart layout.
Show labels/X-axis/Y-axis
Show or hide your measure labels in your viz. Turn off the X and Y axis too.
Show growth percentages
A very useful feature of the Waterfall Chart is the growth percentages shown at the top of each dimension. Each is This can be shown or hidden if you just want the bar charts to show you the differences.
Rotate X-axis label
Use the scroll bar to rotate the labels of your dimensions. Get your waterfall chart looking just how you want it.
X-axis & Y-axis spacing
Condense or spread out the waterfall chart for a clearer chart or to save that valuable dashboard space
Last updated
Was this helpful?