¶ DownTime Statistics Formulas
¶ WaterFallBase:
WaterFallBase must return a numeric base value for each calculated group. The group values are summed for the waterfall diagram. For time losses this sum is the end point; for volume losses it is the start point. There are no declared Argument_... variables. Both WaterFallBase and WaterFallProduction require valid formulas; if their resulting sum is zero, the waterfall is not drawn.
¶ WaterFallProduction:
WaterFallProduction must return the numeric production time or production amount for each calculated group, according to the statistic type. The group values are summed for the waterfall diagram. For time losses this sum is the start point; for volume losses it is the end point. There are no declared Argument_... variables. Both waterfall formulas must be valid, and a zero resulting sum prevents drawing the waterfall.
¶ TotalSum
TotalSum must return a numeric value for every calculated group. Each result is added to the special total. That total can be displayed in the statistics and used as the base of percentage calculations. There are no declared Argument_... variables. NULL or non-numeric results have no dedicated validation before the value is added, therefore formulas should always return a numeric value.
¶ XValue
When aggregating, the formula specified the place of the values (value packages) on the X (horizontal) Axis.
Aggregated values are available for the calculation.
¶ User Calculations
It is allowed to specify extra calculations for each Aggregation subsets, to show additional information for the Statistics.