Charts & Analytics

Path: /properties/[id]/renovation → Charts Tab
Access Level: Property Owners & Collaborators

Overview

Charts transform renovation data into visual insights. Instead of reviewing spreadsheets, see at-a-glance where your money is going, whether you're on schedule, and which areas need attention. Data-driven decisions lead to better outcomes.

Available Charts

Budget Charts

Budget Breakdown (Pie Chart)

Shows: How renovation budget is allocated

Total Budget: $78,500

Segments:
- Labor: $32,500 (41.4%)
- Materials: $28,000 (35.7%)
- Permits: $3,500 (4.5%)
- Contingency: $7,850 (10.0%)
- Management: $6,650 (8.5%)

Insights:

• Biggest cost categories
• Budget allocation balance
• Areas for potential savings

Budget vs. Actual (Bar Chart)

Shows: Planned spending vs. actual spending by category

Category          Budget    Actual    Variance
Labor           $32,500   $34,200    +$1,700 (5% over)
Materials       $28,000   $26,800    -$1,200 (4% under)
Permits          $3,500    $3,500          $0 (on target)
Contingency      $7,850    $2,100    -$5,750 (73% remaining)
Management       $6,650    $6,400      -$250 (4% under)

Insights:

• Which categories over/under budget
• Contingency usage
• Real-time variance tracking

Spending Timeline (Line Chart)

Shows: Cumulative spending over time

Planned vs. Actual Spending Curve

Week 1:  Planned $5,000  | Actual $4,800
Week 2:  Planned $12,000 | Actual $11,500
Week 3:  Planned $20,000 | Actual $21,200 ⚠️
Week 4:  Planned $30,000 | Actual $31,500 ⚠️
Week 5:  Planned $42,000 | Actual $43,800 ⚠️
Week 6:  Planned $56,000 | Actual $58,600 ⚠️
Week 7:  Planned $68,000 | Actual (projected)
Week 8:  Planned $78,500 | Actual (projected)

Insights:

• Spending pace (ahead/behind schedule)
• Burn rate
• Projected final cost
• Cash flow needs

Budget by Room (Stacked Bar)

Shows: Budget allocation across rooms/areas

Kitchen: $45,000
  Labor: $18,000 (40%)
  Materials: $22,000 (49%)
  Other: $5,000 (11%)

Master Bath: $18,500
  Labor: $7,500 (41%)
  Materials: $9,000 (49%)
  Other: $2,000 (11%)

Guest Bath: $8,000
  Labor: $3,200 (40%)
  Materials: $3,800 (48%)
  Other: $1,000 (13%)

Living/Floors: $7,000
  Labor: $3,800 (54%)
  Materials: $2,200 (31%)
  Other: $1,000 (14%)

Insights:

• Most expensive rooms
• Labor vs. materials ratio by room
• Budget distribution

Timeline Charts

Project Timeline (Gantt Chart)

Shows: Milestone schedule and dependencies

January          February         March
|----Demo----|
             |----Rough-Ins----|
                              |--Drywall--|
                                        |--Cabinets----|
                                                      |--Finishes--|

Features:

• Current date indicator
• Completed milestones (green)
• In-progress milestones (blue)
• Future milestones (gray)
• Dependencies (arrows)
• Delays (red bars)

Insights:

• Critical path
• Schedule adherence
• Bottlenecks
• Completion forecast

Milestone Progress (Progress Bars)

Shows: Completion percentage by milestone

Milestone 1: Demolition
■■■■■■■■■■ 100% Complete ✅

Milestone 2: Rough-Ins
■■■■■■■□□□ 75% Complete 🔵

Milestone 3: Drywall & Paint
■■■□□□□□□□ 35% Complete 🔵

Milestone 4: Cabinets
■□□□□□□□□□ 10% Complete ⏳

Milestone 5: Finishes
□□□□□□□□□□ 0% Not Started

Insights:

• Current project phase
• Progress rate
• Stalled milestones
• Upcoming work

Schedule Variance (Timeline)

Shows: Planned vs. actual completion dates

Milestone          Planned    Actual     Variance
Demo              Jan 5      Jan 6      +1 day
Rough-Ins         Jan 19     Jan 22     +3 days ⚠️
Drywall           Feb 2      Feb 5      +3 days ⚠️
Cabinets          Feb 16     (projected Feb 20)
Finishes          Mar 2      (projected Mar 8)
Completion        Mar 15     (projected Mar 22)

Insights:

• Cumulative delays
• Impact on completion date
• Areas causing delays
• Buffer usage

Labor & Time Charts

Labor Hours by Milestone (Bar Chart)

Shows: Time spent per project phase

Milestone          Estimated   Actual    Variance
Demo               30 hrs     32 hrs    +2 hrs
Rough-Ins          90 hrs     95 hrs    +5 hrs
Drywall            50 hrs     48 hrs    -2 hrs ✅
Cabinets           90 hrs     62 hrs    (in progress)
Finishes           60 hrs     0 hrs     (not started)

Total: 320 hrs estimated | 237 hrs actual so far

Insights:

• Time-consuming phases
• Productivity rates
• Estimate accuracy
• Resource allocation

