If you are calculating variable dimension variance, you can choose whether to plot the other plots using the whole dataset or a slice of date corresponding to a result row of your variable dimension variance report.

In the example below, setting the drop down to "row 1" plots the data corresponding to the first row result below, the one that shows a significant positive variance for all sales of "Black" hair products. Setting to "entire dataset" plots the entire dataset.


If you are plotting a Fix Dimension Bridge and you have selected a dimension along which to plot Small Multiples...


You get a plot like this with two sub plots.

waterfall (27)

The "Data to Plot" menu will show the option to either plot the whole dataset, or to choose a specific row.


The row number corresponds to the plot number. For example in this case, if you choose row 1, only Black hair color data will be plotted, while if you choose row 2, Blonde hair color data will be plotted. Choosing row 3 to 5 will be forced to 2 and will return Blonde hair color data.

Open the expander under the "Data to Plot" drop down menu by clicking on the ➕ sign.

Two additional options are available for selection.


The "Plot non filtered amount" widget allows you to choose - if you have decided to plot a specific result row - whether to plot the data of that row filtered (aka net) of the results of the preceding rows, or to plot the original data of that row before filtering.

In the example above, if you selected to plot the second row, the "non filtered" option will show also Black Permanent products bought in Pharmacies, while the "filtered" option will, well, filter the Black products out, since they are already accounted for in the first row.

The Prepare Download File options prepares a CSV file with the data used for plotting for download. This might take a while.

To actually download the file you need to run the plot (hit the 🚀 Submit button) and open the Download Report and Plotting Data expander. Click on the link to get the file.