Waterfall

Waterfall visuals are based on at least one time attribute and one or multiple metrics, and can incorporate positive and negative values. You can include a reference line, grid lines, and a Totals bar. Waterfall visuals with multiple metrics are supported by all Composer data connectors.

This topic describes:

• Configure Settings for a Waterfall Visual

• Configure Colors for a Waterfall Visual

• Multiple Metrics in a Waterfall Visual

For information on setting even time intervals, see Even Time Intervals.

Configure Settings for a Waterfall Visual

Change the settings for a waterfall visual

1. Edit the waterfall visual you want to modify. See Edit Visuals.

2. If you are editing the visual in a dashboard, select Settings from the visual drop-down menu. The sidebar menu for the visual appears.

   If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

3. Select the settings icon () on the sidebar menu. The Waterfall Settings sidebar for the visual appears.

   

4. Alter the settings as needed:

   Setting	Description
   Horizontal Scroll, Vertical Scroll	Select to enable users to scroll and zoom data for this visual. Other settings you define for this visual may limit the availability of this option.
   Show Metric Labels	Enable to show the field names as labels in the visual. Disable to hide the field names.
   Absolute Value	Enable to show the absolute value represented by each waterfall bar. Disable to hide the absolute value.
   Show Total	Enable to show a total representation of all information included in the waterfall bars.
   Label	By default, the Label for total is Total; change as needed.
   Bar Thickness	Adjust the thickness of the bars in your visual as needed.

5. Optionally, edit the number or date and time format for this visual. See Configure Number Formatting for Visuals and Configure Date and Time Formatting for Visuals.

6. Select the save icon () to save the visual, or dashboard and the visual with updated settings.

Configure Colors for a Waterfall Visual

Specify the color settings for a Waterfall Visual using the Color sidebar

1. Edit the visual you want to modify. See Edit Visuals.

2. If you are editing the visual in a dashboard, select Settings from the visual drop-down menu. The sidebar menu for the visual appears. If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

   Select the color icon () on the sidebar menu. The Color sidebar for the visual appears.

3. Configure the color settings as described below. As you change the color settings, the legend at the top of the Color sidebar shows how the legend will appear on the visual. Supported color specifications are described in Specify Colors.

   Setting	Description
   Legend	Enable or disable to display a dynamic legend in this visual. Dynamic legends allow you to temporarily add or remove data shown in the visual. For distinct color styles, select a data point in the legend to turn it off and on in the visual. For gradient color styles, use the legend’s gradient slider to show and hide your data. Use the color selector to manually assign colors for legend items. If available, enable or disable a static legend for this visual.
   Color	Manually select the colors for each metric using the color selector. Visuals that incorporate positive and negative values displays color options paired as <field> and <field> (Negative). Options include Select individual colors to choose a custom color for any or all metrics. Custom colors are listed by metric in the Assigned Colors work area. Select Reset Colors in the Assigned Colors work area to revert your colors to their previous saved state.
   Total Color	Manually select a color for the Total using the color selector, or select the Inherit from theme checkbox to use the color palette specified by the theme.
   <type> Color Palette	Select a color palette for this specific visual. Select the Inherit from theme checkbox to use the color palette specified by the theme.

4. Close the Color sidebar and the color settings are dynamically applied to the visual.

5. Select the save icon () to save the dashboard and the visual with its updated settings.

Multiple Metrics in a Waterfall Visual

If you use multiple metrics in your waterfall visual, you can control the order in which the metrics appear in the waterfall. Add one or more metrics to the Y axis in the order you'd like them to appear. The first one you add will be the left most metric, and subsequent metrics will appear to the right of existing metrics.