Questions & Conversations

Hello,I need to make multiple different imports from Pigment to Google Sheets within a preset presentaion frame (namely, fixed row titles and fixed column titles). But instead of filling the existing available empty cells of the sheet under those row and colum titles, the import seems to be inserting new rows and new columns (as many as the total surface of the import) between existing rows and columns. Can you please help me solve this ?ThanksErwan 

Hi Pigment community, I have a Metric ‘FX rates’ that contains the Conversion rates cut by three dimensions: ‘Currency’, ‘FX Type’ and ‘Month’.Also I have a Transaction List that contain the above dimensions (as dimension property). I’m looking to populate a column in the Transaction List that delivers the ‘FX rates’ value correspondent to the row value combination for the three dimension. What would be the best formula structure to approach this task? Thanks in advance :D

Hello,I want to use a vlookup on a non-dimension column. Is it possible ?Exemple : Dimension A : I have those 2 columns : I want to retrieve the Manager via the e-mailDimension B : I have my e-mails and my managers. Question : How can I get my managers in Dimension A ?Thank you :)

 Is there a way to delete users instead of just deactivating? I don’t see an option as primary owner.  Related: I believe currently transfer application can only be done by current owner, can the workspace owner transfer application ownership?  

Hello community, I’m trying to populate the very last column of the below Transaction list, which is set as dimension, which is already defined. I could populate the column line by line by selecting the values from the dropdown but there are lots of lines.  That’s why I’m trying to use a formula to populate the dimension via formula.The formula should bring the text from the Entity column (set as a dimension) and concatenate with the result with an if statement aiming to provide “Account code” text column (circled) in case it’s’ populated, or in case “Account code” is blank provide the “Account name” text column (highlighted in blue)if (Transactionlist.AccountCode = “”,Transactionlist.AccountName,Transactionlist.Accountcode) The result should be: Entityname2202 or EntitynameBankThanks for your help.

Is there a way to create a metric that joins/appends values from two separate transaction lists? List 1 would for example be most popular colour by product and month in 2022 and List 2 would have most popular colour by product and month in 2023. In my metric I want to join the two into a single metric.The values are dimensions, i.e. not amounts. Using a + works when working with amountsList1.Quantity[by lastnonblank: List1.ProductID, List1.Month]+List2.Quantity[by lastnonblank: List2.ProductID, List2.Month]but doing this with dimensions gives me an error:Error: Arithmetic operators only accepts same type arithmetic inputs after implicit casting, received Dimension (Competence) operandsThe reason I’m not using the same list for everything is due to List 2 having additional data that wasn’t available when we built the original model, and it having an automated import. And I’m trying to find shortcuts to avoid having to rebuild everything :) 

Hello community!I want to create a simulation tab to test several employee cost before hiring someone. Concretely, I want to create this knowing that company is a dimension, fix and var are manual inputs, currency is a dimension and total gross will be a formula according to what have been entered in company, fix, variable and currency. Thanks a lot! 

Join me in congratulating @Keiran, @markdeprez, @Jake, @CamilleMomo, and @Tess.Hunt on becoming our newest additions to the Modeling Fundamentals Certified club! 🥳🥳🥳 Interested in earning that badge for yourself? Check out the certification quiz on Pigment Academy for all the details.

I’m wanting to add some list items I generate based on a formula into a dimension list automatically.The Item function allows us to search and return a dimension if it exist in a list but I’m wondering how instead of returning BLANK I would be able to automatically add a missing item into the dimension.Some context: Pulling data from multiple sources which may have the same Primary Key therefore in Pigment I would like to Concatenate the Data Source Name to the ID and add it into a Global dimension we maintain.Ex.Global Dimension is IDsData Source 1 IDs1 2 3 4Data Source 2 IDs2 4 Processing I would like to do in pigment is to add Data Source 1 and 2 IDs to the global dimension so the output would be:DS1-1 DS1-2 DS1-3 DS1-4 DS2-2 DS2-4

Hello,I would like to know if you have a best practice to share regarding the recruitment plan.At first we have a line for a recruitment to be done. Once the recruitment is completed, we have the name of a future employee. How do you keep track of that and follow this in the most automated way ? (to avoid duplicates on the actuals and forecast)Thank you :)

Quick question:Is there any option to add our Corporate Logo to the Boards?Thanks