Labor Cost by Worker (Pie Chart)

Shows: Labor spending by individual/contractor

Total Labor: $34,200

Workers:
- John Smith (General): $12,500 (36.5%)
- ABC Plumbing: $8,100 (23.7%)
- XYZ Electrical: $7,200 (21.1%)
- Sarah (Painter): $4,800 (14.0%)
- Your Sweat Equity: $1,600 (4.7%)

Insights:

• Top cost contributors
• Contractor spending
• Sweat equity value
• Labor distribution

Productivity Over Time (Line Chart)

Shows: Hours logged per week

Week 1:  64 hours (8 hrs/day avg)
Week 2:  72 hours (9 hrs/day avg)
Week 3:  80 hours (10 hrs/day avg) ⬆️ Peak
Week 4:  56 hours (7 hrs/day avg) ⬇️
Week 5:  68 hours (8.5 hrs/day avg)
Week 6:  62 hours (7.75 hrs/day avg)

Insights:

• Workforce consistency
• Peak activity weeks
• Slowdowns
• Staffing needs

Material Charts

Material Cost by Category (Bar Chart)

Shows: Material spending breakdown

Category          Budget    Actual    Variance
Cabinets        $12,000   $11,500    -$500 ✅
Countertops      $8,000    $8,450    +$450
Appliances       $5,000    $4,800    -$200 ✅
Tile             $3,500    $3,650    +$150
Flooring         $4,500    $4,200    -$300 ✅
Plumbing Fix     $2,800    $2,950    +$150
Electrical       $2,200    $2,100    -$100 ✅
Paint/Supplies   $1,500    $1,450    -$50 ✅

Insights:

• Material budget adherence
• Overspending categories
• Savings opportunities

Material Status (Donut Chart)

Shows: Material order/delivery status

Total Material Items: 287

Status:
- Installed: 145 items (50.5%) [Green]
- Received: 52 items (18.1%) [Yellow]
- Ordered: 38 items (13.2%) [Blue]
- Not Ordered: 52 items (18.1%) [Gray]

Insights:

• Procurement progress
• Pending deliveries
• Upcoming orders
• Installation pace

Quality & Completion Charts

Checklist Completion (Progress Grid)

Shows: Quality control checklist status

Checklist                    Status          Progress
Pre-Demo Safety             Complete ✅      12/12 (100%)
Demo Quality                Complete ✅      8/8 (100%)
Rough-in Plumbing           Complete ✅      15/15 (100%)
Rough-in Electrical         In Progress 🔵   10/12 (83%)
Rough-in HVAC               Complete ✅      8/8 (100%)
Drywall Quality             In Progress 🔵   18/24 (75%)
Cabinet Installation        Not Started ⏳   0/16 (0%)
Paint Quality               Not Started ⏳   0/10 (0%)

Insights:

• Quality control coverage
• Inspection completion
• Upcoming inspections
• Standards adherence

Punch List Items (Stacked Bar)

Shows: Open vs. closed punch list items over time

Week 3:  8 created | 2 resolved | 6 open
Week 4:  12 created | 7 resolved | 11 open
Week 5:  5 created | 10 resolved | 6 open ✅
Week 6:  8 created | 9 resolved | 5 open ✅
Week 7:  4 created | 7 resolved | 2 open ✅

Insights:

• Quality issue trends
• Resolution efficiency
• Problem areas
• Contractor performance

Financial Analytics

Cost Per Square Foot (Comparison)

Shows: Your cost vs. market averages

Your Kitchen Renovation: 250 sq ft
Your Cost: $45,000
Cost per sq ft: $180/sq ft

Market Comparison:
- Budget rehab: $100-150/sq ft
- Mid-range: $150-200/sq ft ← You are here
- High-end: $200-300/sq ft
- Luxury: $300+ /sq ft

Insights:

• Project scope level
• Value positioning
• Market competitiveness
• ROI potential

ROI Projection (Waterfall Chart)

Shows: Investment to projected return

Purchase Price:           $180,000
Renovation Cost:          + $78,500
Total Investment:         = $258,500

ARV (After Repair Value): $340,000
Profit (before costs):    $81,500

Closing Costs:            - $10,200
Holding Costs:            - $6,500
Net Profit:              = $64,800

ROI: 25.1%

Insights:

• Profit potential
• Return on investment
• Cost of sale
• Net proceeds

Dashboard Overview

Combined widget view:

┌──────────────────────────┐ ┌──────────────────────────┐
│  Budget Status           │ │  Timeline Status          │
│  $71,900 spent           │ │  Week 6 of 8             │
│  $78,500 total (92%)     │ │  On schedule ✅          │
│  ■■■■■■■■■□               │ │  Est. Complete: Mar 15   │
└──────────────────────────┘ └──────────────────────────┘

┌──────────────────────────┐ ┌──────────────────────────┐
│  Labor Hours             │ │  Material Status          │
│  237 of 320 hrs (74%)    │ │  145 of 287 items        │
│  83 hours remaining      │ │  Installed (50.5%)       │
│  $34,200 labor cost      │ │  52 pending delivery     │
└──────────────────────────┘ └──────────────────────────┘

┌──────────────────────────┐ ┌──────────────────────────┐
│  Milestone Progress      │ │  Quality Control          │
│  M1-M2: Complete ✅      │ │  8 of 10 checklists      │
│  M3: 75% done 🔵         │ │  Complete (80%)          │
│  M4-M5: Pending ⏳       │ │  2 punch list items open │
└──────────────────────────┘ └──────────────────────────┘

Chart Customization

Date Range Selection

Filter data by timeframe:

• Last 7 days
• Last 30 days
• This month
• Last month
• This quarter
• Custom range

Example: View spending for February only

Category Filters

Focus on specific data:

• Filter by room (Kitchen only)
• Filter by milestone (Rough-ins only)
• Filter by worker (John Smith only)
• Filter by category (Labor only)

Example: Labor costs for kitchen cabinets

Comparison Views

Side-by-side analysis:

Budget comparison:

• This property vs. last property
• Planned vs. actual
• This month vs. last month

Timeline comparison:

• Estimated vs. actual dates
• This phase vs. last phase
• Multiple properties

Exporting Charts

Export Formats

Image exports:

• PNG (presentations, web)
• JPG (compressed)
• SVG (scalable, high-quality)

Data exports:

• PDF (reports)
• Excel (further analysis)
• CSV (raw data)

Export options:

1. Click chart
2. Click "Export" button
3. Choose format
4. Download file

Report Packages

Pre-built report bundles:

Monthly Progress Report:

• Budget status charts
• Timeline charts
• Labor summary
• Material status
• Quality metrics
• Executive summary

Investor Report:

• Financial overview
• ROI projection
• Timeline status
• Risk assessment
• Next steps

Contractor Performance:

• Productivity charts
• Budget adherence
• Schedule performance
• Quality scores

Real-Time Updates

Auto-Refresh

Charts update automatically:

• Budget changes → Chart updates
• Time logged → Labor chart updates
• Material status → Status chart updates
• Checklist item → Quality chart updates

Refresh frequency: Every 5 seconds when active

Live Indicators

Real-time status:

⚫ Live: Data updating in real-time
🟢 Current: Data up-to-date (updated 2 min ago)
🟡 Cached: Using recent data (updated 15 min ago)
🔴 Stale: Data may be outdated (updated 2 hrs ago)
   [Refresh Now] button available

Insights & Alerts

Automatic Insights

AI-powered observations:

💡 INSIGHT: Labor Productivity

Your average productivity is 8.2 hours per day,
which is 12% higher than typical renovation projects.

Contractors are on pace to finish 3 days early.

🎯 RECOMMENDATION: Consider starting finishes 
   earlier to maintain momentum.

Threshold Alerts

Automatic warnings:

⚠️ ALERT: Budget Variance

Kitchen cabinets are 15% over budget ($2,250 overage).

This impacts overall contingency fund.

🔧 ACTIONS:
  - Review cabinet costs
  - Reduce spending in other areas
  - Increase budget allocation

Alert types:

• Budget variance (>10%)
• Schedule delays (>3 days)
• Low contingency (<5%)
• Stalled milestones (no progress 7 days)
• Quality issues (multiple punch lists)

Best Practices

Chart Usage

1. Review Daily: Check dashboard every morning
2. Weekly Deep Dive: Analyze trends weekly
3. Share with Team: Transparent communication
4. Export for Records: Document progress
5. Compare Projects: Learn from history
6. Trust the Data: Make data-driven decisions
7. Act on Insights: Respond to alerts promptly

Data Accuracy

1. Log Time Daily: Accurate labor tracking
2. Update Material Status: Keep current
3. Approve Entries Promptly: Real-time budgets
4. Link Everything: Budget, time, milestones
5. Verify Costs: Confirm actual spending
6. Photo Documentation: Visual proof
7. Regular Audits: Monthly data reviews

Troubleshooting

"Chart Shows No Data"

Check:

• Date range selected
• Filters applied
• Data actually entered
• Permissions

Solution:

1. Clear filters
2. Expand date range
3. Verify data exists
4. Refresh page

"Chart Data Seems Wrong"

Verify:

• Budget entries approved
• Time entries approved
• Material costs synced
• Recent updates applied

Solution:

1. Check data sources
2. Verify sync status
3. Click "Refresh Data"
4. Contact support if persists

"Can't Export Chart"

Requirements:

• Chart fully loaded
• Browser allows downloads
• Sufficient permissions

Solution:

1. Wait for chart to load
2. Check browser settings
3. Try different format
4. Use screenshot as backup

Keyboard Shortcuts

• D C - Dashboard charts
• B C - Budget charts
• T C - Timeline charts
• L C - Labor charts
• E C - Export chart
• R C - Refresh charts

Related Guides

• Project Overview ← - Dashboard metrics
• Budget Management ← - Financial data
• Time Tracking ← - Labor analytics
• Reports → - Comprehensive reporting
• Milestones ← - Timeline data

Last Updated: December 8, 2025
Version: 1.0
Feedback: Was this guide helpful? Rate it at the bottom of this page.