system.kanoa.cmms.getMaintenanceKPIByAsset(startDate, endDate)

Returns a maintenance KPI summary grouped by asset for a given date range. Each row aggregates key maintenance metrics (e.g. work order counts, downtime, or completion performance) for a single asset, letting supervisors compare reliability and workload across equipment. It is typically used to populate an asset-comparison table or ranked chart on a maintenance analytics dashboard.

---

Parameters

startDate DateTime: Start date
endDate DateTime: End date

---

Returns

kpiByAsset pyDataset

---

Example

# Compare maintenance KPIs across all assets for the current month
startDate = system.date.getDate(2026, 6, 1)
endDate = system.date.now()
data = system.kanoa.utilities.convertDatasetToJSON(system.kanoa.cmms.getMaintenanceKPIByAsset(startDate, endDate))

for i, row in enumerate(data):
	print 'Row %i'%i
	for k,v in row.items():
		print k,v
	
	break
>>> 
Row 0
MTTA_Minutes 0.0
workOrderCount 20
MeanWait_Minutes 0.0
completedCount 0
MeanCycleTime_Minutes None
assetId 901
assetPath Kanoa Box Co\Box Plant\Packaging\Box Line 1
assetName Box Line 1
MTTR_Minutes None
openCount 20
>>>