Tier	Avg. Home Price	Average % Change	YoY % Change	Neighborhoods
${row.Group}	$${row.AvgFinal.toLocaleString(undefined, { maximumFractionDigits: 0 })}	${pct}%	${yoy}%	${row.Count}

`; } // ==== neighborhood/region view ==== const groupKey = selectedView === 'neighborhood' ? 'RegionName' : 'Region'; const groups = d3.groups(filteredData, d => d[groupKey]); const tableData = groups.map(([group, rows]) => { const validRows = rows.filter(r => +r[finalDate] && +r[baseDate] && +r[oneYearAgo]); const count = validRows.length; if (!count) return null; const totalFinal = d3.sum(validRows, r => +r[finalDate]); const totalPct = d3.sum(validRows, r => (+r[finalDate] - +r[baseDate]) / +r[baseDate]); const totalYoY = d3.sum(validRows, r => (+r[finalDate] - +r[oneYearAgo]) / +r[oneYearAgo]); return { Group: group, AvgFinal: totalFinal / count, AvgPctChange: (totalPct / count) * 100, YoY: (totalYoY / count) * 100 }; }).filter(d => d !== null && !isNaN(d.AvgPctChange)) .sort((a, b) => d3.ascending(a.Group, b.Group)); const maxAbsPct = Math.max(...tableData .map(d => Math.max(Math.abs(d.AvgPctChange), Math.abs(d.YoY))) .filter(p => !isNaN(p))); return html` ${tableData.map(row => { const pct = row.AvgPctChange.toFixed(1); const yoy = row.YoY.toFixed(1); const colorPct = row.AvgPctChange >= 0 ? 'rgba(74, 144, 226, 0.7)' : '#f44336'; const colorYoY = row.YoY >= 0 ? 'rgba(74, 144, 226, 0.7)' : '#f44336'; const barWidthPct = `${(Math.abs(row.AvgPctChange) / maxAbsPct) * 100}%`; const barWidthYoY = `${(Math.abs(row.YoY) / maxAbsPct) * 100}%`; return html``; })}

${selectedView === 'neighborhood' ? 'Neighborhood' : 'Region'}	Avg. Home Price	Average % Change	YoY % Change
${row.Group}	$${row.AvgFinal.toLocaleString(undefined, { maximumFractionDigits: 0 })}	${pct}%	${yoy}%

`; }