creating-metrics-and-tables
Execution skill. Load it before the first `create_metric` or `bulk_update_metrics` call; never create or change a metric without loading it first. Use when creating metrics or tables, selecting metric data types, or finalizing metric structure.
Install
With your agent
Install OMGSkills skill "gopigment/ai-plugins:skills/creating-metrics-and-tables" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
git clone https://github.com/gopigment/ai-plugins /tmp/ai-plugins && ln -s /tmp/ai-plugins/skills/creating-metrics-and-tables ~/.claude/skills/creating-metrics-and-tablesFrom README
Creating Metrics and Tables A metric is a sparse multidimensional grid: dimensions define the axes, each cell holds one value per combination. Metrics are input, formula-driven, or imported. Whether a given dataset belongs in a metric, a transaction list or a dimension is settled in skill:understanding-pigment-modeling before you get here. Workflow Resolve the dimension IDs. Every structural dimension must already exist and be populated. Look them up with tool:searchmetricsandlists; never pass a guessed ID. If a dimension is missing, create it first (skill:creating-dimensions-and-hierarchies). Pick the structure. See Choose the Grain below. Only dimension lists and their subsets can be structural. Pick the data type. Number for quantitative measures and the default for planning; Date for per-cell dates; Text for descriptive content; Dimension for a categorical lookup per cell; Boolean for per-cell flags. Pick the default aggregators in the same call.