KB263579:How to design and implement a Boxplot in MicroStrategy 9.x and 10.x?

Overview 
A Boxplot (sometimes called a box and whisker plot) is a graph type designed to compare similar distributions at a glance. The goal of Boxplot graphs is to make the center, spread, and overall range of values immediately apparent. The Boxplot is useful for isolating the extreme values and identifying the range of middle values in your data. The box shows the median values of a variable, while the whiskers stretch to the greatest and lowest values of that variable. Boxplots can also help you identify symmetrical or skewed distributions among values. This technical note describes the details steps to implement the Boxplot in Strategy.
 
 Requirements
 Five metrics holding the following values must appear on the report template in the following order:

• Minimum value: The smallest observed value. In Strategy graphs, this is depicted as a whisker on the bottom of a column.
• Lower quartile or 25th percentile: The median of the lower half of the data.
• Median: The middle of the data when it is arranged in order from least to greatest.
• Upper quartile or 75th percentile: The median of the upper half of the data.
• Maximum value: The largest observed value. In Strategy

 
Object Design
 Each metric could be defined as follows, and the metric level needs to be defined if necessary.

• Minimum value: Min(fact)
• Lower quartile or 25th percentile: Percentile(fact, 0.25)
• Median: Median(fact)
• Upper quartile or 75th percentile: Percentile(fact, 0.75)
• Maximum value: Max(fact)

 
 
Demonstration
 The screenshots below display the definition for the first quartile, a Boxplot against the Category attribute, and the preference.