Automations / KPI Dashboard

KPI Dashboard

Healthy

Operating performance across Eagle locations and service types, refreshed from the approved data points every morning.

OwnerMarcus BellCadenceDaily 06:30 CTLast run34 min ago · 24 measures refreshed. Ravenna stale.Nextin 23 h
Refreshed Sep 8, 6:31 AM
Review flags
Outliers against the review thresholds, and any source that is stale. Each one is somebody's to acknowledge or hand on.
4 open

Performance

Roscoe, TX · All 7 service types · 2026 YTD · against prior year. Select a measure to chart it.

Gross revenue by service type
$10.07M
Heavy repair24%$2.4M+6.7%
Light repair22%$2.2M+6.7%
Cleaning16%$1.6M+6.7%
Lining and coating12%$1.2M+6.7%
Inspection and testing10%$1.0M+6.7%
Mobile repair10%$1.0M+6.7%
Storage6%$604K+6.7%
Gross revenue over time
$10.07M$1.3M avg/month
ActualPrior year
$0$500K$1.0M$1.5MJanFebMarAprMayJunJulAug

Location performance

Actuals for 2026 YTD. Review thresholds: turn time 45 days, labor hours per car 72.

EA
Eagle assistantDrafted from the published numbers. Finance reads it; it changes nothing.

Roscoe turn time is 52 d, down 7.7% on the prior year, and has been above the 45 day line in 8 of the last 8 months. Aug came in at 48 d.

Roscoe labor hours per car is 75 h, down 6.8% on the prior year, and has been above the 72 hour line in 7 of the last 8 months. Aug came in at 71 h, back under the line.

Reads from
Connections and approved data points.
Data Tree
Sage 300 CRERailcarRXAboutTimeADP Workforce NowOperating database
Business objectGross RevenueBusiness objectVolumeBusiness objectBacklogBusiness objectLabor HoursBusiness objectCar-Cycle EventsDerivationNet Revenue / CarDerivationLabor Hours / CarDerivationAverage Turn TimeDimensionLocationsDimensionService TypesDimensionTime
Setup
What the next run applies, and how it reads.
Turn time review threshold
45 days
Labor hours per car threshold
72 hours
Mark a location stale after
24 hours
Default comparison
Prior year
Trigger
Schedule, after the Sage nightly replication completes
AI role
Commentary and outlier ranking only
Rules
  • Refresh only after Sage replication completes
  • Keep a stale location's last good values on screen
  • Commentary is drafted from the published numbers and never changes one