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.

Master Consolidated View
Mapping Reconciliation / Labor hours / car

Labor hours / car

Which approved hours count, how they match a cycle, and why the shop scoreboard runs high.

7 approved1 need review
Configuration
Derivation · reads 3 connections
Reconciles into
Labor Hours / CarLABOR_HOURS_PER_CAR
3 canonical values · 8 treatments
Time basis
Release date
The date every input aligns on.
Formula
SUM(LABOR_HOURS.regular_hours + LABOR_HOURS.overtime_hours WHERE charge_type = 'direct' AND is_approved) / COUNT(DISTINCT VOLUME.car_cycle_id)
Canonical values
3 targets. Every approved treatment resolves to one of these.
  • Direct hoursHOURS
    Approved direct hours matched by work order
    3 values
  • Released carsCARS
    Distinct cycles released in the month
    1 values
  • Hours per carHPC
    The metric, against prior figures
    2 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.