Show Menu
TOPICS×

Create a metric indicator

You can use worksheets to indicate that a metric has reached a defined threshold.
In addition, you can use Report to automatically generate and distribute a report when a metric reaches a defined threshold within a specified time frame.
For more information about Report, see the Data Workbench Report Guide .
To create a metric indicator using a worksheet
  1. Define the contents of the cells of the worksheet.
    1. In Column A, enter the name of the desired metric (for example, Visitors).
    2. In Column B, enter the value of the desired metric (for example, =Visitors).
    3. In Column C, enter the low threshold of the metric.
    4. In Column D, enter the high threshold of the metric.
    5. In Column E, enter an appropriate formula. For examples, see Up or Down Indicator or Check Indicator .
    6. In the formula cell (Column E), right-click and click Format > Indicator , then click one of the following:
      • None : Lists the exact calculation instead of an indicator.
      • Check : Uses a check mark or an X to indicate that the value is either above or below the threshold you set, depending on your formula. See Check Indicator .
      • Up or Down : Uses an up or down arrow to indicate whether the value is below the low threshold (down arrow), above the high threshold (up arrow), or between the low and high thresholds (blank). See Up or Down Indicator .
  2. Repeat Step 1 for other metrics for which you want to create indicators.
The resulting worksheet would look something like the following example:

Up or down indicator

For the Up or Down indicator, use the following formula:
(metric value - low threshold)/(high threshold - low threshold)*2 - 1
For example: =(b2-c2)/(d2-c2)*2-1
Three outcomes are possible for each metric when using this formula with the Up or Down indicator:
  • If the metric value is between the low and high thresholds, the formula evaluates to a number between -1 and 1 (exclusively). The up or down arrow does not display in the worksheet.
  • If the metric value is less than or equal to the low threshold, the formula evaluates to a value less than or equal to -1. The metric indicator changes to a down arrow.
  • If the metric value is greater than or equal to the high threshold, the formula evaluates to a number greater than or equal to 1. The metric indicator changes to an up arrow.
The following worksheet illustrates what the example formula =(b2-c2)/(d2-c2)*2-1 would display:

Check indicator

For the Check indicator, you use a formula that indicates whether you want to be notified when the metric value is above or below the threshold you specify. For example:
  • If you want to be notified when the value is below the threshold you set, you could use the following format:
    • threshold - metric
      For example: =(c2-b2)
  • If you want to be notified when the value is above the threshold you set, you could use the following formula:
    • metric - threshold
      For example: =(b3-c3)
When a check mark displays, the formula evaluated to a positive number. When an X displays, the formula evaluated to a negative number.
There are two possible outcomes for each metric when using the Check indicator:
  • If the formula indicates that keeping the metric value above the threshold is desirable, a check mark displays when the metric value is greater than or equal to the threshold, and an X displays when the value is less than the threshold.
  • If the formula indicates that keeping the metric value below the threshold is desirable, a check mark displays when the metric value is less than or equal to the threshold, and an X displays when the value is greater than the threshold.
The following worksheet illustrates what the example formulas =(c2-b2) and =(b3-c3) would display: