Dashboard Synopsis

REFERENCE

Complete guide to every menu, metric, and calculation formula in this dashboard.

14 pages documented

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'.

FormulaCOUNT( 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).

FormulaSUM( 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.

FormulaCOUNT( rows where SaleStatus = 'Successful' AND PaymentCategory = 'Closed Set' )

Sets Cash Collected

Sum of Cash Collected for all Closed Set records.

FormulaSUM( 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.

FormulaCOUNT( 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.

FormulaFor each month M: SUM( CashCollected ) where SaleStatus = 'Successful' AND month(Date) = M

Weekly 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.

FormulaFor each week W: SUM( CashCollected ) where SaleStatus = 'Successful' AND isoWeek(Date) = W

Offer 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.

FormulaFor each tier T: COUNT( rows where OfferCategory contains T ) and SUM( CashCollected )