可以使用工作表来指示量度已达到定义的阈值。
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.
使用工作表创建量度指示器
定义工作表单元格的内容。
In Column A, enter the name of the desired metric (for example, Visitors).
In Column B, enter the value of the desired metric (for example, =Visitors).
在 C 列中,输入该量度的低阈值。
在 D 列中,输入该量度的高阈值。
在 E 列中,输入适当的公式。有关示例,请参阅向上箭头或向下箭头指示器或检查指示器。
In the formula cell (Column E), right-click and click Format > Indicator, then click one of the following:
对要为其创建指示器的其他量度重复步骤 1。
所得到的工作表将如以下示例所示:
对于或 Up ,请使 Down indicator用以下公式:
(metric value - low threshold)/(high threshold - low threshold)*2 - 1
例如:=(b2-c2)/(d2-c2)*2-1
Three outcomes are possible for each metric when using this formula with the Up or Down indicator:
The following worksheet illustrates what the example formula =(b2-c2)/(d2-c2)*2-1 would display:
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. 例如:
如果您希望在该值低于您设置的阈值时通知您,则可以使用以下格式:
threshold - metric
例如:=(c2-b2)
如果您希望在该值高于您设置的阈值时通知您,则可以使用以下公式:
metric - threshold
例如:=(b3-c3)
当显示复选标记时,该公式的计算结果为正数。当显示 X 时,该公式的计算结果为负数。
There are two possible outcomes for each metric when using the Check indicator:
The following worksheet illustrates what the example formulas =(c2-b2) and =(b3-c3) would display: