Mappings
Every data point across projects
The dimensions, objects, and derivations the organization consolidates from every connection, how source values reconcile into them, and where each one comes from.
Average turn time
Which events open and close a span, which holds come off it, and which cycles cannot be measured.
5 approved2 need review1 suggested
Configuration
Derivation · reads 2 connections
Reconciles into
Average Turn TimeAVG_TURN_TIME
3 canonical values · 8 treatments
Time basis
Release date
The date every input aligns on.
Formula
AVG(released.event_at - arrived.event_at) AS gross, AVG(gross - SUM(hold durations)) AS active, per car_cycle_id released in period
Canonical values
3 targets. Every approved treatment resolves to one of these.
- Gross daysGROSSArrival to release
4 values - Hold daysHOLDTime stopped, subtracted from gross2 values
- Active daysACTIVEGross less hold1 values
Tell Eagle how to reconcile
Plain English. Eagle re-treats the matching rows and says what it did.
Instructions in effect
Nothing yet. Anything you say is applied to the table and kept for new source values.
Select rows to preview how they combine into a canonical value. Click a source value to inspect or edit its treatment. Hover a confidence to see why.