Skip to main content

Explore the Community

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

911 Topics
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Company News
Pigment recognized as a Visionary in its first inclusion in the Gartner® Magic Quadrant™ for Financial Planning SoftwareNews

Today, we’re pleased to announce that Pigment has been recognized as a Visionary in our first inclusion in the Gartner® Magic Quadrant™ for Financial Planning Software. We believe this recognition validates the hard work that’s gone into building the Pigment platform and how we’ve partnered with our customers over the past few years. We’d like to thank our customers, partners, advisors, and employees, past and present, for getting us to this point. Inclusion in the Magic Quadrant™ is a significant milestone for Pigment, and it gives the team great confidence as we move into 2025 and beyond. To download your complimentary copy, click here. Gartner disclaimer:Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statem

350
Isabella Leslie-Miller
Community Manager
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Welcome to the Community!
Welcome to the Pigment Community! 🎉

Welcome to the Pigment Community!We’re so grateful to have you here! The Pigment Community is your place to collaborate with, learn from and inspire other Pigmenters. Why should you explore the Pigment Community? 🔎We want you to be as confident as possible with Pigment. Through the Community, you get to engage with peers to share knowledge and expertise on using Pigment. We encourage you to share your insights and learnings, as others might well be facing similar questions. Above all, we want Pigment users to connect and engage with each other! I’m new here, where should I start? 👀💡 Good thing you asked – here’s how to get started!Register and complete your profile. Add a profile picture and fill out your profile details. Introduce yourself! We encourage all of our new members to introduce themselves in our Intro thread. I saw someone with a shiny badge and cool title, how do I get one? 🏅We reward active users publicly through a variety of badges and titles. Once you start posting

10111
abhilashsawla
G
Newly Minted Pigmenteer
geoff_chovazNewly Minted Pigmenteer
asked in Questions & Conversations
Issue with (unwanted) date conversion in CSV import

I have a CSV file with a column indicating  the month dimension. It is “Jan 25”, “Feb 25”, etc. On the initial import screen it looks correct,however, as soon as I map it to the Pigment property (Month dimension type) it shows in the preview as My imported data is all loaded into the wrong months. I want it to just take the exact value in my CSV as the name for the Month dimension instead of converting a date. I tried double-quoting the field in the CSV, that didn’t help. Loading it into a regular text property works fine so it doesn’t appear to be an issue with the source data itself.  

10
G
Newly Minted Pigmenteer
F
Just Arrived
FranckLPJust Arrived
asked in Questions & Conversations
Launch multiple imports at once

Hello,I’ve created a Pigment app connected to a NetSuite environment. All my master data and figures are coming from this system. As of today, I need to update the dimension and transaction lists one by one by launching the related import task.Is there as way to create like a master import that launch everything at once to ease the maintenance of the app ?Thank you

91
Nathan
Employee
S
Newly Minted Pigmenteer
SHeckhuisNewly Minted Pigmenteer
asked in Questions & Conversations
ITEM() does not find data from Dimension

I am looking to normalise some Country data from different sources in different formats (e.g. some countries have full name others ISO codes). I have been using the ITEM() function to map all correct countries to our Master Country dimension.I was now planning on doing something similar by pulling in the ISO code dimension which is also linked to the Country dimension. However, the ITEM() function does not seem to return any values which confuses me. Ultimately, I am planning to then pull in the Country dimension from the ISO code and combine the two country fields via IF sentences. 

413
S
Newly Minted Pigmenteer
A
Newly Minted Pigmenteer
Aayush BatraNewly Minted Pigmenteer
asked in Questions & Conversations
Multiple level breakdown - G-sheet integration fails

If I break a metric by mutilpe break downs in a table in Pigment, at the time of exporting to g-sheet using Pigment connector, i don’t see any breakdown. i only see one row of data w/o any breakdown by dimensionsis this a product limitation or a bug ?

295
F
Employee
A
Employee
Adrien LEmployee
asked in Questions & Conversations
Key shortcut

Are any Key shortcuts in Development?A shortcut from Editing to User mode in Board would be helpful, and one for aligning Widget might be great. 

1172
X
Newly Minted Pigmenteer
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Different AR on a same metric based on different application

Is it possible to apply different Access Rights on a same metric based on different applications ?i.e. Metric A should have rule configuration of AR 1 (if metric A is used in App 1)and if the same metric A is getting used in other App (App 2 - by turning the sharing On), this metric should have access rights AR 2 AR 1 and AR2 are security metricsIs there any alternative solution for this?

132
P
C
Newly Minted Pigmenteer
CalvinNewly Minted Pigmenteer
asked in Questions & Conversations
Transaction List Lookup Formula Help

Month Seat Worker Future_Worker Future_Worker_Current_Seat Month Dimension Seat Dimension Worker Dimension Worker Dimension Seat Dimension Mar 25 POS-000100 Employee 1     Mar 25 POS-000200 Open Position Employee 1 ???  Looking for some help writing a formula. I have a transaction list called EE_Load_HRIS. I’m looking to write a formula that will return the Seat (POS-000100) in the Future_Worker_Current_Seat property where the Month matches Month and the Worker matches Future_Worker.

