Dashboard Synopsis
REFERENCEComplete guide to every menu, metric, and calculation formula in this dashboard.
Purpose
The main command center. Provides a high-level snapshot of total sales performance, cash collected, closed sets, active reps, and team breakdowns for the selected date range and client/offer filter.
Data Source
Primary Sales Sheet — all successful sale records.
Metrics & Calculations
Total New Sales
Count of all records where Sale Status = 'Successful' AND Payment Category = 'New Sale'.
COUNT( rows where SaleStatus = 'Successful' AND PaymentCategory = 'New Sale' )Total Cash Collected
Sum of the Cash Collected column for all successful sale records (includes new sales, upsells, and payment plans).
SUM( CashCollected ) where SaleStatus = 'Successful'Closed Sets
Count of records where Sale Status = 'Successful' AND Payment Category = 'Closed Set'. Represents deals closed from a setter's booked appointment.
COUNT( rows where SaleStatus = 'Successful' AND PaymentCategory = 'Closed Set' )Sets Cash Collected
Sum of Cash Collected for all Closed Set records.
SUM( CashCollected ) where PaymentCategory = 'Closed Set' AND SaleStatus = 'Successful'Total Active Reps
Count of roster members whose Status = 'Active'. Sourced from the Sales Roster tab, not from sales records.
COUNT( Roster rows where Status = 'Active' )Monthly Cash Collected (Chart)
Line chart grouping total Cash Collected by calendar month. Each data point is the sum of cash for all successful sales in that month.
For each month M: SUM( CashCollected ) where SaleStatus = 'Successful' AND month(Date) = MWeekly Cash Collected (Chart)
Bar chart grouping total Cash Collected by ISO week (Monday–Sunday). Shows the last 16 weeks. Useful for spotting short-term momentum shifts.
For each week W: SUM( CashCollected ) where SaleStatus = 'Successful' AND isoWeek(Date) = WOffer Category Breakdown (LTO / MTO / HTO)
Groups sales by offer tier. LTO = Low Ticket Offer, MTO = Mid Ticket Offer, HTO = High Ticket Offer. Derived from the Offer Category column.
For each tier T: COUNT( rows where OfferCategory contains T ) and SUM( CashCollected )