View Hierarchical Cross-Level Organization Statistics

The organization administrator's dashboard view extends beyond the local scope available to coordinators and presents a hierarchical breakdown: national totals drill into regional sub-totals, which drill into local association totals. This hierarchical aggregation is executed by the Coordinator Report Service using the organization administrator's full-scope key. The Report Filter Widget exposes an organization level dimension that coordinators do not see — allowing administrators to compare, for example, the 9 regions side by side or drill into all 1,400 local associations within a region. The Coordinator Stats Repository stores per-scope-key cache entries for each organizational level to avoid redundant re-computation when the administrator drills between levels.

HIGH story-coordinator-reports-organization-administrator-006 8 pts

Story Points

High

Priority

Coordinator Reports & Dashboards

Feature

User Story

As a Organization Administrator

I want to view aggregated statistics broken down by national association, region, and local association levels simultaneously

So that So that I can compare activity levels across the organizational hierarchy, identify which regions or local associations are underperforming relative to their size, and present accurate data to national leadership and Bufdir without manual aggregation

Acceptance Criteria

Given an authenticated organization administrator, when they open the coordinator dashboard, then aggregate statistics for the full national scope are shown as the top-level view
Given the administrator selects a specific region in the filter widget, when the dashboard updates, then statistics are narrowed to all local associations within that region
Given the administrator selects a specific local association, when the dashboard updates, then statistics match what a coordinator scoped to that association would see
Given the administrator views the top-level national view, when they review the region breakdown table, then each of the 9 regions shows its own activity count, active peer mentor count, and activity trend
Given the administrator exports data at the national level, when the CSV is generated, then it includes a regional breakdown column alongside totals
Given the administrator drills from national to regional to local association view, when navigating back up, then each level is displayed from cache without re-running the full aggregation

Business Value

NHF has 12 national associations, 9 regions, and 1,400 local associations. Currently, national-level statistics require manual Excel aggregation from individual coordinator reports — a process taking hours and prone to omissions. Organization administrators need hierarchical drill-down to fulfill their Bufdir compliance responsibilities and to present accurate program data to national leadership. This story eliminates the manual aggregation bottleneck at the top of the organizational hierarchy and is a prerequisite for credible national-level strategic planning.

Components

Coordinator Reports & Dashboards

Related Feature

Organization Administrator

User Role