Write and Test Formulas
Learn how to write advanced formulas in Pigment and earn your Formula Writing Badge.
Work with Dimensionality in Formulas
Learn how to work with Dimensionality and how it influences formulas within Pigment.
FREE
1h50
Modifiers for Misalignment
Discover how the Pigment Modifiers: ADD, REMOVE, BY, and SELECT play a crucial role in adjusting dimensionality, enabling refined and targeted data analysis tailored to your specific needs.
FREE
60 mins
Interactive Source to Target Mapping Tool
Align Dimensions between your source Block(s) and target Block to practice Source to Target Mapping using Pigment's Functions & Modifiers Application
FREE
Optional
Modifiers for Data Adjustment
Dive into the dynamic world of Pigment Modifiers including EXCLUDE, FILTER, and SELECT, which are pivotal in adjusting your data within formulas, allowing for precise and targeted analysis.
FREE
60 mins
ADD & REMOVE Modifiers
Learn how ADD and REMOVE Modifiers function within Pigment and their distinct roles compared to the BY Modifier and delve into their syntax required for effective application.
FREE
60 mins
FILTER & EXCLUDE Modifiers
Explore the FILTER and EXCLUDE Modifiers in Pigment through detailed instruction, the appropriate syntax for each, real-world use case examples, and delve into the theory behind effective data filtering, especially using ‘CurrentValue’.
FREE
45 mins
BY Modifier
Gain an in-depth understanding of the BY Modifier's application, guiding you through its correct syntax, the underlying theory of its operation, and practical use cases.
FREE
2h
BY -> Modifier
Explore the BY -> modifier, its syntax, the rationale behind its use, and its distinct comparison with the standard BY Modifier.
FREE
10 mins
SELECT Modifier
Delve into how the SELECT Modifier functions, learn to accurately apply its syntax across various use cases, and understand its role in aggregation methods as well as explore a comparative analysis with other essential modifiers like BY, FILTER, and REMOVE, highlighting the unique advantages and applications of SELECT.
FREE
60 mins
Apply Modifiers in Formulas Exercise Guide
Earn the Formula Writing Badge when you successfully complete 7 exercises where you apply what you learn about modifiers in the Write and Test Formulas learning Path
FREE
3h30
Please let us know what you think!
Help us make Pigment's Formula Writing module the best it can be
FREE
3 mins