Free practice · ordering · medium

Practice

Order a filter waterfall

Arrange the steps for a traceable population filter waterfall.

Population contract

Every filter must be explicit enough to reproduce

Region
Northeast
Status
Completed under one approved definition
Window
>= Aug 1 and < Sep 1, 2026
Measure
Sum completed-order revenue in USD

Closed-open time boundaries prevent overlap at midnight, while a filter waterfall keeps denominator changes visible.

Arrange in the correct order
  1. 1. Reconcile included and excluded records
  2. 2. Apply the status rule and record count
  3. 3. Apply the region rule and record count
  4. 4. Apply the time-window rule and record count
  5. 5. Record the source row count