Skip to main content

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

Create post
Login

Welcome to the Pigment Community!

Explore the Community

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

Browse the Knowledge Base

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

Discover Tips and Tricks

Insider guides and best practices from the Pigment team

Featured topics

Hiring a Senior Financial Analyst at Discord!!

Hi All! My name is Aastha and I’m a Manager on our FP&A team at Discord! We currently have a new role that just opened up on our team supporting o

Forum|Forum|14 days ago

750

Explore the Community

Recently Active
Help Others
Categories

Isabella Leslie-MillerCommunity Manager

Help Us Shape Better Experiences at Pigment

Help Us Shape Better Experiences at PigmentSurvey

At Pigment, we’re committed to creating meaningful experiences that go beyond the product itself. To keep doing that well, we need your input. We’ve put together a quick 2-minute survey to better understand what resonates with you and to help guide o

RushiTrendsetter

Questions & Conversations

Ranking based on occurrence of sales order for an account for the quarter

I have a transaction data containing 3 columns:QuarterAccountSales OrderI need to insert rank columns wherein the condition is:For an account whenever gets any Sales Order in a quarter, it should be assigned a rank for the line items for the quarter

MKSMPBAuthor

Questions & Conversations

Adding YoY% columns to a table

I currently have a table with months and years in the columns and metrics in the rows. I want to have a YoY% appear as a column after each year for all metrics. i.e. FY26 | YoY% | FY27 | YoY% |Is this possible and if so, how to I go about it?

Matthieu WalletApprentice Author

Questions & Conversations

How to manually sort the Dimension items ?

Hi everyone,I’m a Pigment newbie, and I need support from you !I would like to manually sort the Items of a Dimension displayed in a Pigment Object.Let me show you an example :In the picture below, I want the “NA1” to be between “AU7” and “IN1”.I sel

gttApprentice Author

Questions & Conversations

How to lookup text in list to pull list property? (Non-unique list)

I have 2 lists, lets call them ‘list1’ and ‘list2’. ‘list2’ has two properties with all values populated: ‘name’ and ‘product’. ‘name’ is a text property with duplicative values and ‘product’ is a dimension ‘product L0’. ‘list1’ has the same properti

Moosa MalickWallflower

Questions & Conversations

Locking Version

Hi,I am trying to build a forecast in Pigment which can have multiple versions. Is there a way, we can lock formulas in versions? I know there is a scenarios feature, in which we can have formulas for different scenarios. Are scenarios the preferred

msoussApprentice Author

Questions & Conversations

Aggregate a formula

Hello,I have 3 metrics :- Capa Test (Dimensions: Macro Ressources, Mois)- Charge Test (Dimensions: Macro Ressources, Macro Item, Mois)- Saturation Test (Dimensions: Macro Ressources, Macro Item, Mois) : Saturation Test = Capa Test / Charge Test But a

NeoAuthor

Questions & Conversations

MCP server - Pigment x ChatGPT

Hi Community,I’m currently exploring the Pigment × ChatGPT integration using the new MCP server. However, it appears our IT team is not comfortable enabling Developer Mode in ChatGPT.Does anyone know when the connector is expected to become verified

Questions & Conversations

Snapshot FX locked at time of snapshot and cannot be recalculated with updated FX tables

Hi, I just wanted to get some advice on best practice around FX handling when using snapshots.We load our underlying revenue data in local currency and use an FX rate table to convert this to USD. However, it appears that when a snapshot is taken, th

Questions & Conversations

Restore application to a previous version

Hi,Does anyone know if there is a way to rollback an application to previous version before a certain change was made?

RushiTrendsetter

Questions & Conversations

Ranking based on occurrence of sales order for an account for the quarter

I have a transaction data containing 3 columns:QuarterAccountSales OrderI need to insert rank columns wherein the condition is:For an account whenever gets any Sales Order in a quarter, it should be assigned a rank for the line items for the quarter

MKSMPBAuthor

Questions & Conversations

Adding YoY% columns to a table

I currently have a table with months and years in the columns and metrics in the rows. I want to have a YoY% appear as a column after each year for all metrics. i.e. FY26 | YoY% | FY27 | YoY% |Is this possible and if so, how to I go about it?

msoussApprentice Author

Questions & Conversations

Aggregate a formula

Hello,I have 3 metrics :- Capa Test (Dimensions: Macro Ressources, Mois)- Charge Test (Dimensions: Macro Ressources, Macro Item, Mois)- Saturation Test (Dimensions: Macro Ressources, Macro Item, Mois) : Saturation Test = Capa Test / Charge Test But a

Questions & Conversations

Previous() Override

Hi,I have a metric that pulls data from previous version and has metric override on. In current version, is there a way to delete data that came over from previous version without that cell reverting back to formula based result even if I don’t input

BasMaster Author

Questions & Conversations

Compounded growth rates in as a calculated item or SVA in a table

Hello,I was wondering if it is possible to create a CAGR % in a table (via calculated items or SVA). At the moment I have a separate metric that calculates a CAGR on a granular P&L level, but once I pull that metric in my table it simply sums or

NeoAuthor

Questions & Conversations

Clone Data Across All Scenarios Not Working Anymore?

Hi teamJust wondering if anyone is facing the same issue. I was able to clone data from version to version (e.g Live Forecast → Forecast Q1) across all scenarios (Default, Optimistic...) but now the clone function only works on Default, and there is

Questions & Conversations

Is there a way to clear out scratch work in Sheet View?

Some of our users do a lot of scratch work in Sheet View. Is there a way to clear all those extra edits out and start from a clean slate?

Questions & Conversations

api trigger import configuration using connector

Hi, Following another post that has been marked solved (Is this now possible ?- create import configuration- add a connector- trigger the import with the api (that uses the connector)If not at the present when would tthis be available ?

Spandan98Master Author

Questions & Conversations

Select only one option from the Boolean metric. The other options get disabled.

Hello Pigment Community,I just want one option to be marked, if suppose Absolute is checked, then the other options (Percentage and fixed) cannot be checked. How can I do this? Please kindly guide me to perform this operation. Thanks a lot!

Cedric LJMaster Author

Questions & Conversations

Remove duplicate leads

Hello,I Have the below list of leads and I want to count 1 in the column Count only for the lastest lead of the company.The goal is to remove duplicate leads of my lead analysis.Thanks

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

1037 topics

Career Forum

93 topics

Company News

53 topics

Customer Leaderboard

Show full leaderboard

Show full leaderboard

Badge winners

MZWhas earned the badge Innovator
Yashsonihas earned the badge Pigment Modeling Fundamentals Certified
tjain02has earned the badge Helper
ljanowskihas earned the badge Winter Top Contributor
ahutsonhas earned the badge Winter Top Contributor

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 Cookie settings 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