| Portfolio ↕ | Project Name ↕ | Suggested Name ↕ | Status ↕ | Open ↕ | Overdue ↕ | No Date% ↕ | No Assignee% ↕ | Quality ↕ |
|---|
| Portfolio ↕ | Project ↕ | Task ↕ | Assignee ↕ | Due Date ↕ | Issues ↕ |
|---|
| Portfolio | Projects | Open Tasks | Overdue | No Due Date | No Assignee |
|---|
| Portfolio | Project | Open | Overdue | No Date% | No Assignee% | Quality |
|---|
Confirmed bookings only · past classes · FP target ≤25% (green line = target)
| Studio | Confirmed | Fill% | FP% |
|---|
Each studio has two rooms. Classes were originally scheduled at studio level; room-level scheduling is now being introduced. Yoga Shala → Palm Beach (confirmed sub-room; 333 bookings / 104 classes already in data). Floor classes → Robina (confirmed sub-room; no records yet). "Reformer studio" is ambiguous — it exists under both studios; 13 class records are unassigned in this dataset.
| Studio | Classes Run | Confirmed Bookings | Avg Fill % | FP Bookings | FP % | Notes |
|---|
| Class Type | Classes | Avg Fill% |
|---|
| Instructor | Classes Taught |
|---|
| Plan | Active Members |
|---|
The fp_bookings count on every class record is 0. This field should reflect
how many FP bookings each class received. The C1 module is not populating it correctly —
likely because it uses booking_source = 'fitness_passport' to detect FP,
which under-counts by ~37%. FP must be detected via the membership_used field
(values: "Fitness Passport", "Fitness Passport (2025)", "Fitness Passport (Free: 2x Reformer Pass)",
"4x reformer session", "4 Reformer Sessions (Fitness Passport)"). FP% in this dashboard is
computed correctly from the bookings table using membership_used, but the classes
table fp_bookings field needs fixing in the C1 module before P1/P2 can calculate
FP-per-class KPIs (FP-05, FP-06).
Palm Beach does not accept Fitness Passport bookings. Only Robina accepts FP (Mermaid Beach also accepted FP until its closure). 0% FP for Palm Beach is expected and correct.
| Table | Field | Missing Count | % of Total |
|---|
Bookings table (130,210 records)
| studio value | Count |
|---|
Classes table (5,825 records)
| studio value | Count |
|---|