KB43047: New Budgeting Graphs in MicroStrategy Web 9.3.1 and up

 
In Strategy Web 9.3.1 and up, a new Graph Type has been introduced called Budgeting graphs. This Graph Type consists of the following four SubTypes:

• Horizontal LipStick
• Vertical LipStick
• Horizontal Overlapping Bars
• Vertical Overlapping Bars

The purpose of this Graph Type is to analyze ‘actual’ versus ‘expected’ values. The Lipstick and Overlapping Subtypes only provide slightly different methods of viewing this data.
Dataset template requirements:

• At least one attribute on the rows (create x-axis)
• At least two metrics on the columns (create the series)
  
• The first metric represents the Actual Value
• The second metric represents the Target Value
• Additional metric/series are rendered as lines
• (Optional) Attributes can be placed on the columns

In the following example, the gray bar is for the actual recorded value and the "expected" or "targeted" is represented by additional red/green bars. When the expected value exceeds the actual value, this additional bar is placed on top of the actual value bar, where the additional bar totals the difference between expected and actual. If the actual value exceeds the expected value, the additional bar resides within the actual value bar.
 
Lipstick Graph

For the Overlapping Graph, the "actual" metric value is displayed as the gray bar and the "expected" or "targeted" value is displayed behind and overlapped by the corresponding "actual" metric:
 
Overlapping Graph