writing-pigment-formulas
Execution skill. Load it before the first `validate_formula`, or before any `create_metric`, `bulk_update_metrics`, `create_list_property` or `update_list_property` call that sets a formula; never write a formula without loading it first. Use when writing, editing, or debugging Pigment metric or list property formulas — quoting, references, data types, BLANK, comments, and replacing hard-coded items, dates and thresholds with input metrics.
Install
With your agent
Install OMGSkills skill "gopigment/ai-plugins:skills/writing-pigment-formulas" 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/writing-pigment-formulas ~/.claude/skills/writing-pigment-formulasFrom README
Write Pigment Formulas Pigment syntax only. Never write Excel, SQL, Python, DAX, or any other language. Formulas operate on metrics (multidimensional grids). Each cell = intersection of one item per dimension. Modifiers control dimension alignment. --- Stage 1 — Identify Inputs Before writing any formula: Confirm the target metric — name, dimensions, type (Number / Date / Text / Dimension / Boolean). The formula result type must match. Confirm source blocks — metrics, lists, properties referenced in the formula. Use tool:searchmetricsandlists (or tool:semanticsearch when names are unclear) to find exact names and spot duplicates. Map dimensions — compare source dimensions vs target dimensions. If they differ, you will need modifiers (Stage 2.4). Check for circular dependencies — if the formula references its own metric or forms a cycle, you need PREVIOUS / PREVIOUSOF with a declared cycle.