Skip to content

Aggregation Function Design And Weighting

Turn many inputs into one usable output by explicitly choosing the aggregation rule, weights, normalization, and information-loss guardrails.

The Diagnostic Story

Symptom: The summary number exists, but everyone is arguing about what it means. Averages flatten subgroups that behaved very differently; weights were never chosen — they were inherited from an old spreadsheet. A small change to the normalization rule reverses the ranking, yet the system presents the result as stable and objective. Stakeholders are not really disputing the outcome; they are disputing the hidden choices baked into the aggregation.

Pivot: Name the purpose of the aggregation first, then choose every element — inputs, normalization, weights, rule family — explicitly and in relation to that purpose. Treat information loss as an engineering decision, not a side effect: decide what must remain visible after compression and design the rule to preserve it.

Resolution: The aggregate now answers the question it is actually being used to answer, and the path from inputs to output is reconstructible. Stakeholders can identify which weights and rules they disagree with, rather than arguing about the number itself. Plausible rule or weight changes no longer silently reverse consequential outputs.

Reach for this when you hear…

[public policy] “We've been ranking schools on this composite index for three years, and I just realized the attendance weight was set to 0.4 because someone left the default in the spreadsheet.”

[clinical triage] “The severity score looks stable nationally but the trauma centers are furious because their patient mix disappears when you average across all sites.”

[credit risk] “Change one normalization assumption and a completely different loan portfolio wins — at that point we're not measuring risk, we're measuring the formula.”

Mechanisms / Implementations

  • Aggregation Bias Audit
  • Dashboard Rollup Formula
  • Ensemble Weighting Table
  • Median, Trimmed-Mean, or Quantile Rule
  • Ranked-Choice or Approval Voting Rule
  • Weight-Sweep Sensitivity Table
  • Weighted Scoring Rubric

Abstractions this archetype builds on — directly (a source ingredient) or as a related pattern. Links follow the typed catalog namespace.

Built directly on (1)

  • Aggregation: Deliberately collapsing many items into a single summary, choosing which information to discard to gain tractability.

Also references 17 related abstractions

Variants

Narrower or domain-specific specializations that share this archetype's core structure. Recognized variants are established; candidate variants are provisional.

Weighted Composite Score Aggregation · subtype · recognized

Combine heterogeneous criteria into a single score after normalizing scales and assigning explicit weights.

Preference Aggregation Rule Design · governance variant · recognized

Choose a voting, ranking, or consensus rule that converts plural preferences into a collective choice.

Robust Statistical Summary Aggregation · subtype · recognized

Select summary statistics such as mean, median, trimmed mean, or quantiles so the aggregate reflects the distribution without being misled by noise or outliers.

Ensemble Judgment Aggregation · mechanism family variant · recognized

Combine multiple expert, model, or heuristic judgments into a more stable aggregate estimate or decision.

Hierarchical Rollup Aggregation · scale variant · recognized

Aggregate lower-level units into higher-level summaries while preserving drill-down paths and preventing category-level masking.