# aggregating-view-data

> Claude/Codex skill by [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars · Updated 2026-10-23

Execution skill. Use when a View needs totals or subtotals, when a value must roll up with something other than Sum (average, min, max, count, last), when a snapshot metric adds up across time instead of holding, or when a ratio, percentage, growth or variance metric shows a wrong total. Covers metric default aggregators, pivot versus hidden-dimension aggregation, the aggregator reference per value type, and Advanced Aggregators on Table Views.

## Install

```sh
git clone https://github.com/gopigment/ai-plugins /tmp/ai-plugins && ln -s /tmp/ai-plugins/skills/aggregating-view-data ~/.claude/skills/aggregating-view-data
```

## From README

Aggregating View Data Aggregation decides two things: what a total cell contains, and how a visible cell is computed when the metric carries dimensions the View does not display. It lives at two levels: metric defaults, set once on the metric, and View overrides, set per View with tool:updateviewaggregations. Wrong aggregation never raises an error. It returns a plausible number, so check it whenever a metric is a snapshot, a rate, or a variance. Read the current configuration with tool:getviews and include: \["Rows", "Columns", "HiddenDimensionsAggregations"\]. Aggregation fields that fail validation are dropped silently, so re-read after every update.

## Links

- HTML page: https://omgskills.com/library/gopigment/ai-plugins/skills/aggregating-view-data/
- GitHub: https://github.com/gopigment/ai-plugins
- Author: [@gopigment](https://omgskills.com/library/gopigment/index.md)

## More from this repo

- [architecting-multi-application-solutions](https://omgskills.com/library/gopigment/ai-plugins/skills/architecting-multi-application-solutions/index.md) — Planning skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars
- [auditing-a-pigment-application](https://omgskills.com/library/gopigment/ai-plugins/skills/auditing-a-pigment-application/index.md) — Execution skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars
- [building-a-full-application](https://omgskills.com/library/gopigment/ai-plugins/skills/building-a-full-application/index.md) — Planning skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars