Skip to content

ALTERNATIVE COMBINATIONS PLOT

The alternative combinations plot shows, for each dimension of a given row result, the variance value that would result by changing the filter on that one dimension. This is useful to visualize the impact of each item on variance.

The size of the bubbles is proportional to the average monetary amount in the two periods. Hover on the bubbles to see the alternate combinations.

PLOT EXAMPLE

Our Variable Dimension Bridge report returned the following chart.

waterfall (2)

image-20220329142226169

Select "row 1" in the Data to Plot widget, "alternative combinations" in the Plot Type widget. This chart is returned. The column of bubbles on the right, at the 78kvariance value, corresponds to the selected combination (in this case Product => "All", Country => "UK", Product_Group => "Baby Food").

alternativeCombinations (1)

The bubble top far left (Product row) of the chart indicates what variance would be if we changed the Product from "All" to "Product 1" and left all other dimensions untouched.

Variance would then be about 20k.

alternativeCombinations (1)

SAVING THE PLOT

To save the plot as a PNG file, click on the small camera icon, and select "download as PNG".

image-20220329143040900

EDIT AND MOVE LABELS

You can edit and move around plot titles and labels. In this chart..

alternativeCombinations (2)

...you can move the value labels around, delete them and adjust their position.

alternativeCombinations (3)

ANNOTATE CHARTS

It is possible to annotate charts with lines, rectangles and circles. It is possible to modify the shapes and move them around, and delete them.

Hover and click on the "draw line", "draw circle" and "draw rectangle" icons on the menu bar on the upper right of the chart.

image-20220329143338457

Draw and edit your shapes.

alternativeCombinations (4)

ADD PLOT MESSAGE

It is possible to add a message to the chart.

Add your message, one chart at a time, to the text box.

image-20220329143606500

Once you have finished writing the message for a chart, click on the 🚀 Submit.

Your message will appear above the chart title.

image-20220329143710172

The downloaded image of the chart contains the message.

image-20220329143736652

CHART TITLE

The chart title is set on three lines: the first line contains the reporting unit ("who"), the second line the business metric ("what") and the third line the time period ("when").

You can adjust the position of the title, the message text and the horizontal line by moving them around with the mouse.

alternativeCombinations