Performing a 'what if' analysis with global variables

Follow

Global variables enable you to model a 'what if?' analysis on the dashboard. With the calculation engine, it is very easy for the analyst to set up a calculated metric that weighs/changes/forecasts an existing metric.

This article contains the following sections:

Creating a global variable

When you create a new global variable, you must write formulas using BIME's calculation engine. If you are unfamiliar with writing formulas in BIME, see Formula writing rules reference.

To create a global variable
  1. In the Query Builder, click the Calculation engine icon ().
  2. Select the Global variable option.
  3. Type a name for your global variable.
  4. Enter maximum, minimum, and default values. For example values see, Types of global variables.

  5. Click Save when finished
    Note: You will not be able to access your global variable until you create a calculation.
  6. In the Calculation engine menu, select any option.
  7. Select your global variable from the Select a field drop-down list.
  8. Enter your formula.

  9. Click Save to finish your calculated metric or attribute.
  10. Add your calculated metric or attribute to the frame by clicking the + button. Once you add your global variable to the frame, it will automatically be added to the Filters bar.

Adjusting global variable values

While you cannot edit the minimum or maximum values, you can adjust the default value.

To adjust the default value

  1. Click on the global variable filter on the Filters bar. The global variable menu will open automatically.
  2. You can also access the global variable in the Result manipulation menu ().
  3. Drag the circle across the bar to increase or decrease the default value. You can also type a new value in the box underneath the bar.

  4. Click Apply when finished.

Your value is now adjusted.

Types of global variables

Global variables can either be a numeric or percentage multiplier. Both types of multipliers serve different purposes when calculating a 'what if' analysis.

Numeric multiplier

A numeric multiplier models actual changes in a metric. For example, what if the price per gallon goes from $x to $y? Or what if the retail price index drops from $x.xx to $y.yy?

In this case, the default value should be the current result, and the minimum and maximum set to cover both the worst and best case scenarios.

Percentage multiplier

A percentage multiplier is used to model the percentage change of a metric. For example, what if postage costs go up 25%? Or what if your available staff reduces by 10%?

When using a percentage multiplier, the default value should be one, so the initial number is displayed correctly. The minimum and maximum can be whatever is necessary, as long as the values are integers.

Have more questions? Submit a request

1 Comments

  • 1

    Trying to do this for a percentage and it doesn't work as shown.  I can't get an integer in the slider and the there doesn't seem to be any input field that is shown in the global variable screenshot.  Does anybody have any examples of this working?

Please sign in to leave a comment.
Powered by Zendesk