🧪 Testing Documentation Steps
To validate that the dashboard is working as expected, document the following test steps:
🔹 1. Data Integrity Test
Go to your Supabase database Query the total number of rows in the proposals and simulations tables Confirm that these numbers match what's shown in each metric card 🔹 2. Status Logic Test
Run this SQL to confirm Approved Proposals: sql
CopyEdit
select count(*) from proposals where status = 'Approved';
Ensure the Approved Proposals metric matches this result 🔹 3. Recent Proposals Test
sql
CopyEdit
select count(*) from proposals where created_at > now() - interval '7 days';
Confirm it matches the Recent Proposals (7d) card 🔹 4. UI Functionality Test
Refresh the Lovable UI — metric cards should show updated values Simulate a proposal creation and rerun metrics — verify card updates If needed, add skeleton loading indicators for slow queries