Community Knowledge Base Product Roadmap Full Course Catalog
Introduction to Modifiers

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.

rate limit

Code not recognized.

About this course

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.  

About this course

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.