312
C
Newly Minted Pigmenteer
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Company News
New AI Features Released, More To ComeNewsletter

A big week for us at Pigment, having announced some very exciting company news on Pigment Agents, give it a like if you're as excited as us. In other news, spring is here and so are these new product features! 🤖 Agentic AI announcement - meet your new team members  🔃 Streamline collaborative processes with Sequences 📋 Revamp your Dimensions with List Subsets 🗺️ Add USA states and preset map positions in Map Charts 📉 Updates at cell-level 🪟 Use a dynamic window in MOVINGSUM/MOVINGAVERAGE 🔎 Make data-driven decisions faster with Insights 🌐 Best practice webinar for Workforce Planning on April 2nd 🗽 New York Roadshow & User Group on April 23rd ⭐ Help us feature in the Gartner® Magic Quadrant™ 🎟️ Fancy attending RevOpsAF 2025 in New Orleans? Get 15% off tickets!  Meet your new team members - Pigment AI Agents  In case you missed it, we're thrilled to share a glimpse into the future of planning with Agentic AI!This week, we've announced our three specialized AI Agents designed

220
Isabella Leslie-Miller
Community Manager
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
Circular Reference in 3 way statement

Hi CommunityI am reaching out to broader pigment users to how they solve these kind of issues in 3 way income statements?  ThanksMusab

1071
F
Employee
S
Newly Minted Pigmenteer
Santhosh KumarNewly Minted Pigmenteer
asked in Questions & Conversations
[NEED HELP] Connect Pigment with an External Service Through an API request

I am currently testing an external API integration in Pigment to retrieve a response and display it within the platform. Setup Details: I configured an API connection in Pigment. On the Action board, I added a card with a button to trigger the API call. When I click the button, the API call is successfully triggered. Issue: Although the API call is being made, I am not receiving any JSON response within Pigment. The response does not seem to be captured or displayed. Questions: Is Pigment’s external API setup only meant for POST requests, or can it also handle GET requests and return responses? Can I retrieve the API response and manipulate or display it within Pigment? If yes, what is the proper way to map or use the response JSON in Pigment? ​@Julien | ​@Igor P | ​@CDALMAY | ​@Thu Mai | ​@Jared Dolich 

332
S
Newly Minted Pigmenteer
B
Newly Minted Pigmenteer
BasNewly Minted Pigmenteer
asked in Questions & Conversations
How to link variables together?

Hello,I made a subset in my Month dimension list, in order to create a boolean metric that has Months in rows and columns. I named this subset ‘MonthTimeIntel’. Basically I wanted to create a boolean that checks what the trailing twelve months are for each month. Something like this:So far, so good. I then use this metric as a filter for my charts and graphs where I only want to show the last twelve months. Also: so far, so good. But lastly - I don't want another page selector on my dashboards. Because now the page selector for ‘MonthTimeIntel’ shows up on my dashboards, but I don't want that. Is there a way so that the MonthTimeIntel page selector moves in unison with my Month selector and so I can hide the MonthTimeIntel selector? I understand that they are two different dimensions, but it would be great if they can somehow come together.I hope my question is clear :-) Thanks for helping me out!Best, Bas 

251
Nathan
Employee
ankitgoyal01
Newly Minted Pigmenteer
ankitgoyal01Newly Minted Pigmenteer
asked in Questions & Conversations
Embedding Pigment in an external application

Can we embed Pigment in an existing application so that user does not require to change interface? Is there any SDK that can be made available to partners to embed in a proprietary application?

362
ankitgoyal01
Newly Minted Pigmenteer
R
Just Arrived
Raman BansalJust Arrived
asked in Questions & Conversations
The dynamic variable is not updating according to the metrics.

Hello Pigment Community,I have created a variable for each metric, and in the table, I have applied the individual variables to their corresponding metrics. I then pivoted the table so that the metrics are in the page selector. The issue I'm encountering is that when I apply a variable to one metric and then try to apply a different variable for another metric, it doesn't update as expected. I need variables to be updated as according to my selection. For example, I have two P&L metrics: Salary Cost and Expense. I’ve set individual variables for both metrics. However, when I apply these variables to different selections on the board, it shows the same variable for both metrics, even though I recently applied different variables for each.Could anyone assist with this? 

161
T
Employee
B
Budding Pigmenteer
BenedikteBudding Pigmenteer
asked in Questions & Conversations
API key Workday stopped working

Hi,I have an issue where the Workday api key stopped working and the data is not longer pushed from workday to Pigment. The Key in specific is called “Workday HCM People Planning” and is an important metrics for us in people planning. The Api key is still active in terms of expiration date 2026-01-01. Can someone please help me with this issue?Kind regards,Benedikte 

213
Stef
Employee
Spandan98
Seasoned Pigmenteer
Spandan98Seasoned Pigmenteer
asked in Questions & Conversations
Nest related dimensions into a single page selector with hierarchies

Hi Pigment Community,Can anybody kindly tell me if this feature is published for Pigment or are there any ways I can achieve this?Thanks!Please click on the link below:  

