ClaudeSuperPower

writing-pigment-formulas

Skill

Always use this skill when writing, editing, or debugging Pigment formulas — including conditional logic, blank handling, date-range logic, aggregation, prior-period lookups, and dimensional transformations. Pigment uses a proprietary formula language — NEVER assume you know the syntax, and ALWAYS r

Install

git clone https://github.com/gopigment/ai-plugins.git ~/.claude/skills/writing-pigment-formulas

What is writing-pigment-formulas?

Always use this skill when writing, editing, or debugging Pigment formulas — including conditional logic, blank handling, date-range logic, aggregation, prior-period lookups, and dimensional transformations. Pigment uses a proprietary formula language — NEVER assume you know the syntax, and ALWAYS read the documentation before writing any formula. Covers data types, modifiers, functions, calculation patterns, and performance trade-offs (calibrated by formula complexity). This skill includes supporting files in this directory; explore as needed.

What this can do

Capabilities declared in this component's own frontmatter — not inferred.

Inherit all session tools

Declares no tool restrictions — inherits every session tool

~138 tokens of context used while enabled, before you invoke anything

Documentation

README · ~11 min read

Writing Pigment Formulas

This skill provides comprehensive guidance for writing formulas in Pigment's multidimensional formula language, including formula builder tools for validation and generation. Pigment uses proprietary formula language which should never be confused with other language. Never mix Pigment formula language with other language, and never assume you know the language before reading this documentation.

CRITICAL - ABSOLUTE PROHIBITION: Pigment has its own unique formula language. You MUST NEVER write code or functions using another language being Excel, SQL, Python, JavaScript, MDX, DAX, or ANY other programming or query language. ONLY Pigment syntax exists when writing formulas.

When to Use This Skill

  • Write formulas - Creating calculations for metrics and list properties
  • Aggregate data - Rolling up from transaction lists or detailed dimensions

Reviews

Log in to leave a review.

No reviews yet — be the first.

Explore related

Other things in this space — across every part of the ecosystem, not just skills.