Difference between revisions of "Message Charts"

(Business Scenario)
(Redirected page to Business Charts)
(Tag: New redirect)
 
(13 intermediate revisions by one other user not shown)
Line 1: Line 1:
<span id="Variance" />
+
#REDIRECT [[Business Charts]]
== Absolute Variance ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| style="width:305px" | [[File:MC_Variance.png|thumb|left]] || Displays the variance between two values, often between the budget and actual values.
 
|}
 
 
 
<span id="VariancePercentLolliplot" />
 
== Relative Variance (%) ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| Displays the relative variance between two values. || style="width:305px" | [[File:MC_VariancePercentLolliplot.png|thumb|left]]
 
|}
 
 
 
<span id="ValuesWithVarianceOffsetBar" />
 
== Integrated Variance ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| style="width:305px" | [[File:MC_ValuesWithVarianceOffsetBar.png|thumb|left]] || Shows the actual and variance in the same chart with colour indicating the direction of the variance.
 
|}
 
 
 
<span id="ValuesWithVarianceArrow" />
 
 
 
== Indicator Comparison ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| Shows actual and target values in one chart. The arrow position and colour indicate the target value and direction of the variance. || style="width:305px" | [[File:MC_ValuesWithVarianceArrow.png|thumb|left]]
 
|}
 
 
 
<span id="ValuesCompare" />
 
 
 
== Offset Comparison ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| style="width:305px" | [[File:MC_ValuesCompare.png|thumb|left]] || Shows actual and target values in one chart. The actuals are prominent while the target values can still be referred to.
 
|}
 
 
 
<span id="ValuesWithForecastTwoColumns" />
 
 
 
== Business Scenario ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| Shows actual and forecats values in one series. By default the actual values are used where available otherwise the forecast is show, however you can specify the first forecast member to override this behaviour. || style="width:305px" | [[File:MC_ValuesWithForecastTwoColumns.png|thumb|left]]
 
|}
 
 
 
<span id="Waterfall" />
 
 
 
== Waterfall ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| style="width:305px" | [[File:MC_Waterfall.png|thumb|left]] || description
 
|}
 
 
 
<span id="WaterfallPeriodComparison" />
 
== Variance Waterfall ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| description || style="width:305px" | [[File:MC_WaterfallPeriodComparison.png|thumb|left]]
 
|}
 
 
 
====Outputting cells====
 
If you have split by a different category hierarchy and want to output the category to excel then you can pick a range of two cells to put the values in. The first will contain the date member, the second the split-by member.
 
 
 
<span id="ValuesCompareLines" />
 
== Trend Comparison ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| style="width:305px" | [[File:MC_ValuesCompareLines.png|thumb|left]] || description
 
|}
 
 
 
<span id="ValuesCompareLinesCumulative" />
 
== Trend Comparison (Cumulative) ==
 
 
 
{| style="width:100%"
 
|- style="vertical-align:top;"
 
| description || style="width:305px" | [[File:MC_ValuesCompareLinesCumulative.png|thumb|left]]
 
|}
 

Latest revision as of 14:34, 6 July 2020

Redirect to: