ProjectHelm
Home / Documentation / Formula Metrics & Live KPIs
Data Modeling

Formula Metrics & Live KPIs

Real-time dashboard numbers, cross-entity formula expressions, progress rings, and charts.

Updated September 2026 • 5 min read • .NET 10 & C#

Real-Time Aggregates

Define metrics that compute live values directly from EF Core queries: Count, Sum, Average, Min, and Max. Filter by date window (Today, Last 7 Days, This Month, All Time) or stage (e.g. Stage == 'Completed').

Cross-Entity Formulas

Combine multiple metrics with arithmetic formulas:

Formula Expression Example Metrics
// Net Cash Flow across Orders and Expenses
TotalRevenue - TotalOperatingExpenses

// Savings Rate Percentage
((TotalIncome - TotalExpenses) / TotalIncome) * 100