Use Modifiers in Formulas

In this micro-lesson, you learn about the 6 modifiers available in Pigment and when to use them. You learn how to:

• Define modifiers and when to use them
• Identify three modifiers used to change dimensionality
• Identify three modifiers used to change data without changing dimensionality
• Use the correct syntax for modifiers in Pigment formulas
• Aggregate and allocate your data across dimensions using the BY modifier
• Change dimensions in a formula using the ADD, REMOVE and BY modifiers
• Refine the data in a formula to specific items using the FILTER, EXCLUDE and SELECT modifiers
• Locate helpful resources on using modifiers