Deep Dive: How the Dashboard Aggregates Your Portfolio Metrics

The Main DashboardIl-preview mhux disponibbli presents you with simple numbers. Behind those simple numbers is a real-time aggregation pipeline that dynamically calculates everything from scratch every time you load the page.

Understanding this pipeline helps you appreciate why data accuracy across your portfolio matters so much.

The Data Sources

Your dashboard doesn't store its own pre-calculated metrics. Instead, it reads from six live data sources every time you open the page:

1. Properties Table

→ Contributes: Total Properties count.

2. Units Table

→ Contributes: Total Units count, Occupied Units count (filtered by status), and the derived Occupancy Percentage.

3. Tenants Table

→ Contributes: Total Tenants count, Active Tenants count (filtered by active lease ownership).

4. Leases Table

→ Contributes: Total Leases count, Expected Revenue (sum of rent amounts on all Active leases).

5. Payments Table

→ Contributes: Collected Revenue (sum of payment amounts with "Completed" status in the current calendar month).

6. Maintenance Table

→ Contributes: Open Maintenance Requests count (filtered by "Open" or "In Progress" status).

The Aggregation in Action

Here is a simplified flow of what happens when you click "Dashboard":

1. The server queries each of the six tables above in parallel.
2. It applies the appropriate filters (e.g., "only Active leases", "only this month's payments").
3. It performs the mathematical aggregations (counts, sums, percentages).
4. It returns the compiled metrics object to your browser in a single response.
5. Your browser renders those numbers into the visual cards, progress bars, and charts you see.

This entire pipeline executes in milliseconds, which is why the dashboard always displays the most current state of your data—there is no caching delay.

Why This Matters for You

Because every metric on the dashboard is dynamically calculated from live source data:

• If you fix a typo in a lease's rent amount, the Expected Revenue card will instantly correct itself on your next page load.
• If you log a missing payment, the Collected Revenue card updates immediately.
• If you accidentally delete a property, the Total Properties count drops instantly.

There is no "sync button." There is no hourly refresh. The dashboard is a living mirror of your database, which means the quality of your dashboard metrics is entirely determined by the quality of your data entry.