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.
Net revenue / car
Which revenue lines and released cycles feed the numerator and denominator, and how the existing spreadsheet and dashboard figures compare.
6 approved2 need review
Configuration
Derivation · reads 2 connections
Reconciles into
Net Revenue / CarNET_REV_PER_CAR
3 canonical values · 8 treatments
Time basis
Invoice date
The date every input aligns on.
Formula
SUM(GROSS_REVENUE.gross_amount - GROSS_REVENUE.credit_amount WHERE NOT is_intercompany) / COUNT(DISTINCT VOLUME.car_cycle_id)
Canonical values
3 targets. Every approved treatment resolves to one of these.
- Net revenueNET_REVOperating revenue less credits, by invoice date
2 values - Released carsCARSDistinct cycles released in the month
3 values - Net revenue per carNRPCThe metric, against prior figures2 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.