Skip to main content

- - Search Insider Guides
  - Insider Guides
  - Technical tips67
Knowledge Base
Academy
Events
Groups

Create post
Login

Welcome to the Pigment Community!

Start Here!

Get oriented, explore resources, learn, and connect with others

Find an Answer

Ask a question and find answers from other users in the Pigment community

Explore Pigment AI

Learn all about Pigment's latest AI features and best practices.

Discover Tips and Tricks

Insider guides and best practices from the Pigment team

Submit a Product Idea

Share your ideas for improving Pigment directly with our product team

Browse the Knowledge Base

Technical documentation to support your day-to-day use of Pigment

Featured topics

Getting Started with the Modeler Agent: Prompting Playbook

The Modeler Agent is at its best when you provide context, a clear goal, and a defined output format. When you nail the prompt, it doesn’t just save t...

Forum|Forum|13 days ago

940

Thu, Apr 9, 2026, 12:00

Paris User Group

Prompting the Pigment MCP Server connection

Forum|Forum|7 days ago

290

Explore the Community

Recently Active
Help Others
Categories

lucasEmployee

Give Your Agents a 20/20 View with AI Data Access

Give Your Agents a 20/20 View with AI Data Access

You ask a Pigment AI Agent a question that should be straightforward—only for it to respond that it can’t access the data and suggests checking your settings.In most cases, the issue isn’t the question you asked. It’s that the Agent doesn’t have vis

Ben EssalamaApprentice Author

Questions & Conversations

Metric to metric import

Hello, Currently I have my sales forecast by SKU and Month. I added to it, the “Switchover date” from Actuals to forecast to have some versioning. Now, I want to import this metrics to another metrics to only have the final version of the sales forec

NeoAuthor

Questions & Conversations

Looking for solution to sum up data slices

Hi everyone,Has anyone come across the need to sum data across different slices?We have three separate entities, each forecasting under a different scenario (as shown in the table above). We’d like to sum these three combinations together, but we hav

Ben EssalamaApprentice Author

Questions & Conversations

Conditional Percentage allocation

Hello,I am preparing input metrics to be filled in by the sales reps for the forecast.In the process they must allocate the “Fit Option” based on percentages by Model.However, for the model “A4”, “B4” and “C4” they can only fill in the “Fit option” “

Guillaume Langlois DTTEApprentice Author

Questions & Conversations

In the same board : Automatically manage MTD / YTD / FY time aggregations, together with organisational / consolidated aggregation for different type of data (volumes/financials, stocks, average/ratios, calculated metrics, ....)

Automatically manage MTD / YTD / FY time aggregations, together with organisational / consolidated aggregation, for the following data types: “Stock” type – MTD: monthly value, YTD: same as MTD, FY: value of the last forecast month of the year “Wei

Guillaume Langlois DTTEApprentice Author

Questions & Conversations

Display Monthly / MTD / YTD / FY / YTG and variance (in Amount and %) for 4 versions (1 main and 3 subs) + Version name display + Selector use only

Within a single report, display a “Monthly” view limited to the main version (current Fiscal Year - FY) only (i.e. no monthly view for prior years), together with MTD / YTD / FY / YTG views for three other versions (N-1, Budget, latest Forecast), a

BasMaster Author

Questions & Conversations

Exclude 'old' months from page selector options

Good afternoon,Is there a way to exclude ‘old’ months from the available items in page selectors? Currently I have a P&L that uses a dynamic variable (‘latest month’) as a source for the YTD calculation in a calculated column. Users can change th

Kevin Leadbeater 2Apprentice Author

Questions & Conversations

Model Builder Agent wrote formula into blank metric which was created for a different purpose

I think the Model Builder wrote formula into blank metric which was created for a different purpose.Is this a known issue? Can Pigment recommend a method for me to ‘protect’ a metric from reuse? I guess I could have caught it when the agent asked app

Julie GuérinEmployee

Understanding Versions and Scenarios in Pigment

Understanding Versions and Scenarios in Pigment

Versioning is a foundational concept in Pigment and in planning more broadly. While it has been referred to by many names throughout the history of Enterprise Performance Management—such as Scenario, Cycle, or Plan—in Pigment, we use the term Version

rachelaumaisApprentice Author

Questions & Conversations

Pigment MCP Server Control

