Community Knowledge Base Product Roadmap Full Course Catalog
Read and Interpret Formulas

Read and Interpret Formulas

Learn how to read and interpret formulas written by other users.

rate limit

Code not recognized.

Explore the syntax of Pigment formulas. Explore the syntax of formulas and identify its various components. Find out how Formula Playground and Formula Wizard help you to write formulas in Pigment. Identify when and how to use six Pigment Modifiers and most common Pigment Functions, including those which can convert data.

Who should take this learning path?
This learning path is designed for everyone, both business and technical users. 

  • Technical users will benefit from this path as it provides a comprehensive understanding of Pigment's formula creation. Covering Functions and Modifiers, the curriculum blends theory with practical exercises, emphasizing efficient navigation of complex data scenarios. The course also explores the strategic use of Pigment's Formula Playground and Formula Wizard, facilitating streamlined formula workflows. Featuring a real-world case study with Lemonade Stand company data, this course is essential for technical professionals seeking to enhance their proficiency in Pigment's formula creation and data manipulation.

  • Business users will benefit from this path as it equips them with practical skills for leveraging Pigment's formula capabilities. Focused on Functions and Modifiers, the curriculum ensures a balance between theoretical concepts and hands-on application, enabling business professionals to efficiently handle diverse data scenarios. Business users will be able to read and interpret formulas written by other users.


Topics Covered

  • Formula syntax and its various components
  • Referencing objects in Pigment Formulas
  • Six Pigment Modifiers
  • Most common Pigment Functions 
  • Data conversion Functions


Content Type
Learning path

Duration
About 3 hours

Before You Begin
Prerequisites: Pigment Essentials for Everyone, From Process to Experience: UX Design Journey

Three Essential Elements for Pigment Formulas
Three Essential Elements for Pigment Formulas
Learn how Metrics, Boards and Transactions lists contribute to writing formulas and forecasting in Pigment
FREE
5 mins
Video Micro-lesson Beginner Formula Writing On demand
Anatomy of a Metric
Anatomy of a Metric
Learn how Metrics, Dimensions and Data types contribute to writing formulas in Pigment.
FREE
3 mins
Video Micro-lesson Beginner Formula Writing On demand
Introduction to Pigment Formulas
Introduction to Pigment Formulas
Learn how to write basic formulas in Pigment.
FREE
7 mins
Modelers Micro-lesson Beginner Formula Writing On demand
Basics of Formula Writing
Basics of Formula Writing
Look into the essentials of crafting basic formulas in Pigment and lay a solid foundation, comparing and contrasting the syntax of Pigment formulas with that of Excel, to ensure a smooth transition for those familiar with spreadsheet environments.
FREE
40 mins
Modelers Intermediate Formula Writing On demand
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.
FREE
11 mins
Video Modelers Intermediate Micro-lesson Formula Writing On demand
Use Functions in a Formula Activity
Use Functions in a Formula Activity
Learn how to change a Data type of Metrics and List properties by using Pigment Functions.
FREE
45 mins
Video Intermediate Activity Formula Writing
Formula Playground Activity
Formula Playground Activity
Follow Issam, a Solution Architect at Pigment, in using the Formula Playground to create three different Metrics from one Transactions List, based on the data from the Lemonade Stand company.
FREE
40 mins
Video Intermediate Activity Formula Writing On demand
Formula Wizard Activity
Formula Wizard Activity
Follow Issam, a Solution Architect at Pigment, in using the Formula Wizard to create a formula with the BY Modifier, based on the Lemonade Stand Orders Transactions List
FREE
30 mins
Video Modelers Intermediate Activity Formula Writing On demand
Align Block Dimensions for Formula Operations
Align Block Dimensions for Formula Operations
This skill is critical for successful multidimensional modeling in Pigment
FREE
60 mins
Onboarding Modelers Intermediate Basics Advanced Activity Beginner Certification
Read and Interpret Formulas Quiz
Read and Interpret Formulas Quiz
Earn your Formula Reader Badge when you get 80% or more on the Quiz
FREE
20 mins
Quiz
Please let us know what you think!
Please let us know what you think!
Help us make Pigment's Formula Writing module the best it can be
FREE
3 mins