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