Questions & Conversations

Is there an option to also add the timestamp of an import, not just the date but also the hour?  

Hello Pigment Community,If I update my calendar start date from Jan 2016 to Jan 2021, will it impact the assumptions I’ve already entered for different scenarios? Will I lose any input data because of this change?Thank you!

I’m currently converting a table into Sheets and running formulas on the side to build checks, for example for the Balance Sheet. When I add new rows to the table however, the formulas don’t stay on the original cells. Is there a fix for this?

There are limited graphing capabilities in Pigment today vs. what’s available in Powerpoint, for example.You can not do multi-axis graphing feature today in Pigment.  An example of stacked bar of loan balances and then adding the yield trends in %s on top.Even on a single axis graph, you can not do a trend line graph on top of a stacked bar There are some valuable features from Think-cell plug-in to Powerpoint that would be helpful in Pigment (https://www.think-cell.com/en).  Below is an example of showing % increase between the stacked bar (a think-cell feature) Also, given that you guys are Pigment, we would have expected more color palette options for graphing but it’s very limited at the moment when we have various data points :) 

How do I download an audit log as a csv file into my hard drive?

Hello, I’m sure my question is super easy to answer, but I’m stucked on a silly calculation.I import a transaction list from my ERP with the amount in local currency.The properties linked to dimensions in my transactions are : Employee, project, month and currencyI have a metric that store the currency rates with 2 dimensions : currency and month I want to create a new property in the transaction called amount in EUR which is equal to amount * currency rate from the metricI tried transaction.amount*rates [BY: currency, month] but i does not work. It sums the value of the currencies for all the months and all the currencies.Can someone tell me where I am wrong ?

Hi everyone,I’ve come across a need to compare the current year’s forecast against next year’s live forecast, and noticed that this requires referencing two dimensions: Year and Version, or Year and Scenario. For example, I’m trying to build a variance table for a set of metrics where the variance is calculated as:(2025 Year + 2025 Forecast Snapshot) – (2026 Year + 2026 Live Forecast).Has anyone built something similar—where you can select different years and different versions (or scenarios) and calculate the variance between them?Thanks in advance!

Hi everybody,I am making an event calendar for next year. This calendar contains all different kinds of events (like the winter olympics 2026, valentines day, etc.). This information is stored in a boolean metric dimensioned by Day, Event and Business Unit. Like so: Next - I would like to summarize this information in a text metric dimensioned by week and business unit. I would like to create a simple textlist of the Event dimension where any boolean is true. Like so:W6 FY 26: Winter Olympics 2026 W7 FY 26: Winter Olympics 2026, Valentines dayHow to best go about this? Any help is much appreciated. Thanks! 

I have below metric for selecting the last month of the year.I’m using it as a dynamic variable for Month dimension.I want to use it for YoY% (“Selected Year” vs. Previous Year) headcount variance. But it doesn’t work. How do I make this work? Or, how do I make a similar logic to calculate it for the Year (property of Month) selected from the Pages (being dynamic)?Currently, I’m calculating it for a specific Year (unlinked from the Pages in the main board) like below. P.S. The variable works well in Filter. 

Our team is thinking about future Pigment updates, primarily the upcoming AI capabilities.  We are looking at bringing in more dimensions into our modeling to help better isolate actionable insights and plan at a more granular level.  As a result, our source datasets (which we will bring into Pigment as transaction lists) are going to grow significantly.  From millions to perhaps up to 100 million records.  Are there any limits to the size of a transaction list?  Will overall performance suffer?  Just want to get a sense of the possible.Thank you!

Hello, I get a transaction from my ERP with not a specific date by line but a start and a end dateEmployee Project Start End Hours Emp001 Proj1 01/01/2024 05/01/2025 5 Emp001 Proj2 02/01/2024 04/01/2024 2  I need to create a metric with Employee/Project/Day dimensions in which for each dates between the start and end I put the number of hours     01/01/2024 02/01/2024 03/01/2024 04/01/2024 05/01/2024 Emp001 Proj1 5 5 5 5 5 Emp001 Proj2   2 2 2    Could you explain me the best way to do it ?

If there is a dimension list called “Documents list” , there is a boolean metric A with dimensionality “Documents” list and “Team” It’s a boolean metric which tells the documents are relevant to which all team(s), if a document XYZ is marked checked for “Team 1” and “Team 2”, then in the top page filter while choosing either Team 1/ Team 2 , “document XYZ” row should show upHow to create another dimension list say “Detailed documents” dynamically

Hi! I am trying to apply a calculated item to just one metric in a table and not to all of them. Basically, be able to display this (see photo attached), where I can assign no calculation to some metrics. Do you guys know how to do it?  Thank you! 

Hi! I have a dimension that is currently adding more and more data given that it is being triggered by an import in another tx list. Do you know how I can remove that trigger?  Thank you! 

I want to sum every month; for example I want March 2026 to be the sum of March 2020 + March 2021 + March 2022 + March 2023 + March 2024 + March 2025 (so anything after the actuals month needs to be a calculation of all prior months. Is that possible? 

Hi Team,Is there a way to update the formatting of all parent rows at once?For example, we have data at the Location level in rows, with Country set as the parent. Instead of formatting each country one by one, can we apply the formatting to all parent rows together?I believe this would help us save significant time and effort.Thanks & Regards,Spandan

Has anyone received an error trying to set up an SFTP connection with ADP? It seems to be finding the file OK (we get a different error message if we put a non existent file) but is generating this error in Pigment: “Error while uploading the file. Cannot get the size of '/fromADP/xxxxxxxx.csv'" I’m not sure if it’s a permissions issue or something else. 

Hi everyone,I would like to display both Code and Name of a Dimension, in a Table.Below is the objective which I created from screenshots:In the first row, “CESSION” is the Name of the Code “AU1”, in the “Business Area” Dimension.Thanks !

Is there a way in Pigment to submit a button?(i.e. similar to marking a checkbox as True)

I want to be able to make specific notes about forecasted line items to document the rationale for the forecast.  This would be particularly useful for when a default forecast calculation is overridden to be able to have documentation.  Comments don’t seem to be a viable solution for this, as the comment can only be made on a cell within a grid, and if that cell is no longer visible in the view, (i.e. the switchover date changes and the forecast is hidden and replaced with actuals), it’s not there for anyone updating the forecast to see. I also dislike that comments are permanent and cannot be removed. Has anyone come up with a solution for this that they would be willing to share?

Hi,I have a set of metrics for wich I want to copy the input from one version to another.Version is a dimension ex: Budget 2025, Reforecast 2025….I have in mind something like using the function “ copy input between scenario” but at a version level.Thanks

Hello, Can anyone tell where I am going wrong here? 

HelloCould you please tell me how can sort the below formula so I don’t have the time out formula error ?Formula : roundup(IFBLANK(((('Wallet Lifetime Value'*0.7)[ADD : 'L9 - P&L']-'Input Wallet Upfront'[REMOVE : 'L9 - P&L'])[FILTER : 'L9 - P&L'='L9 - P&L'."Wallet fees"]/ 'Wallet Lifetime'[ADD : 'L9 - P&L'][BY:'SalesForce opportunities'.'Activity level 2'][FILTER : 'L9 - P&L'='L9 - P&L'."Wallet fees"])[FILTER : CURRENTVALUE >= 0],0),2)Thanks