Skip to main content

Explore the Community

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

925 Topics
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.

482
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

380
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

1181
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 

442
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 

371
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?

1372
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? 

181
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 

1193
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:  

411
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. 

2139
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

580
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?  

4782
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 :) 

301
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,

352
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?

614
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? 

251
Nathan
Employee
A
Budding Pigmenteer
AlinaBudding Pigmenteer
asked in Questions & Conversations
Sorting values in table with multiple dims

Hi community, I need to sort the values in the table from high to low but I need to pivot it to pivot x dims in columns (e.g. Country, Client, Opportunity). If I use the traditional Sorting function of Pigment, it will sort only within the last dimension (in my case Opportunity).Is there a way to sort values disregarding dimensions but still keep them in my pivot?Thanks!

502
A
Budding Pigmenteer
R
Rockney_KPCFrequent Reader
asked in Questions & Conversations
Specific calculation

Hello,I have this figure: and I need to make this calculation → Q1= (1,28+0,72)/3. But I don’t have this option in the calculated item. Can you please help me. Regards,

321
Min Li Bright Point
M
Budding Pigmenteer
MukulBudding Pigmenteer
asked in Questions & Conversations
Import data from one list to another

Hi, is there a way to import list items of one list into another list?

2095
Julien
Community Manager
A
Just Arrived
AravindJust Arrived
asked in Questions & Conversations
Actions

Can we group a list of actions in pigment into a process (Just like we have in Anaplan)? Is there such a capability?

601
L
Budding Pigmenteer
L
Budding Pigmenteer
LaszloBudding Pigmenteer
asked in Questions & Conversations
Page selector reverts to all items if variable metric returns empty

Hi, I’m working on a board that uses complex security and I want to limit the items in the page selector. The security model is based on cost centres and employees, and others.I want to display those employees in the page selector that match certain criteria (employee.criteria = true). For this, I have created a metric and used it as a dynamic variable (Technical Employees), then assigned it to the page selector.Due to the security model, some users will have no access to given employees, and therefore the metric used for the variable will return nothing, which is correct.However, in this situation, the board ignores the variable in the employee page selector, and incorrectly reverts to displaying all items to the user: Suppose I don’t use the variable in the page selector, but manually select the employees that match my criteria in the Available items. In that case, the page selector will return an empty result if the user has no access to those employees, which is the expected behavi

622
L
Budding Pigmenteer
Spandan98
Seasoned Pigmenteer
Spandan98Seasoned Pigmenteer
asked in Questions & Conversations
Sync select dimensions across metrics and tables

Hello Pigment community,Is there a option where when we select an item of a dimension in one metric or table, the other metrics and tables get synced with that item only and display data of that item specifically? 

261
M
Employee
R
Rockney_KPCFrequent Reader
asked in Questions & Conversations
keep value only on the last month of the quarter

Hello,I’m trying to make this calcul to keep only the value on the last month of the quarter:'EE_Ramping Employees' [By lastnonzero: '[01] OBROC_DATA HUB'::Month [FILTER: '[01] OBROC_DATA HUB'::Month.Quarter <> '[01] OBROC_DATA HUB':: (Month + 1).Quarter].Quarter] But I got this error message:  Can you please help me. Regards,Rockney

454
R
B
Newly Minted Pigmenteer
BasNewly Minted Pigmenteer
asked in Questions & Conversations
Full year as calculated item

Hi everybody,I have a grid with two time-dimensioned calculated items. One is YTD and one is YTG where they cumulate using the selected month: YTDYTGThese work fine, but I also want to create a calculated item that shows the sum of both YTD and YTG (i.e.: full year). I couldn't get it to work via calculated items in the same grid, so as a workaround I made a second grid that shows the full year P&L. Although that workaround is okay-ish, I'm sure there must be some (better) way to get Month | YTD | YTG | FY in the same grid?Thanks, Bas

432
Louie

Badge winners

  • Read and Interpret Formulas Certified
    Alejandrohas earned the badge Read and Interpret Formulas Certified
  • Bug Hunter
    Malt DEhas earned the badge Bug Hunter
  • Pigment Like a Pro
    Nusaybahas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    Nusaybahas earned the badge Pigment Modeling Fundamentals Certified
  • Read and Interpret Formulas Certified
    Seydou Kanehas earned the badge Read and Interpret Formulas Certified
Show all badges
Terms & ConditionsCookie settings