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 specifying 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:
To create a waterfall chart:
- Click Edit In Place .
- Expand the Data Components section (in left pane) and browse for the metric on which to create the dial. For example, select Revenue.
- Drag and drop the metric on to the dashboard. The Create New... dialog appears.
- Click the Waterfall Chart template and enter Revenue Variance for the name.
- Choose to save the dial to your Personal Dials folder (this is the default).
- Click Create. By default the chart is displayed with Account/Metric as the Breakdown:
To define a waterfall chart:
- With the dial selected, click Data Settings from the Editors section (in left pane).
- 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 reference for the waterfall. In this example, Revenue is the default source reference.
- With Revenue selected as the series, change the name and short name to Revenue.
- Click Apply.
To define the scope of the waterfall analysis:
- With the dial selected, click Waterfall Settings<</strong> from the Editors section (in left pane).
- From the Waterfall tab, choose Time as the breakdown and allow up to 12 data points.
- 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:
- Choose a version for last year’s approved budget.
- Choose the Current time period and choose Year.
- Keep the remaining defaults for Time Breakdown and Data Range.
From the Comparison Value tab, choose Actuals for the version. Keep all other defaults.
From the Appearance tab, change the look of the chart.
Make the following changes to the appearance:
- Choose Preset 01. If your Discovery Admin configured a custom theme, the colors from this preset are from the custom theme.
- Choose to display the Short Name for the reference and comparison labels.
- If data labels are missing, type a custom label: TBD
- Choose DarkGreen as the positive variance color and DarkRed as the negative.
- Click Apply.
Your dial is ready for use.