Description
Check supplied event membership in a half-open rolling window.
Business metrics depend on event definitions, time windows, revenue and cost bases, and reporting scope. Observed sales during stockout do not by themselves verify latent demand, while a return contribution depends on which costs were already recognized. Local flags and signed balances are not a complete profitability or causal analysis.
Check supplied event membership in a half-open rolling window.
When to use this tool
Use Rolling Metric Window Boundary when you already have eventTime, windowEnd, windowWidth and need to check supplied event membership in a half-open rolling window.
How to use the tool and how it works
- Enter eventTime, windowEnd, windowWidth. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read included, lowerInclusive, upperExclusive. Inspect included before interpreting the associated values.
Require windowWidth>=0; lower=end-width, upper=end; included requires lower<=event<end.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| eventTime | Event Time | Required. Finite number. |
| windowEnd | Window End | Required. Finite number. |
| windowWidth | Window Width | Required. Finite number; minimum 0. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| included | windowEnd-windowWidth<=eventTime<windowEnd; zero width selects no events. | Required. Boolean. |
| lowerInclusive | Lower Inclusive | Required. Finite number. |
| upperExclusive | Upper Exclusive | Required. Finite number. |
{
"input": {
"eventTime": 8,
"windowEnd": 10,
"windowWidth": 5
},
"output": {
"included": true,
"lowerInclusive": 5,
"upperExclusive": 10
}
}Limitations and assumptions
- Zero width contains no event. Matching time units are assumed; no window aggregation, timezone, actual event or metric definition is established.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
- Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.
Alternative or Complementary methods
Reconcile source transactions, inventory and cohort records with the full metric definitions. Use complete forecasts, accounting and study designs where needed; individual contributions and supplied scenarios do not establish performance or causal effects.
References
Similar or alternative tools
- Stock Out Day Censored Demand Flag
Preserve a supplied observed-sales count and stockout censoring flag.
- Customer Order First Repeat Label
Label a supplied current-order ordinal as first or repeat.