Hey everyone! I’m trying to create a cohort framework in the backend of the model. To do this, I’m using my Datahub::Month dimension and my Revenue app::Cohort Months dimension. It should generate something like:                    0             1             2Jan 23    Jan 23     Feb 23    Mar 23Feb 23   Feb 23     Mar 23    Apr 23Mar 23   Mar 23     Apr 23    May 23 and so on. Is this the best practice to enable cohort logic for things like churn? To create my Cohort Months dimension, I can manually type integers 0 through 60 for example, but is there a way to use PREVIOUS() to just increment 1 each row to do this? Screenshot:  

Hello Pigment Community!I would like to delete an item in a Dimension (which has been created by an error in the settings when importing data), but because this Dimension is used by several blocks, I don’t want to delete data in these other blocks. Could you please help me to find a way to see if said item is used by other blocks and if I can simply delete the line containing the wrong item in the Dimension?Thank you! 😊

Hello Team,Is there a way to reference an object(from a transaction list) within a metric without having it auto aggregate? See screenshots for reference.  

 We are trying to make the average of all the elements of the country dimension (in rows). When we change the pivot country from rows to pages, it makes the sum of the lines and not the average. Thank you in advance for the help and the contribution to the pigment community ;)) 

Hey Team,I am working on an Existing Fixed Rate Loan walk-forward build. In the source system, the original fixed monthly payment is calculated by the following:  IF    Loan Term <> 0THEN    PMT(Interest Rate Origination Period / 12, ABS(Loan Term), ABS(LoanAcquisitionActualUPBAmt), 0, 0)ELSE    PMT(Interest Rate Origination Period / 12, Loan Term Final, ABS(LoanAcquisitionActualUPBAmt), 0, 0)Does Pigment have an equivalent function to calculate PMT? (Calculates the monthly amount required to pay back a loan given each payment is equal) Please advise - Thanks!

There have been a few instances where we need to take the fist value of a metric and have it populate earlier periods that are blank and take the last value and populate remaining blank periods.Lets assume we have a metric called Salary, with a set of values from a limited period (i.e., Mar - Jun):Jan Feb Mar Apr May Jun Jul Aug     5000 5000 5250 5250     Below is the final result we need :Jan Feb Mar Apr May Jun Jul Aug 5000 5000 5000 5000 5250 5250 5250 5250  I’ve seen the use of the previous function to populate the earlier periods:if(isnotblank(Salary), Salary, previous(Month on -rank(Month.’Start Date’))and a slightly adjusted formula to populate the later periods (i.e., take out the - in front of the rank function): if(isnotblank(Salary), Salary, previous(Month on rank(Month.’Start Date’))I’ve been unable to find documentation on how the previous function uses the on parameter.Is there another way to accomplish this or

I try a simple formula in a Transaction list of 91.000 items and it doesn’t get the result. It has been updating for 5 minutes, finished and the cells remained empty.  

Hi, community! I have an error “This CSV size is too big. Please reach the support for more information” I cant find information about the maximum size of csv. I think it will be interesting for another members.  

Is there a spell check function within Pigment? If so, how do I activate it and configure the settings ( UK English for example)

How do you align values or text in a column?See below example. How would I center the values listed in the AOV column?:  

Hi Pigment team,I am working on the report, which contains multiple columns with amounts (i.e. tax codes with its own amounts for each employee). Something like following:The issue is, when I want to import this into my Transaction List, I have to manually create 4 columns with different names (NYSD, MPEP, etc.) to capture amounts. And, this source file comes with additional columns (new Tax codes) every time, so I need to change the import settings every time to add new columns.Is there way to automatically add these column headers to, maybe dimension list, and make the system capture new amounts automatically?

We’ve connected Greenhouse to Pigment and aren’t sure how to import the “Target Start Date” field.We’re currently sourcing the Job data type → Open Recs, and most fields needed for workforce planning appear, but target start date is missing. Any suggestions here?

Hi everybody, It is very time-consuming to reorder dimensions with a hundreds of items. Drag-and-drop would be ideal, but it is not there or I couldn’t find it.I have a workaround of creating a `sort order` field for the dimension, but this look to hacky to me. Any tips on easier reordering?

Hello,I know it is possible to create a MoM KPI, but if I add it as a KPI in a board, each month I have to change the month concerned.Is it possible to calculate automaticaly the MoM based on the last month selected in the board ? Example (picture below): In my board I selected the first 9 months of the year. For my MoM KPI, I selected september to offset with the month before. So the result is September-August. But if I select the 10 first months of the year, the KPI does not change. I expect to see automatically October-September.ThanksAdèle