Introduction to Modifiers
Learn six Modifiers in Pigment - BY, ADD, REMOVE, SELECT, FILTER and EXCLUDE and when to use each of them in a formula.
Learn six Modifiers in Pigment - By, Add, Remove, Select, Filter and Exclude and when to use each of them in a formula. Delve into formula syntax, depending on a Modifier. Recognize the difference between allocation and aggregation methods. Explore the usage of Formula Wizard when allocating or aggregating data with the BY Modifier.
Who should take this course?
This course is designed for everyone, both business and technical users.
- Technical users need to know how to build formulas in Pigment, using Modifiers. They should also recognize different scenarios in which it is crucial to use a particular Modifier, e.g. when aggregating or allocating data.
- Business users will benefit from understanding formula syntax with Modifiers, being able to interpret formulas written by other users.
Topics Covered
- High-level overview of six Modifiers in Pigment
- Why and how to use Modifiers
- Allocation and aggregation methods
- Formula syntax, depending on a Modifier
- Formula wizard with the BY Modifier
Content Type
- Video
- On-Demand
- Micro-lesson
Course Duration
About 11 minutes
Before You Begin
Prerequisites: Make sure to complete the Introduction to the Dimensional world and Formulas before tackling this lesson.
💡 |
This course might also be available in other learning paths or catalogs within the Pigment Academy. Some course types, such as video, will mark your progress as complete across different learning paths, noting that you have already completed the content in that lesson. Take the course again if you want a refresher or move on to another course. |