Add-OfficeExcelReportKpi

Examples

Add a row of KPI cards

New-OfficeExcel -Path .\Reports\Operations.xlsx {
    ExcelReportSheet 'Summary' {
        ExcelReportKpi ([ordered]@{ Uptime = '99.97%'; Incidents = 4; Deployments = 37 })
    }
}

Shows three headline figures as KPI cards.

Compute KPIs from the data

$orders = Import-OfficeCsv -Path .\Data\Q3-Orders.csv
$kpis = [ordered]@{
    Revenue           = ($orders | Measure-Object Amount -Sum).Sum
    Orders            = $orders.Count
    'Average order'   = [math]::Round(($orders | Measure-Object Amount -Average).Average, 2)
    'Active customers' = ($orders | Select-Object -ExpandProperty Customer -Unique).Count
}
New-OfficeExcel -Path .\Reports\Q3-Sales-Summary.xlsx {
    ExcelReportSheet 'Summary' {
        ExcelReportTitle 'Q3 sales' 'July to September 2026'
        ExcelReportKpi $kpis -PerRow 4
    }
}

Calculates the sales KPIs from the order export and shows them four to a row.