Choosing Formula Patterns
by gopigment6fec49f4ce9dNo license22 starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 2 days ago
Planning skill. Use before writing formulas to decide which patterns and modifiers are needed for the use case. Maps business requirements to formula pattern combinations.
- 6fec49f4ce9dCurrentcommit 6fec49fPublished Oct 8, 2026
Source and attribution
Source:gopigment/ai-pluginsinskills/choosing-formula-patternsat commit6fec49f
License: No license
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from gopigment/ai-plugins
Writing Pigment Formulas
gopigment
Guides writing, editing and validating Pigment metric formulas, covering quoting, data types, modifiers and BLANK.
Writing Performant Formulas
gopigment
Checklist and rules for writing sparse, performant Pigment formulas before delivery.
Using Search Tools
gopigment
Execution skill. Choosing between the discovery tools and calling them cheaply: why breadth is free but call count is not, and lineage versus full impact analysis. Load before exploring an application, resolving block names, or checking what a change breaks.
Using Mapped Dimensions
gopigment
Explains how to model time-dependent hierarchies in Pigment using mapped dimensions and joined pivots in views.
Using List Subsets
gopigment
Guides when and how to use List Subsets in Pigment, covering decision gates, risks, and safe implementation patterns.
Using Formula Modifiers
gopigment
Explains how to apply Pigment formula modifiers such as BY, ADD, REMOVE, KEEP, SELECT, FILTER and EXCLUDE to align metric dimensions.
More in Business & Finance
Tax Prep
anthropics
Prepares tax materials from closed books: a quarterly estimated payment breakdown or a year-end 1099-NEC list and accountant packet.
Plan Payroll
anthropics
Chains cash forecasting, overdue-invoice reminders, and payroll run staging so an owner can confirm payroll is covered before submitting it.
Job Post Builder
anthropics
Builds a hiring packet — job post, interview guide with rubrics, and offer letter template — from a role brief.
Contract Review
anthropics
Reviews NDAs, MSAs and vendor contracts, flags risky terms in plain English and offers a redlined DOCX.
Close Month
anthropics
Runs a month-end close chain: reconcile the ledger, refresh the cash forecast, then publish the close packet.
Business Pulse
anthropics
Builds a one-page cross-functional business snapshot for SMB owners from connected finance, sales, pipeline, calendar and inbox tools.