1. My Sites
Visuals and positions (11)
| Visual | Type | x,y | w×h | Content |
|---|---|---|---|---|
| Page navigator | pageNavigator | 0,144 | 192×256 | Visible pages only; Site Detail is drillthrough and hidden. All pages here are new; existing FM reports are not changed |
| Reset button | actionButton | 1792,16 | 112×80 | Clears slicers and cross-filters |
| Title (who / what / when) | textbox | 208,48 | 1072×80 | IBCS three-line title; lines 1 and 3 driven by measures |
| AFM slicer | slicer (dropdown) | 1296,64 | 288×48 | Dropdown on DIM_Building[AFM Name]; defaults to the signed-in AFM through row-level security |
| State slicer | slicer (dropdown) | 1600,64 | 288×48 | Dropdown on DIM_Building[State] |
| Key message | textbox | 208,144 | 1680×32 | One-sentence message from a text measure, so it always matches the data |
| Data readiness | textbox | 1552,146 | 336×28 | Static text; shows whether the source data exists today |
| KPI row | cardVisual | 208,192 | 1680×128 | Counts of sites and work orders in the selected patch; last tile is budget used against the FY27 budget |
| Open jobs by how late they are | columnChart | 224,336 | 816×320 | Open work orders by days past expected completion. Navy = within date, crimson = past it. Reporting bucket Open = New, In Progress, On Hold |
| Open jobs due in the next 8 weeks | columnChart | 1056,336 | 832×320 | Open work orders by week of expected completion. Inspections are not included: none fall due before Jan-27 |
| Sites needing action | tableEx | 224,672 | 1664×352 | One row per site in the patch with at least one past-due job. Row click drills through to Site Detail. Sorted: past-due jobs, descending |
2. Patch comparison
Visuals and positions (11)
| Visual | Type | x,y | w×h | Content |
|---|---|---|---|---|
| Page navigator | pageNavigator | 0,144 | 192×256 | Visible pages only; Site Detail is drillthrough and hidden. All pages here are new; existing FM reports are not changed |
| Reset button | actionButton | 1792,16 | 112×80 | Clears slicers and cross-filters |
| Title (who / what / when) | textbox | 208,48 | 1072×80 | IBCS three-line title; lines 1 and 3 driven by measures |
| Regional FM slicer | slicer (dropdown) | 1296,64 | 288×48 | Dropdown on DIM_Building[RFM Name] |
| State slicer | slicer (dropdown) | 1600,64 | 288×48 | Dropdown on DIM_Building[State] |
| Key message | textbox | 208,144 | 1680×32 | One-sentence message from a text measure, so it always matches the data |
| Data readiness | textbox | 1552,146 | 336×28 | Static text; shows whether the source data exists today |
| KPI row | cardVisual | 208,192 | 1680×128 | Rates use budgeted sites as the denominator, so patches of different size compare fairly; last tile is the scope gap |
| Past-due jobs per 100 sites | barChart | 224,336 | 816×320 | Past-due open work orders divided by budgeted sites in the patch, times 100. Top 8 shown, scrolls to all 18. Reference line = all patches. Patch = DIM_Building[AFM Name] |
| Past-due jobs at each month end | columnChart | 1056,336 | 832×320 | Open work orders past expected completion at each month end, rebuilt from lodgement and closure dates. Latest month in navy, earlier months grey |
| Patches compared | tableEx | 224,672 | 1664×352 | One row per AFM patch. Patch names are withheld in this draft; showing names is an open question. Sorted: past-due jobs per 100 sites, descending |
3. Planned and reactive
Visuals and positions (11)
| Visual | Type | x,y | w×h | Content |
|---|---|---|---|---|
| Page navigator | pageNavigator | 0,144 | 192×256 | Visible pages only; Site Detail is drillthrough and hidden. All pages here are new; existing FM reports are not changed |
| Reset button | actionButton | 1792,16 | 112×80 | Clears slicers and cross-filters |
| Title (who / what / when) | textbox | 208,48 | 1072×80 | IBCS three-line title; lines 1 and 3 driven by measures |
| Regional FM slicer | slicer (dropdown) | 1296,64 | 288×48 | Dropdown on DIM_Building[RFM Name] |
| State slicer | slicer (dropdown) | 1600,64 | 288×48 | Dropdown on DIM_Building[State] |
| Key message | textbox | 208,144 | 1680×32 | One-sentence message from a text measure, so it always matches the data |
| Data readiness | textbox | 1552,146 | 336×28 | Static text; shows whether the source data exists today |
| KPI row | cardVisual | 208,192 | 1680×128 | Spend from the budget measures (actuals plus commitments); schedule counts from the statutory schedule list |
| Spend by period: reactive and planned | columnChart (stacked) | 224,336 | 816×320 | Spent plus committed by FY period, split by scope: Reactive Maintenance (navy) and Planned Maintenance (blue). Rolling 12 periods |
| Statutory schedules: costed and uncosted | barChart (stacked) | 1056,336 | 832×320 | Count of statutory schedules by obligation type; crimson = no cost on file (467 schedules) |
| Sites with no planned job this year | tableEx | 224,672 | 1664×352 | Budgeted sites with no planned job in FY27 to date, ranked by reactive spend. Blank last planned job = never. Crimson = older than 12 months, or every schedule uncosted. Row click drills through to Site Detail |
4. Due dates
Visuals and positions (11)
| Visual | Type | x,y | w×h | Content |
|---|---|---|---|---|
| Page navigator | pageNavigator | 0,144 | 192×256 | Visible pages only; Site Detail is drillthrough and hidden. All pages here are new; existing FM reports are not changed |
| Reset button | actionButton | 1792,16 | 112×80 | Clears slicers and cross-filters |
| Title (who / what / when) | textbox | 208,48 | 1072×80 | IBCS three-line title; lines 1 and 3 driven by measures |
| Obligation type slicer | slicer (dropdown) | 1296,64 | 288×48 | Dropdown on statutory obligation type |
| State slicer | slicer (dropdown) | 1600,64 | 288×48 | Dropdown on DIM_Building[State] |
| Key message | textbox | 208,144 | 1680×32 | One-sentence message from a text measure, so it always matches the data |
| Data readiness | textbox | 1552,146 | 336×28 | Static text; shows whether the source data exists today |
| KPI row | cardVisual | 208,192 | 1680×128 | Due date = last completed inspection plus 12 months, so overdue and 90-day counts are zero until early 2027; last tile counts schedules with no completion |
| Statutory due dates by month | columnChart | 224,336 | 816×320 | Count of schedules by month of next due date, next 13 months. Zero months are shown as 0, with a text note explaining why |
| Schedules with and without an inspection record | barChart (stacked) | 1056,336 | 832×320 | Schedules by obligation type: has a due date (navy) or no inspection on record (crimson) |
| Statutory schedules | tableEx | 224,672 | 1664×352 | One row per schedule. Sorted: next due date ascending, then schedules with no record. Blank = no completion, so no date. Row click drills through to Site Detail |
5. Data gaps
Visuals and positions (11)
| Visual | Type | x,y | w×h | Content |
|---|---|---|---|---|
| Page navigator | pageNavigator | 0,144 | 192×256 | Visible pages only; Site Detail is drillthrough and hidden. All pages here are new; existing FM reports are not changed |
| Reset button | actionButton | 1792,16 | 112×80 | Clears slicers and cross-filters |
| Title (who / what / when) | textbox | 208,48 | 1072×80 | IBCS three-line title; lines 1 and 3 driven by measures |
| State slicer | slicer (dropdown) | 1296,64 | 288×48 | Dropdown on DIM_Building[State] |
| Patch slicer | slicer (dropdown) | 1600,64 | 288×48 | Dropdown on DIM_Building[AFM Name] |
| Key message | textbox | 208,144 | 1680×32 | One-sentence message from a text measure, so it always matches the data |
| Data readiness | textbox | 1552,146 | 336×28 | Static text; shows whether the source data exists today |
| KPI row | cardVisual | 208,192 | 1680×128 | Register and budget counts; budgeted = FM budget flag set. Last tile stays blank-valued until an occupant source exists |
| Budgeted and unbudgeted properties, by state | barChart (stacked) | 224,336 | 816×320 | Count of properties by state: budgeted with an AFM (navy) and neither (grey). Scope is the denominator for every other page |
| Gaps among the 1,904 budgeted sites | barChart | 1056,336 | 832×320 | Each bar is a count of budgeted sites with that gap, shown as n of 1,904. Occupant bar is grey: no source identified |
| Budgeted sites with the most gaps | tableEx | 224,672 | 1664×352 | Gaps = count of: last job older than 12 months, no planned job, schedules with none inspected, open jobs with no contractor. Crimson = the gap applies. Planned jobs and Inspected show 0 on purpose: the zero is the finding. Other blanks are not applicable. Row click drills through to Site Detail. Sorted: gaps, descending |
6. Site Detail (drillthrough)
Visuals and positions (10)
| Visual | Type | x,y | w×h | Content |
|---|---|---|---|---|
| Page navigator | pageNavigator | 0,144 | 192×256 | Visible pages only; Site Detail is drillthrough and hidden. All pages here are new; existing FM reports are not changed |
| Back button | actionButton | 1792,16 | 112×80 | Back to the calling page |
| Title (who / what / when) | textbox | 208,48 | 1072×80 | IBCS three-line title; lines 1 and 3 driven by measures |
| Key message | textbox | 208,144 | 1680×32 | One-sentence message from a text measure, so it always matches the data |
| Data readiness | textbox | 1552,146 | 336×28 | Static text; shows whether the source data exists today |
| KPI row | cardVisual | 208,192 | 1680×128 | From the work orders and statutory schedules for the selected site; budget tile reuses the FM budget measures |
| Open jobs at this site | Gantt (Deneb) | 224,336 | 1024×320 | One bar per open job, lodged to expected completion: navy = within date, crimson = past it up to today, outline = time left. Top 6 by days overdue, then next due |
| Site | htmlContent (Site Card HTML) | 1264,336 | 624×320 | Address, building code, AFM and RFM, budget flag, contact and occupant. Occupant has no source, so it shows the gap in grey. Blank contact = not on file |
| Open jobs | tableEx | 224,672 | 1040×352 | All open work orders for the selected site, longest overdue first. Blank days past = not yet due. Crimson = over 90 days past, or no contractor assigned |
| Spend by period | clusteredColumnChart | 1280,672 | 608×352 | Spent plus committed by FY period, this year (dark) against the same periods last year (light) |
7. Notes
Visuals and positions (6)
| Visual | Type | x,y | w×h | Content |
|---|---|---|---|---|
| Page navigator | pageNavigator | 0,144 | 192×256 | Visible pages only; Site Detail is drillthrough and hidden. All pages here are new; existing FM reports are not changed |
| Reset button | actionButton | 1792,16 | 112×80 | Clears slicers and cross-filters |
| Title (who / what / when) | textbox | 208,48 | 1072×80 | IBCS three-line title; lines 1 and 3 driven by measures |
| What the numbers mean | textbox | 224,192 | 816×832 | Plain-English definitions for every measure on the FM pages |
| Data readiness | table | 1056,192 | 832×460 | Where each page gets its data and whether the source exists today |
| Not covered yet | textbox | 1056,668 | 832×356 | Known gaps and placeholders, stated once in plain English |