341
N
Employee
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Timeout Issue during import

Hi,I would like to know when we get timeout issue during Data import and how to solve it. 

1769
N
Budding Pigmenteer
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Career Forum
Career Spotlight - Thư Mai

This is the first post in our new series all about working in the EPM fieldIntroduction:Hello Pigmenteers! My name is Thư (​@Thu Mai in the community), I'm based in Vietnam and I’m currently working as an EPM Consultant at Keyrus. Keyrus is a global consultancy that develops data and digital solutions for performance management. Combining business and technical expertise, we help companies uncover the most value possible from data while optimizing digital strategy and customer experience. You can see Thư’s full interview here: What advice do you have for someone who is just starting out in the EPM field?Firstly, never stop learning. If you find motivation from learning and it energises you, then EPM consulting is a great career choice. In this career you have to learn lots of different tools, and also keep up with the latest news and changes that those tools have. Every week Pigment sends me a little notification on the gift box icon, and honestly if you don’t keep up with that it can

380
Isabella Leslie-Miller
Community Manager
J
Seasoned Pigmenteer
Justin GrooverSeasoned Pigmenteer
asked in Questions & Conversations
Combine MOVINGAVERAGE and PREVIOUS functions for run rate planning

I would like to write a formula where the intent is for the metric to calculate the average of the prior 3 months of the metric itself.I envisioned the syntax being something like the following, though it says MOVINGAVERAGE doesn’t support recursive mode.MOVINGAVERAGE(PREVIOUS(month),3)I understand that I could use MOVINGAVERAGE without PREVIOUS if the object being averaged was a separate metric, but the use case I have requires the formula to reference metric itself. Is there any solution or workaround for this?  

4672
E
Budding Pigmenteer
N
Newly Minted Pigmenteer
NeoNewly Minted Pigmenteer
asked in Questions & Conversations
Push data from Pigment to Looker

Hi CommunityHope you are well.I am wondering if anyone is using Google Looker as a dashboard/BI tool to report on data from Pigment and is there a way to push data from Pigment to Google Looker seamlessly? What I can find in Pigment documentation is pushing data from Looker to Pigment but not the other way around.The work around I’ve been using is pushing data from Pigment to GoogleSheet and from GoogleSheet to Looker but that requires manual refreshes and it’s not automatically synced (e.g daily) to share across the organisation with other users.ThanksNeo :) 

181
Nathan
Employee
R
Rockney_KPCFrequent Reader
asked in Questions & Conversations
Looking for a specific function

Hello,I’m looking for a specific function to make the calculation on this figure:  Can you please help me? Regards,

342
R
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Run action button to clear a metric if a notification is sent

There’s a grid in which employees are assigned to a project.Metrics: initial project and final projectIf both these projects are different for a specific employee, notification in pigment is working fine i.e. If there’s a change in project, to notify the relevant team leader of projects (both initial and final) - P1 and P2.However, there’s a metric called : “Override Project” , which can also derive Final Project.If there’s already a change in project name for Employee ABC (from P1 to P2 project), and then override of ‘P3’ is done (Now, P1 to P3 project), notification should be sent to team leader of projects (both initial and final) - P1 and P3 [P3 Must].Currently, triggering metric for workflow notification is Change in Project? with employee dimension.How can I check the logic again?

484
P
K
Newly Minted Pigmenteer
kevin_huangNewly Minted Pigmenteer
asked in Questions & Conversations
Page selector sizing keeps changing back to default size

 In the dimension drop down, when I expand the size of the page selector it doesn’t save (so everytime when I click into this dimension input it goes back to the default size - any way I can save the size of the page selector? 

1002
K
Newly Minted Pigmenteer
V
Newly Minted Pigmenteer
VikatzenNewly Minted Pigmenteer
asked in Questions & Conversations
Pulling the last available value with BY ->

I have the formula below: (('EE_Comp_01_SabbaticalAccrual_P&L_ReAllocated'    * EE_BU_AllocationFinal    )[BY: -> EE_Card_Department,EE_Card_SalaryCurrency, 'EE_Card_P&L', 'EE_Card_Direct/Indirect'])The highlighted in red, assigned my employees to the department that they belong for each month based on that metric. INSTEAD, I would like to just assign them to the last department they belonged to for each version.  I tried inserting “BY LASTNONBLANK: → “  but it did not seem to resolve the issue. See screenshot for the stracture of the EE_Card_Department below:  Basically I want to adjust the formula above, to assign this employee only to department FBS Revenue.  Any ideas? 

191
Nathan
Employee

Badge winners

  • Author
    geoff_chovazhas earned the badge Author
  • Partner Solution Consultant Certified
    M_Gaertnerhas earned the badge Partner Solution Consultant Certified
  • Innovator
    Lionel_Mhas earned the badge Innovator
  • Partner Solution Consultant Certified
    Hippohas earned the badge Partner Solution Consultant Certified
  • Partner Solution Consultant Certified
    Franciscohas earned the badge Partner Solution Consultant Certified
Show all badges
Terms & ConditionsCookie settings