Questions & Conversations

Hello,I created a new metric named "EmpData-Allocation" (with dimensions "employee" and "month") filtering only the existing employees, that I fill each month manually with a dimension named "allocation". How can I add this metric by employee to the dimension list "employee" ?  example :My employee transaction list is an import from Workday. In this transaction list, I have a new employee named “Employee1”.In my dimension list “Employee”, I have all the info for Employee1 coming from this employee transaction list. In the metric "EmpData-Allocation", I put Allocation1 for Employee1. I would like to have this Allocation1 next to Employee1 in the Employee dimension list. Can you please advise ?  Thanks

Hello Pigment Community,I hope you're all doing well!I’ve created a table with the following metrics:Month Amount Blended Interest(Please refer to the attached screenshot for reference.)Currently, I have a checker metric set up for conditional formatting, which highlights a month in red if it is greater than the closing period.Here’s what I’m trying to achieve:If a month entered is greater than the closing period, I want the Amount and Blended Interest metrics to become non-editable so users cannot input data in these fields. If a month entered is less than or equal to the closing period, users should be able to input data as usual in these metrics.Could anyone guide me on how to set this up in Pigment? Your assistance would be greatly appreciated!Thanks in advance!    4o

I have a metric that includes three dimensions—DimA, DimB, and DimC—along with a corresponding dollar amount for each intersection. I’d like to create a new metric where DimA and DimB remain as dimensions, but DimC becomes the result instead of a dimension for each of the intersections in the first metric. In doing this, I also want to drop the numeric data type and just have it as a dimension data type What would be the best way to achieve this in Pigment?

Hi Community!I've faced with the wierd problem while importing data from CSV to Transaction List.In CSV file the text field value is "Central LATAM” - the second part in uppercase, but when importing I've found this field in Pigment Transaction list as “Central Latam” - with only first letter uppercase.What could be the reason and how to avoid it during import? Many thanks!Yuri

Hi, I would like to consult what is the best formula to Cumulate a metric where I need to add a start date. To give more context, this is the current formula I have:CUMULATE('Metric1', month dimension) [SELECT: month dimension-3]I need to deduct 3mos as well thus there is -3 in the formulaThe start date of my cumulate should be from January 1, 2023  Thank you! 

Hello Pigment Community,Do we have dynamic cell access feature in Pigment?For example: I want users to just edit the Vintages and not the vintages that are already filled. (Context: This is a calculated field, but I have allowed data input override of the metric)How can I just edit the Vintages and add values to the Vintages that are not filled and the ones that are filled or already calculated be non editable? Please kindly help.Thanks!

Hi Team,While implementing Workforce planning for Pigment PRO Training, there’s a requirement where we are suppose to write formulas for Annual Benefits, Annual Bonus etc. While implementing this, I have noticed that - I am getting some warning which says “You do not have access to any of this metric data” as I am trying to fetch metric from another application. Please note that, I have made sure that - Shared Block is activated for my dimensions, metrics in Data Hub Application. Can you please let me know what could have been wrong in this case? 

currently the user needs to expand the filter selection and select the specific filter criteria. Was wondering if there is any action buttons similar to “SLICERS” in Excel ?

I am trying to select N number of months back fin a given metric based on an in Input Metric. The Target Metric is dimension by Type in the rows and Month in the Column. The Input metric is dimensioned by Type and I have assigned a differing number of months to each type. The Calculation Metric in which I am placing the Formula should offset and select the value N Number of Months back based on the Input Metrics Months.Here is an example formula:Formula Metric:‘TargetMetric’[SELECT: Month - InputMetric] but this throws an error about the month dimension.How can I select a certain value from the target metric N number of months back based on an Input Metric?

Great to see this new functionality!  2 questions:Is there a way to preserve formatting in Excel (i.e., to refresh data in a report) I cannot see an option to “push” data, only to pull.  What am I missing?Thanks! 

Can I conditionally format dates? I only see the option to conditionally format based on text or value

How to check the usage of a shared scenario?

Is there any way to highlight Boolean formatted or Text formatted metric using Conditional Formatting ?

We’re supposed to have a download button for the dependency diagram but it isn’t showing up for me. Any idea why? 

Hello Pigment Community,This is my achievement% Metrics This is my Min and Max % Metrics And this is my incentive structure metrics,Now here (1,2,3 and 4) signifies the slabs, that is, if the achievement% is between the min and max percentage then it will receive the incentive of the following slab, for example if a person achieved 102% and is a team member, he will receive 30% as incentive and so on.This is my final metric:  Please kindly guide me with the formula, the formula which I entered is not showing correct results.Thanks a lot!

Hello Pigment Community,I hope you're all doing well!I have a 4-level hierarchy for dimensions, ranging from L4 to L1 (screenshot attached). Currently, I’m displaying the L2 level (e.g., Vintage I, Vintage II, etc.), as shown in the attached screenshot. What I’d like to achieve is to create a button that filters the view based on the parent dimension (Fund 1, Fund 2, etc.). For example:If "Fund 1" is selected, the view should only display the L2 items (e.g., Vintage I, Vintage II) associated with Fund 1. Similarly, selecting "Fund 2" would filter the view to display only the L2 items linked to Fund 2.I understand we can use page selectors, but I want this set up for a specific widget and not for the whole board.Could someone guide me on how to set this up? Any help would be greatly appreciated.Thank you in advance!

Metric ABC is a formulated metric,Initial value is 100 and due to some downstream data updation, newer value is 150.Is there any formula/function to check the 100? 

 I am now in the process of creating an integration user for all the import set ups so the ownership is not tied to a specific person. But in process of doing that I was wondering if there is a way to switch between those accounts while working in the system? Or will I need to always log out and log in with the new user? 

Hello, I’m trying to import a csv file (Employee referential) into a Dimension List (Employee Referential List). The target Employee List has 5 properties : ID (“generate unique ID” setting toggled), Name, Country, Cost Centre & Salary band. I’ve set the ID property with the “generate unique ID” parameter (+Integer format), because the CSV file has 2 employees with the exact same name (but not the same country).I get an error message preventing me to run this process (in the “map data” step): “The unique Property “ID” has to be mapped”. (the source is grayed since it’s an automatic property.) Is there a problem somewhere? Pigment doesn’t allow a direct import to a dimension list having an “auto-generated ID” property? (Sorry if this was mentionned in one of the academy paths, but didn’t find this precise information. I just found that it is possible with a transaction list, but a dimension list should be more appropriate since we are talking about a referential update).Below the ma

I am trying to build a metric to forecast interest income on corporate cash. To do so, I’d like to reference our forecasted cash balance from the balance sheet & cash flow statement. This becomes circular since our interest income rolls into net income which then drives our indirect cash flow statement. I believe I could accomplish it by using the previousbase() function but the various metrics are all across different applications. The interest income & revenue metrics sits in a revenue application that feeds into a nexus in the data hub which then feeds the cash flow statement in a financial reporting application. Does anyone know a way to create this metric given the above criteria?

Hi Pigment Team,I hope you’re doing well.I have a question regarding the notification settings in Pigment. Specifically, I would like to know if it’s possible to send email notifications directly to a group created within Pigment.This need arises from a requirement to send notifications to a mailing list. While I understand that mailing lists are not directly supported in Pigment, I was exploring whether using groups could serve as an alternative.I’d appreciate it if you could clarify whether this functionality is currently supported, and if not, whether there are any workarounds or future plans to include it.Thank you for your time and assistance!Best regards,Bogachan Fatih

Hi Pigment, Do we have the ability to create a pie chart with only the top 10 of specific dimension values?I wish to have this Chart live with the most updated Top 10 values. Thank you,Omer.

Hi,Can anyone suggest how can we create hierarchies using dimensions list and use it & how we can input values at a total level and get it break-back down at item level?Thanks

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!

Hey,Is there any way to do Text to Columns in Pigment?Currently trying to resolve this dynamically:Dimension List: Player DetailsSr. No. Player Name Participated Sports (In this column, concatenated sports are there)Dimension List: SportsId NameNeed to create a boolean metric with dimensions: “Player Details” and “Sports” ; which can check if a sport has been played by a specific player or not i.e if it exists in “Participated Sports” or not