KB42217: What metrics are used for the sparkline, bar chart, and chart on a Microchart in MicroStrategy Web 9.2.x and 9.3.x?

When using a Microchart, the location of the metrics in the grid will determine exactly what they are used for in each type of Microchart.  See the chart below for an explanation on each type of Microchart and the metrics used.
 

 
 
Any additional metrics are displayed in the columns.
 
Example:
 
For the following grid using 9 metrics, the below Microchart will be displayed.
 

 
Sparkline:

• The black line displays the Open cases per region, i.e. the first metric on the grid.
• The blue line is the reference line for Average Open Cases; this is the second metric on the grid.

Bar Chart:

• The black line displays the Open cases per region, i.e. also the first metric on the grid.
• The blue line is the reference line for Average Open Cases; this is also the second metric on the grid.

Bullet:

• The performance measure bar, shown in orange, is represented by the third metric, Closed Cases.
  
• The right-most boundary of the first color band is represented by the fifth metric, Low closed cases.
  
• The right-most boundary of the second color band is represented by the sixth metric, Mid closed cases.
  
• The the right-most boundary of the third color band is represented by the fourth metric, Max Closed Cases.
  
• The vertical reference line, shown in dark blue, is represented by the seventh metric, typically the target value, in this case, Target Closed Cases.
  

The eighth and ninth metrics, New Cases and Change in New Cases, display just as columns.
 
Note:
Users cannot specify which metrics are used for each concept in the Microchart.  An enhancement has been logged to decouple the metric association between sparkline and bar chart so that different metrics can be displayed in each. 
 
Contact Strategy Technical Support for an update on the enhancement request.