Option |
Description |
Orientation |
|
Vertical
|
Use this option to display the bars and blocks vertically in the visualization. |
Horizontal
|
Use this option to display the bars and blocks horizontally in the visualization. |
Show one waterfall |
|
Over all category and color axis values |
Use this option to show all bars and blocks in a single waterfall. This is the default setting. An example is shown below. |
Per categorical color |
[Applicable to categorically colored waterfall charts.] Use this option to show separate waterfalls per categorical value on the Color axis. The result of selecting this option in the waterfall chart above is shown below.
|
Per value on category axis |
[Applicable to categorically colored waterfall charts.] Use this option to show separate waterfalls per value on the Category axis. The result of selecting this option in any of the waterfall charts above is shown below. |
Continue over trellis
|
[Applicable to trellised waterfall charts.] Select this check box if you want the waterfall to continue over multiple trellis panels. That is, the first value in the next trellis panel will start where the last value ended in the previous panel. Clear the check box to show one waterfall per trellis panel. In this case, the first value in each trellis panel will be a bar starting from zero. You can click the arrow to select over which individual panels the waterfall should continue: Pages, Panels, Rows and Columns. The example below shows a trellised waterfall chart, where the waterfall does not continue over trellis. The result of changing this visualization to a waterfall that continues over trellis is shown below. |
Bar and block width |
Drag the slider to modify the width of the bars and blocks. |
Transparency |
Drag the slider to change the transparency of the bars and blocks. This makes it possible to see lines or curves that are placed in the background through these items. |
Show lines that connect bars and blocks |
Select this check box to add transition lines between the bars and blocks. |
Color
|
In the Color palette, specify the color of the transition lines. |
Use separate color for marked items |
Select this check box to use the specified marking color to distinguish marked items in this visualization. If the check box is cleared, then unmarked items will be faded out instead, and the original color will be kept for the marked items. See Marking in Visualizations for more information. |
Sorting
|
[Applicable to waterfall charts with a categorical coloring.] |
Sort blocks within each category axis value |
Sorts the blocks within a value on the category axis by size. The block representing the highest value in the category is placed first in the waterfall, and the lowest value at the end. |
Reverse block order |
Reverses the current order of the blocks, that is, the block currently placed first in the category will be placed last, the second-first will be placed second-last, and so on. |
Time
series |
|
Compensate
for missing values |
Select this check box if you are using a Date, Time or DateTime column somewhere in the visualization and you need to perform some calculation where a required time period is missing. For example, if you have created a visualization and there are missing data for some categories, selecting this check box will produce a block of the same size as the previous block instead of showing no block at all. See Working With Time Hierarchies for more information. Enabling this setting will temporarily add new rows with empty values for the missing periods so that they can be used in the calculation. |