Does Pigment support scoping an MCP API key to specific applications, instead of to the entire workspace? I understand that MCP only has access to AI enabled metrics, but some apps I want enabled for MCP and others just for native Pigment AI function

Ben EssalamaApprentice Author

Questions & Conversations

Metric to metric import

Hello, Currently I have my sales forecast by SKU and Month. I added to it, the “Switchover date” from Actuals to forecast to have some versioning. Now, I want to import this metrics to another metrics to only have the final version of the sales forec

NeoAuthor

Questions & Conversations

Looking for solution to sum up data slices

Hi everyone,Has anyone come across the need to sum data across different slices?We have three separate entities, each forecasting under a different scenario (as shown in the table above). We’d like to sum these three combinations together, but we hav

Ben EssalamaApprentice Author

Questions & Conversations

Conditional Percentage allocation

Hello,I am preparing input metrics to be filled in by the sales reps for the forecast.In the process they must allocate the “Fit Option” based on percentages by Model.However, for the model “A4”, “B4” and “C4” they can only fill in the “Fit option” “

Guillaume Langlois DTTEApprentice Author

Questions & Conversations

In the same board : Automatically manage MTD / YTD / FY time aggregations, together with organisational / consolidated aggregation for different type of data (volumes/financials, stocks, average/ratios, calculated metrics, ....)

Automatically manage MTD / YTD / FY time aggregations, together with organisational / consolidated aggregation, for the following data types: “Stock” type – MTD: monthly value, YTD: same as MTD, FY: value of the last forecast month of the year “Wei

Guillaume Langlois DTTEApprentice Author

Questions & Conversations

Display Monthly / MTD / YTD / FY / YTG and variance (in Amount and %) for 4 versions (1 main and 3 subs) + Version name display + Selector use only

Within a single report, display a “Monthly” view limited to the main version (current Fiscal Year - FY) only (i.e. no monthly view for prior years), together with MTD / YTD / FY / YTG views for three other versions (N-1, Budget, latest Forecast), a

BasMaster Author

Questions & Conversations

Exclude 'old' months from page selector options

Good afternoon,Is there a way to exclude ‘old’ months from the available items in page selectors? Currently I have a P&L that uses a dynamic variable (‘latest month’) as a source for the YTD calculation in a calculated column. Users can change th

rachelaumaisApprentice Author

Questions & Conversations

Pigment MCP Server Control

Does Pigment support scoping an MCP API key to specific applications, instead of to the entire workspace? I understand that MCP only has access to AI enabled metrics, but some apps I want enabled for MCP and others just for native Pigment AI function

AlinaMaster Author

Questions & Conversations

Aggregation in Org Chart

Hi community,I built an org chart by project where one project has multiple people, and each person has an associated cost. When aggregating to the project level, I would expect to see the sum of the costs, but instead it shows FirstNonBlank, and the

GaneshDApprentice Helper

Questions & Conversations

Pick last month of the year's data only and display it at yearly level

I have a metric with Budgeted Headcount at monthly level. I want to achieve the same metric at yearly level but the headcount at yearly level needs to be the headcount as of the last month of the year and not a summary of all months. Need help with t

YaejisMaster Author

Questions & Conversations

Hello! Is it possible to sort the view dynamically such that the Month would automatically change to the current month?

Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

Welcome to the Community!

Welcome to the Community!

6 topics

Questions & Conversations

Questions & Conversations

1075 topics

Career Forum

94 topics

Company News

56 topics

Customer Leaderboard

Show full leaderboard

Show full leaderboard

Badge winners

thomas.yeehas earned the badge Read and Interpret Formulas Certified
Patrick Sieveringhas earned the badge Partner Solution Consultant Certified
Sebastienhas earned the badge Partner Solution Consultant Certified
lucashas earned the badge Rare Author
lucashas earned the badge Author

Show all badges

Employee Leaderboard

Show full leaderboard

Show full leaderboard

Need more help?

Contact Customer Support

Contact our Support team and we'll be happy to help you get up and running!

Contact Partner Support

Contact our Support team and we'll be happy to assist you!

Powered by Gainsight

Terms & Conditions Accessibility statement

Sign up

Already have an account? Login

Single Sign-On Need help?

Log in with your Pigment account

Log into the Pigment Community

Single Sign-On Need help?

Log in with your Pigment account

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK