Skip to main content

Questions & Conversations

Got a question about your models? Want to start a discussion? It's here!

  • 759 Topics
  • 2,073 Replies
759 Topics
Trever Leavenworth
Seasoned Pigmenteer
Trever LeavenworthSeasoned Pigmenteer
asked in Questions & Conversations
Cohort framework & Previous question

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 2 Jan 23 Jan 23 Feb 23 Mar 23 Feb 23 Feb 23 Mar 23 Apr 23 Mar 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:

1685
Ben A
Employee
E
Seasoned Pigmenteer
ElodieSeasoned Pigmenteer
asked in Questions & Conversations
Delete items in a Dimension

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! 😊

3212
E
Seasoned Pigmenteer
Dominick Gonzalez
Dominick GonzalezOccasional Observer
asked in Questions & Conversations
Referencing objects

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.

4613
Dominick Gonzalez
P
Newly Minted Pigmenteer
PigmentaddictNewly Minted Pigmenteer
asked in Questions & Conversations
How to take the average division (and not a sum) in a metric when you change the pivot ?

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 ;))

7442
Nathan
Employee
Dominick Gonzalez
Dominick GonzalezOccasional Observer
asked in Questions & Conversations
Financial Functions

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 <> 0 THEN 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!

5131
francois
Employee
Bill Rausch
Budding Pigmenteer
Bill RauschBudding Pigmenteer
posted in Questions & Conversations
Repeating First or Last Value in Blank Periods / Use of Previous On

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 can someone share how the on parameter in the previous functio

4983
Ben A
Employee
D
Newly Minted Pigmenteer
Damián OrfanoNewly Minted Pigmenteer
asked in Questions & Conversations
Formula doesn't work (processing time without end)

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.

1343
francois
Employee
I
Newly Minted Pigmenteer
Ivan SenkinNewly Minted Pigmenteer
asked in Questions & Conversations
Size of Imported CSV file

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.

2452
I
Newly Minted Pigmenteer
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
Spell Check

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

1041
Benoit
Community Manager
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
How to align values or text

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

1122
P
Budding Pigmenteer
D
Seasoned Pigmenteer
DastanSeasoned Pigmenteer
asked in Questions & Conversations
How to automate the import of complex reports

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?

892
D
Seasoned Pigmenteer
S
Newly Minted Pigmenteer
Sergio B.Newly Minted Pigmenteer
asked in Questions & Conversations
Greenhouse Integration - How to Import Target Start Date

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?

1371
Syuen
Community Manager
Dmitrii
Seasoned Pigmenteer
DmitriiSeasoned Pigmenteer
asked in Questions & Conversations
Easier way to reorder dimensions? Drag and drop maybe?

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?

1143
Dmitrii
Seasoned Pigmenteer
A
Newly Minted Pigmenteer
AdelgoNewly Minted Pigmenteer
asked in Questions & Conversations
MoM KPI

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. Thanks Adèle

5281
Benoit
Community Manager
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
Unique field missing from data mapping for uploads

Should there be a “Unique” column in the below grid? If so, how do make sure that it appears at the mapping stage?:

944
P
Budding Pigmenteer
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
How to unhide an item

Say I have a dimension list (“Country” for example) included in a grid (within a board) - If I hide an item, how do I unhide it If I hide an item, is there an undo function to take me back to the unhidden view?

1634
P
Budding Pigmenteer
J
Seasoned Pigmenteer
Justin GrooverSeasoned Pigmenteer
asked in Questions & Conversations
Can I Apply Conditional Formatting to All Columns of a Calculated Item?

I have a budget & forecast vs actuals table as shown below. Actual, Current Budget, and Current Forecast are Version Type dimensions that are associated with the Version dimension as properties. The 5 columns within the red box are calculated items. I applied conditional formatting to the variance calculated items. However, when the month changes, the formatting goes away as shown below: The intent for the above views is to associate the month dimension with an application variable of “Last Closed Actuals Month” - dynamically updating to show stakeholders their monthly and YTD variances. Is there any way to apply the conditional formatting across the entire calculated item? Or a different approach to BvA views entirely? The approach shown above contains 6 conditional formatting rules (3 columns x2 rules each), so doing this for every month doesn’t seem viable. Thanks!

2052
J
Seasoned Pigmenteer
C
Budding Pigmenteer
CBGongBudding Pigmenteer
asked in Questions & Conversations
Dimension property help

I am trying to get a formula to work showing each persons quota by quota code based on tenure. I have created a Years dimensions that outlines year 1 = $1 year 2 = $2 ect ect with the quota value being a property in that dimension. I have then created a metric outlining each quota code by month and then plugged in the year dimension to help map how many months of what quota are needed. All I need is to to get the below to show the number value for that year dimension listed. What is the last piece I am missing to get this to work ? I keep getting errors. Thank you for your help!!

1472
C
Budding Pigmenteer
J
Seasoned Pigmenteer
Justin GrooverSeasoned Pigmenteer
asked in Questions & Conversations
How to Avoid Circular References in Rollforwards

I am trying to create something in Pigment similar to the simple excel model shown below. The key piece I cannot currently achieve is making the Churn amount be calculated as: Beginning ARR * a percentage driver. Same as above with formulas shown. Formula works as it is cell specific When trying to do the equivalent in Pigment, I get a circular error. Dec 21 Ending ARR is hardcoded here for the sake of the example For the sake of the example, I’m assuming Jan is actuals and Feb is forecast. For reference, my Pigment formulas are as follows: Beginning ARR: 'Ending ARR'[select: Month-1]. I have also gotten the same result with PREVIOUS(Month)+Bookings[select: Month-1]+Churn[select: Month-1] Bookings: no formulas - direct entry Churn: attempted formula was Beginning ARR * Churn_Percent, but resulted in circular error Ending ARR: previous(Month)+Bookings+Churn Churn_Percent: Churn/'Beginning ARR'. I allowed overrides on this metric to be used as a driver in forecast months Is there any wor

3085
francois
Employee
J
Newly Minted Pigmenteer
JuliaSpNewly Minted Pigmenteer
asked in Questions & Conversations
IF AND OR function together

Hi I need to create a formula that as multiple conditions like in the screenshot. My formule doesn’t work, can you help ? Thanks,

1832
J
Newly Minted Pigmenteer
S
Newly Minted Pigmenteer
SophieNewly Minted Pigmenteer
asked in Questions & Conversations
Can you copy formatting from one metric to another in a table?

Can you copy formatting from one metric to another in a table?

751
Elliot
Employee
M
Newly Minted Pigmenteer
Martin DecremeNewly Minted Pigmenteer
asked in Questions & Conversations
API output format

Hi 👋🏼I’m planning on using your API to ingest Pigment data in our datalake, DB Snowflake. I got a two folded question: What are your current API limit rates? (number of lines returned, number of calls, ...) Do you plan to offer Json or XML as an output format for their API? Right now, only CSV is returned. Thanks, Martin

1982
M
Newly Minted Pigmenteer
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Using Modifiers BY with MINOF

Dears, I am trying to get the first Month we have data of a customer to group it by cohort, and I want to add that date as a property of customer. I was able to get that data using the following formula: 'Requests MRR BE'.Date[BY FIRST: 'Requests MRR BE'.'Company or Partner Id' ] The problem is that it only works as long as I have sort the date ascending in the transaction list, and I would like to retrieve that data without having to sort my transaction list. Is there a way I can integrate MINOF in a modifier so that instead of the first value it finds it takes the smallest? Thank you very much in advance, Jose

1602
Ben
Community Manager
C
Seasoned Pigmenteer
Chelsea
posted in Questions & Conversations
What do you want to learn about Pigment?

Pigment Academy is just getting started, and we want to help you be as successful with Pigment as possible! Let us know what you want to learn next on your journey to becoming a Pigment pro.

462
A
L
Newly Minted Pigmenteer
LuigiNewly Minted Pigmenteer
asked in Questions & Conversations
Dimension to text

Hello! Is there a way to convert a Dimension property into Text? I’ve done several times this the other way around using the ITEM function, but can’t find a way to make Dimension → TextThanks!

8061
Ben A
Employee

Most helpful members this week

Badge winners

  • Pigment Modeling Fundamentals Certified
    EkaterinaShas earned the badge Pigment Modeling Fundamentals Certified
  • Read and Interpret Formulas Certified
    Preeti Parthasarathyhas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    Ankit_Kabrahas earned the badge Pigment Modeling Fundamentals Certified
  • Read and Interpret Formulas Certified
    MatthieuDhas earned the badge Read and Interpret Formulas Certified
  • Innovator
    Ken Y.has earned the badge Innovator
Show all badges

Popular tags

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings