Skip to main content

Explore the Community

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

900 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 stat

340
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 pos

10031
abhilashsawla
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:

241
N
Employee
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?

40
R
Just Arrived
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.

1709
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 field Introduction: 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 c

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

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

Hi Community Hope 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. Thanks Neo :)

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

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

374
P
A
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?

161
Luiza
Employee
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?

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

111
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!

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

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

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

381
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 beh

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

231
M
Employee
A
Just Arrived
AshishpJust Arrived
asked in Questions & Conversations
How Can I create a subset of Dimension list ?

For further calculation, I am trying to exclude a few members from the dimensions list items. Could anyone help me find the best approach to do that?

2313
F
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

354
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: YTD YTG These 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

322
Louie
C
Newly Minted Pigmenteer
CalvinNewly Minted Pigmenteer
asked in Questions & Conversations
Filter transaction list property by boolean metric

Struggling to figure out how to set up a formula properly. I’m trying to create an IF statement with a condition where it looks at a transaction list property with X dimension and if it matches to a boolean metric list where X dimension is flagged as TRUE then return A otherwise B. Transaction List = PL_Transactions Transaction List Property = PL_Transactions.Vendor Dimension = Vendor Boolean Data Type Metric w/ 1 Dimension (Vendor) = Draft_Vendors

442
C
Newly Minted Pigmenteer
B
Newly Minted Pigmenteer
Bryan BauerNewly Minted Pigmenteer
asked in Questions & Conversations
Rebalancing Forecast to hold Quarter Forecast

Hello, is there a best practice to rebalance forecasts to hold to the beginning of the quarter’s forecast. For example, if on Jan 1st, I forecast to spend $12k for Q1 ($4k per month) and then when I get to Feb 1st, I actually spent $6k in January. I now manually take $12k - $6k = $6k / 2 = $3k, and then I forecast $3k for each February and March each to hold the $12k for the entire Q1 forecast + Actuals. Is there an automated way (not manually doing the math and re-entering for the remaining months) to do this?

141
Min Li Bright Point
Spandan98
Seasoned Pigmenteer
Spandan98Seasoned Pigmenteer
asked in Questions & Conversations
Display only the unmarked options

Hello Pigment Community, I need help with automating calculations for specific brands in Pigment. Requirement: For the brands marked (e.g., checked/true), I want Pigment to automatically calculate the values. For the unmarked brands (e.g., unchecked/false), I want to manually input the data. Goal: I would like to filter the view to display only the unmarked brands (those marked as false), so I can easily input data manually. Thank you for your help.

422
L
Budding Pigmenteer

Most helpful members this week

Badge winners

  • Pigment Modeling Fundamentals Certified
    Pranjal_Pigmenthas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Pranjal_Pigmenthas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    Amynehas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Amynehas earned the badge Pigment Like a Pro
  • Partner Solution Consultant Certified
    Louis-Paulhas earned the badge Partner Solution Consultant Certified
Show all badges

Popular tags

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings