Questions & Conversations

Hello Pigment Community,I want to dynamically aggregate my data based on the selected time period—whether by month, quarter, or year—using a Boolean metric.Expected Behavior:If Month is selected (TRUE), the data should display only monthly values. If Quarter is selected (TRUE), the data should aggregate and display only quarterly totals. If Year is selected (TRUE), the data should aggregate at only the yearly level.How can I achieve this functionality efficiently? Any guidance would be appreciated!Thanks in advance! 😊

Hello,I know it is possible to block a scenario, but when it is blocked, this apply for all users.Is it possible to block a scenario for a contributor, but not for an admin ? If not, when do you plan to develop this feature ?ThanksAdèle

Hello, I have a metric “MD02 - Quel macro composant ?” which displays elements from the list “macro composant” and its total. The dimensions are “Composants” and “macro composants”.  I also have a second metric where I want to display the total with the only dimension “Composants” :  Do you know which formula I must use in this second metric please ?Thank you very much !

Hello,I have a KPI on the headcount planning board for budget owners showing the number of open positions. When there is no open positions, i would like the metric to show 0 instead of “nothing to display”. I tried putting a ifblank is my formula but i have an error message saying it is taking too long to calculate. Is there any way to show 0 ? ThanksVenitia

Hi Pigment Community,we have a use case in a project where we need to combine 2 special cases in the area of Switchover dates. We have multiple switchover dates for multiple data sources, as some supplier report only monthly and some other quarterly. So we need our Forecast calculation to start at different months for different data. We want to auto calculate the switchover date, by the last available data in the Actuals data set. I haven’t found a solution on how to automatically calculate the last Actuals month. For 1. I just created a multiple dimension metric with switchover dates for all data layers, which works fine for manually setting the month for the switchover dates.I then created second metric to calculate the last month with Actual data and this formula gives me the output for the last available month:'ACT_REV_Euro (in k)' [REMOVE LASTNONBLANK: Month] However, I was not able to transform or extract the Month value from the metric. Any formula like “MONTH()” or “TIMEDIM()”

Hi,I have a transaction list where data is imported daily from NetSuite into Pigment.Some modifications will be made to the NetSuite search where the data comes from, including the addition of new columns.I’m am not sure how this change will impact the import process in Pigment?Additionally, when I go to Import Data → Set Up Import, the data mapping does not open—it just keeps loading indefinitely. Does it mean I will have to recreate an import from scratch?Thanks in advance for your guidance!Best regards,

Tried enabling pigment AI but when I ask a simple question like “What’s the revenue in 2024?”, it is giving me a total Revenue that isn’t filtered, i.e. before drilling into FX25 or 24, Live & Stage version combined, 0+12 to 12+0 versions combined? 

Hi,I d like to know whether the scenarios under deployed applications (test n deploy) can be set to "disconnected" (except the default scenario(s)) ?The need here is to have basic scenarios with predefined rules to calculate baseline projections while alowing users to add scenarios with ad hoc simulations formulas.  

We’ve created two scenarios for the BP on 24: Target and BudgetThese two scenarios are items belonging to the dimension “Version”.In the attached table, we want to add two new comparative columns, one being "Target bp 24/FY23" and the other "Budget bp 24/FY23". However, it does not allow us to add this calculated item because we cannot compare different dimensions (version and year).How can we do this comparison? it is crucial to be able to compare as many scenarios as we want with the previous year's figures  

Hello Everyone. I am a beginner in Pigment and I am trying to replicate my excel model within pigment. My current excel model will take a unique count of my order number (order number replicates due to multiple sku in one order) and mark the order as 1 and the duplicate as 0. Example: (if A2=A1,0,1). This gives me the unique number of  orders in my transaction list. I cannot reference a cell directly using the if formula in pigment as compared to excel. Is there a an easier way to do this in pigment?  

Hello All,I accidently changed the data type for the column ‘order number’ from Text to number which resulted in the data being deleted. I changed the data type back from Number to text and tried reimporting the data back but it still does not shows the original data. Any help is appreciated  

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?