The box plot is a statistical representation of the distribution of a variable through its quartiles. The ends of the box represent the lower and upper quartiles, while the median (second quartile) is marked by a line inside the box.
For reasons of performance, the dataset can be sampled down if it is larger that a set number of rows.
The sampling is required to preserve performance and brings all dataset down to a set number of rows. If your dataset is very large, this could limit the significance of the distribution plots.
To preserve performance, only one dimension will be plotted at a time. You can choose which dimension to plot with this widget.
In accordance to the IBCS standard notation the most recent, measured, Actual data is plotted dark grew while the past (example previous year) data is plotted light grey. Plan data is also plotted light gray (instead of white boxed) due to technical limitations.
The plot is run at the total plotted data level.
A plot is also run for each item of the chosen dimension.
By clicking on a legend value you can filter that value on the boxplot.
SAVING THE PLOT
To save the plot as a PNG file, hover and click on the small camera icon on the top left side of the chart.
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
CHOOSE DIMENSION TO PLOT
Select the dimension to plot by item.
NUMBER OF TOP ITEMS
You can change the number of top items, and you can choose not to plot the value of the other aggregated items.
The above settings will return a plot that looks like this.
EDIT AND MOVE LABELS
You can edit and move around plot titles and labels. In this chart..
...click on the titles and labels to, for example, change the title from bold to italic (change HTML tags from H-tab to I-tag), or move around and change the values of the labels and legends
It is possible to annotate charts with lines, rectangles and circles. It is possible to modify the shapes and move them around. For the moment it is not possible to delete the shapes you have added.
Hover and click on the "draw line", "draw circle" and "draw rectangle" icons on the menu bar on the upper right of the chart.
Draw and edit your shapes.
ENABLE PLOT MESSAGE
It is possible to add messages to the chart, in the style suggested by the IBCS standard.
Enable messages by setting the "enable plot messages" widget to True.
You can find the "enable plot messages" checkbox in the Run widget expander.
Hit the Submit button.
A text box will appear above each chart.
Add your message, one chart at a time.
Once you have finished writing the message for a chart, click on the 🚀 Submit button.
Your message will appear above the chart title
Now write another message on the text box of a different chart.
Click submit. Your second message appears above the second chart.
Try adding a shape. Download the image. The downloaded png of the chart contains the message and the shape.