Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Variance Waterfall Chart

Version: DiscoveryClassic  

Explains how to create a variance waterfall chart using Discovery Classic

Use a waterfall chart to visually represent data that shows where you started, where you ended, and how you got there. You can configure a waterfall chart in Discovery by specify­ing a start value (reference value) and an end value (comparison value) and the waterfall steps.

You can base waterfall steps on time, dimension, attributes, or sub-accounts (child accounts). Variance can be configured to compare different versions.

 

The following chart is an example of revenue variance by time:

Example Variance Waterfall Chart

To create a waterfall chart:

  1. Click Edit In Place .
  2. Expand the Data Components section (in left pane) and browse for the metric on which to create the dial. For example, select Revenue.
    Pane for Selecting Waterfall Dial
  3. Drag and drop the metric on to the dashboard. The Create New... dialog appears.
  4. Click the Waterfall Chart template and enter Revenue Variance for the name.
  5. Choose to save the dial to your Personal Dials folder (this is the default).
  6. Click Create. By default the chart is displayed with Account/Metric as the Break­down:

To define a waterfall chart:

  1. With the dial selected, click Data Settings from the Editors section (in left pane).

    Waterfall Data Settings Editor

  2. Optionally add another set of data. The metric is added to the Select series pane. If you have several data series, the series listed at the top becomes the source refer­ence for the waterfall. In this example, Revenue is the default source reference.
  3. With Revenue selected as the series, change the name and short name to Reve­nue.
  4. Click Apply.

To define the scope of the waterfall analysis:

  1. With the dial selected, click Waterfall Settings<</strong> from the Editors section (in left pane).

    Waterfall Settings Editor

  2. From the Waterfall tab, choose Time as the breakdown and allow up to 12 data points.
  3. From the Reference Value tab, you can configure the reference value by specifying the version, time period, time offset and time breakdown, and data range. The data source defaults to the first data series listed in the Data Settings Editor:

    Waterfall Settings Editor - Select the Reference Value

  1. Choose a version for last year’s approved budget.
  2. Choose the Current time period and choose Year.
  3. Keep the remaining defaults for Time Breakdown and Data Range.
  4. From the Comparison Value tab, choose Actuals for the version. Keep all other defaults.

    Waterfall Settings - Select Comparison Value

  5. From the Appearance tab, change the look of the chart.

    Waterfall Settings - Update the Appearance

Make the following changes to the appearance:

  1. Choose Preset 01. If your Discovery Admin configured a custom theme, the col­ors from this preset are from the custom theme.
  2. Choose to display the Short Name for the reference and comparison labels.
  3. If data labels are missing, type a custom label: TBD
  4. Choose DarkGreen as the positive variance color and DarkRed as the negative.
  5. Click Apply.

Your dial is ready for use.

  • Was this article helpful?