HVAC Cockpit
Aging equipment, expiring warranties and maintenance-plan revenue across your service area.
- HVAGEAging units · 12 years +Live
- HVWEPWarranties expiring · 180 daysLive
- HVMRRMaintenance plan revenueLive
- HVPVCPlan visits overdueLive
Traced to its query
Equipment units installed 12 or more years ago — replacement candidates.
- Formula
COUNT(*) equipment WHERE today − install_date ≥ 12 years- Sources
- crm_industry_objects (equipment).data.install_dateGET /api/v1/crm/boards/industry → hvac.equipment.aging
- League stat
- Aging curve
- Window
- today
Equipment units whose warranty ends in the next 180 days.
- Formula
COUNT(*) FROM crm_industry_objects WHERE object_id = 'equipment' AND today ≤ warranty_until ≤ today + 180 days- Sources
- crm_industry_objects (equipment)GET /api/v1/crm/boards/industry → hvac.equipment
- League stat
- Contract expiry calendar
- Window
- the page’s own range
The yearly price of every live maintenance plan, added up.
- Formula
SUM((data->>'price')::numeric) FROM crm_industry_objects WHERE object_id = 'maintenance-plans' AND (renewal_date IS NULL OR renewal_date ≥ today) — price taken as annual- Sources
- crm_industry_objects (maintenance-plans)GET /api/v1/crm/boards/industry → hvac.plans
- League stat
- Season-ticket revenue
- Window
- today
Live maintenance plans whose next tune-up date has already passed.
- Formula
COUNT(*) maintenance-plans WHERE next_visit < today AND (renewal_date IS NULL OR renewal_date ≥ today); monthly load = SUM(visits_per_year) ÷ 12- Sources
- crm_industry_objects (maintenance-plans)GET /api/v1/crm/boards/industry → hvac.plans.overdue
- League stat
- Games postponed
- Window
- today