View Geographic Distribution of Activities in Aggregation Summary
Bufdir grants often require documentation of geographic reach. The geographic distribution service computes how activities are spread across municipalities or regions within the organisation's operational area. This breakdown is shown as part of the aggregation summary, enabling the coordinator to spot gaps before export. For large organisations like NHF with 1,400 local chapters across Norway, this check is critical to ensure no region is overlooked.
User Story
Acceptance Criteria
- Given aggregation completes, when the summary screen is shown, then a geographic distribution section lists activity counts grouped by region or municipality
- Given a region has zero activity, when the distribution is displayed, then that region appears with a count of zero and is visually distinguished from active regions
- Given the coordinator taps a region row, when the detail expands, then the underlying activity records contributing to that region's count are listed
- Given the coordinator's organisation spans multiple chapters, when distribution is computed, then each chapter's activities are assigned to the correct geographic unit using their registered location
- Given geographic data is incomplete for some activities, when distribution is shown, then those activities are grouped under an 'Unassigned' bucket with a count and a warning
Business Value
Bufdir evaluates whether funded organisations deliver services across their mandated geographic area. Coordinators who can identify and fix coverage gaps before submission demonstrate accountability and reduce the risk of partial grant reductions. This feature turns a previously invisible compliance risk into an actionable pre-submission check.
Components
- Geographic Distribution Service service
- Bufdir Aggregation Service service
- Aggregation Query Builder data
- Bufdir Metrics Repository data
- Supabase Aggregation RPC Functions infrastructure
- Aggregation Summary Widget ui