The box & whisker plot, or box plot, widget is a convenient way of visually describing the distribution, variability, and center of a data set along an axis.

Box plots are divided into four quartiles. The middle quartiles are represented by a box that contains 50% of the data and the median value. The upper and lower quartiles contain the maximum and minimum values and the remaining 50% of the data. These quartiles are represented by lines called whiskers.

The maximum and minimum values can be adjusted when defining your box plot. By default, these values are within 1.5 times of the IQR (Interquartile Range), however you can set them to the actual maximum and minimum values or to within one standard deviation of the mean of your data.

boxplot

Box plots divide five descriptive statistics into four equal quartiles. You can view these statistics by hovering over the box plot.

boxvalues

Installing the Box Plot Widget

  1. Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. After those files have been unzipped there, you may also have to restart the web server.
  2. Create a new widget. The Box & Whisker Plot chart is displayed in the list of options.
    boxwhisker
  3. Select the Box & Whisker Plot chart from the chart types menu.
  4. Click Create. The widget is added to the dashboard.

Adding Data

  1. In the X-AXIS panel, click ADD + to select the field whose values will be placed on the X-AXIS. The X-AXIS of a box plot is used to represent numeric data.
  2. In the Values panel, click ADD + to select

Design the Box Plot

Fine tune the appearance of the box plot widget with the following tools.

  • WHISKER VALUES: Defines how the whiskers are calculated and displayed.
    • IQR (Interquartile Range): Default setting. The whisker values are calculated within 1.5 times the IQR (the difference between the 1st and 3rd quartiles).
    • Extremums: The whiskers values include the maximum and minimum values in the calculation.
    • Standard Deviation: The whisker values are calculated to one standard deviation above and below the mean of the data.
  • BOX: Specify whether to display a full or hollow box.
  • VALUE LABELS: Specify whether to show or hide labels indicating the values of each point (circle). Select the orientation of these labels: Horizontal (Default), Diagonal or Vertical.
  • LEGEND: Specify whether to show or hide the LEGEND, and select its position.
  • SHOW OUTLIERS: Specify whether to show or hide labels indicating the values of each point (circle). Select the orientation of these labels: Horizontal (Default), Diagonal or Vertical.
  • X-AXIS and Y-AXIS:
    • Grid Lines: Shows (Default) / hides.
    • Labels: Shows (Default) / hides.
    • Title: Select the checkbox to display the axis title. To edit the title, type in a new title. Click outside the text box to apply the new value. To change the default minimum, maximum or interval values on the axis, type in the new values, and click outside the text boxes to apply the new values.
    • Values on Axis: To restore any of the values to their default states, click on the reset button.
  • Auto Zoom: When a widget contains more data than can comfortably be displayed in one view, Auto Zoom will resize the chart to include more data, and in some cases adds a zoom bar under the widget. The zoom bar enables you to scroll right and left and to zoom in/out of different parts of the width of the widget.