Questions & Conversations

Hi all, Before Pigment, when we used to run on our planning on spreadsheets, if an investor wanted to see how our model worked, we could make a version of ur planning model spreadsheet, which we could share with them and they could then get one of their analysts to dig down into the spreadsheet modelling to see how it worked for themselves... … but, having fully migrated from spreadsheet modelling to Pigment, what do we do now,?Assuming the investor has no prior knowledge of how Pigment works, we can’t just give them access and tell them to take a look for themselves, like we used to do with spreadsheets. So, I am interested to know, what do people do in this situation? What do you give them to look at to demonstrate the model works? Or is it that they can no longer look for themselves and must rely on guided tours/demo from us, instead?

Hi everybody,To my great surprise I saw that the powerpoint connector is now available. Christmas came early this year. I immediately tried it and already noticed a few things. But I was curious about the experiences of other users. For example - with grids, I noticed that the export of the grid sometimes moves beyond the border of the visual in powerpoint. And since it's a static picture there is no way to retrieve the rows or columns that fall under of after the border of the powerpoint visual. Another thing that I noticed deals with the width of the columns. For example, I have a certain grid that has columns in a certain width so that all the text fits. The export to powerpoint however squeezes the width of the column so you can't read all the text.Has anybody experienced the same or knows a workaround solution to these types of issues?Thanks, Bas 

Hi everyone,I duplicated Applications in order to test some new Pigment functionnalities without impacting Live Applications.There are 3 apps which are linked together (Shared metrics) Tests are over ; I’d like to delete those Apps, but Pigment show this message :“Cannot delete application: some of the shared objects are still referenced by other applications.”We have around 200 Shared Blocks !Must we delete each Shared Block before Pigment allow us to delete the whole App ? Thanks for your support !RegardsMatthieu  

Some of our users do a lot of scratch work in Sheet View. Is there a way to clear all those extra edits out and start from a clean slate?

Hello,I would like to test the ppt connector you are currently working on .Can you contact out to me ? Thanks

Hi,Is there a way to create a master button to import data in mutiple metrics at the same time instead on having to click 20 times (20 metrics) on each import data button ? Thanks for your help

Hi Everyone,I would like to merge two Dimensions into a new Text Dimension in order to get a Unique ID, using a FormulaBut the trick is that one of the two Dimension is a Date Data Type :Dim1 : Item.Code (Text Type)Dim2 : StartDate (Date Type)Formula result : Item.code &”_”& StartDateHow to make this formula ?Thanks in advanceMatthieu

Hi, Following another post that has been marked solved (Is this now possible ?- create import configuration- add a connector- trigger the import with the api (that uses the connector)If not at the present when would tthis be available ?

Hi everyone, I have two questions regarding input configuration in Pigments. 1. Conditional input depending on the versionWhen I enable data input in the metric settings (by checking “Allow overriding formula result with an input”), the input becomes available for all cells.However, I would like to enable input only for specific periods depending on the selected version.For example, for the Forecast Q2 version, the cells should be editable only from Q2, while Q1 should remain read-only because it contains actuals.Is there a way to restrict input to specific periods depending on the version? 2. Input

Hi Community,I’m currently exploring the Pigment × ChatGPT integration using the new MCP server. However, it appears our IT team is not comfortable enabling Developer Mode in ChatGPT.Does anyone know when the connector is expected to become verified so we can integrate Pigment with ChatGPT without needing to rely on Developer Mode?ThanksNeo

The first time I pulled data from Pigment into Excel, everything worked correctly and the data loaded. However, when I tried to pull the same dataset again using the same filters, I received an error saying: “The view is too big to be displayed.”How can I resolve this issue? 

Hi - do model snapshots factor in Access Rights? In other words, if a user takes a snapshot but does not have full access, will the snapshot only include the data they have access to or will it still snapshot the entire model?

I accidentally deleted a snapshot, is there a way to restore it ?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!

I have a Calendar folder in [01] Data Hub app. As I create additional related apps should I create a new Calendar in each? I know I can open the Data Hub dimension to be shared  Can I dimension-chain my way back to the Data Hub time dimension’s properties? I use the Data hub Time period lists in the structure (dimension format) of Metrics in the related apps, can I reach data hub propts in formulas? 

I currently have a table with months and years in the columns and metrics in the rows. I want to have a YoY% appear as a column after each year for all metrics. i.e.    FY26 | YoY% | FY27 | YoY% |Is this possible and if so, how to I go about it?

Hello,I Have the below list of leads and I want to count 1 in the column Count only for the lastest lead of the company.The goal is to remove duplicate leads of my lead analysis.Thanks  

Hello,I have a question. Hope you guys can help me out. I have a metric dimensioned on week, business unit and version. This is calculated from a TL that is being continually and automatically updated from the source system. However, I would like to ‘freeze’ this data for specific versions. For instance, at this moment in time I would like to freeze the metric for the budget 2026. Later on (in a couple of months) I want to freeze the data for the first forecast of 2026 (but leaving the data for budget 2026 untouched of course). I was thinking along the lines of using a M2M import, but I can't seem to work out a scalable solution on how to import only item A and not item B of the same dimension. Maybe using data access rights? Thanks for your help.Best, Bas 

Hi Pigment - would you please share the difference between Previousbase and Previousof. They look the same from the documentation perspective. Thanks,Louie

 I am trying to recreate a table like this in Pigment where the scenario would be Actuals and Var $ and Var % are calculated items and $ per head is ‘Total $’ in ‘Show Values as % of’ format. In Pigment, the red cells end up calculating as a % of as well instead of a variance. Does anyone know of a work around for this? If I make an independent $ per head metric the total $ per head line will be inaccurate. Thank you! 

Hi!Could you please elaborate on what “preferred” means here? If dimensions are not in the preferred selection, will they be left out? Thanks,Louie  

Can we integrate Pigment with Python 

Hello,I have a transaction list per customer_id with information regarding sales_team. However some clients are not properly mapped and do not have any data inside the “sales_team” column.When i retrieve the data from this transaction list via [BY : sales_team] i lose all clients that are missing the info.How could i include in my formula a way to have all customers not mapped under “blank” sales team ? I could add a formula directly into my transaction list but as i do have 6M lines i’m afraid it’ll trigger performance issue. Thanks in advance

I am trying to export pigment data to PowerBI following the guided steps available on community, but I get an error “404 id not found”. Does anyone know what I could be missing in the setup? I used payload functionality to generate ID for metrics.