Skip to content

PLOTTED DATA

To plot, simply hit the 🚀 Submit button once the data is loaded.

SELECT DATA TO PLOT

You can choose to plot your data in several ways. See the corresponding sections for more details on each plot type.

The Plot Type menu will only show the plots that can be run with your specific dataset. For instance the "Timeline" plot option will only be shown if the dataset has a Date column.

image-20210325100420391

You can choose whether to plot the data of the whole dataset or a slice corresponding to a result row of your 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.

image-20210422183506398

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

image-20210325112512652

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.

image-20210325113010051

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.

OTHER OPTIONS

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

Two additional options are available for selection.

image-20210325101105384

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.

image-20210325101921094