Skip to main content

Questions & Conversations

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

  • 841 Topics
  • 2,267 Replies
841 Topics
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
Joining 2 transaction lists into one

Hi Community: The problem: I have 2 transaction list with identical fields. I want to join them together in one single transaction list.How to do it?

2715
S
Newly Minted Pigmenteer
M
Newly Minted Pigmenteer
MattRobNewly Minted Pigmenteer
asked in Questions & Conversations
'Days in Month' Calendar

I’d like to create a metric dimensionalized by Month with a Number data format. I want each cell to contain (1) If actuals, the number of days in that month (2) if the current month, the number of days from the start of the month to the current day (3) if forecast, zero. Can anyone please advise on how to do this? I know that I will probably need an input cell with the current date since there is no equivalent of the excel TODAY function. I tried using the ‘DAYSINPERIOD’ formula but couldn't get Pigment to accept the formula / deliver a result.

3971
Fabien
Employee
K
Seasoned Pigmenteer
KevinSeasoned Pigmenteer
asked in Questions & Conversations
Limit on number of items in dimension?

I have a dimension that is over 100,000 items.  I am able to import all the items from a csv file.  However, once loaded, I can only view the first 100,000 items.  There is a menu at the bottom of the dimension list that makes it seem like I can view the next 100,000 items but it does not do anything, and I cannot view the next items past 100,000.  I want to delete the very last item, but I cannot access it.Not sure if it is related, but I have the same issue for transaction lists that are over 100,000.  I can only view the first 100,000 items.  This is problematic if I would like to edit the list or manually add an item.

2184
Nathan
Employee
M
Just Arrived
Myriem METTAJust Arrived
asked in Questions & Conversations
filtre semaine

Bonjour,Nouvelle application et nouvelle métric à créer. Je suis bloquée pour faire un filtre sur une semaine. J’ai une base de donnée où j’ai les commandes avec la semaine de passation de la commande. J’aimerai donc faire un filtre pour n’avoir que les commandes qui ont été passées avant la semaine 35 par exemple.  Comment puis-je faire ?  Merci par avance pour vos astuces ^^ 

1391
Nathan
Employee
Katrina
Employee
KatrinaEmployee
posted in Questions & Conversations
Income model in Pigment

Hello dear Pigment Community! 🖐Is there a Pigmenteer who’d be available to connect with another Pigmenteer to chat about the experience of doing their revops model in Pigment? 👀👂🤝An informal chat to connect with another fellow peer and share your expertise!💡Don’t hesitate to tag people you think could be up for this ! 🙌

1231
KarlW
Community Manager
Dmitrii
Seasoned Pigmenteer
DmitriiSeasoned Pigmenteer
asked in Questions & Conversations
How to create a report on trailing 12 months?

Here’s our table for quarterly metrics. Once we close another quarter, we need to change the pages and adjust QoQ calculated items (even though they may be based on variables). What is the best way to select pages dynamically? For example, trailing 5 quarters?

7662
Dmitrii
Seasoned Pigmenteer
M
Newly Minted Pigmenteer
M_OlivierNewly Minted Pigmenteer
asked in Questions & Conversations
Unique Property

Hello guys, I’m having a problem when trying to import this CSV file and getting this message, yet I have not used “Buyer TIN” dimension as the unique property, I used another different item as the unique property. What can I do..?

3823
Julie Guérin
Employee
A
AdamOccasional Observer
asked in Questions & Conversations
Asset Amortisation Schedule

Hi All, I need a simple amortization schedule by month where:Opening Balance = Closing Balance of Month -1Amortisation = e.g. 30% of Opening Balance *-1Closing Balance = Opening Balance + AmortizationI created three separate metrics but I am struggling - I am getting a circular reference when calculating Amortisation. Can you help?Regards, Adam

5653
A
T
Just Arrived
tructranJust Arrived
asked in Questions & Conversations
At what stage do we specify the Workday report specifications to be loaded into Pigment?

At what stage do we specify the report specifications?   

1681
Benoit
Community Manager
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
How to solve Circular dependency

Hi AllI need to calculate Level & Trend column from actual and formula is to calculate is:Level  Lt = α yt  +  (1 - α) (Lt-1 + Tt-1) Trend Tt = β (Lt - Lt-1) + (1 - β) (Tt-1) Here y= Actual,  α & β=0.5 , L1=(y1+y2+y3)/3 andT1 = ( (y2 - y1) + (y4 - y3) ) ÷ 2 I tried to solve it by previous function & select modifier but facing circular dependency during calculation. Please help me to solve it.Sales (Actual Dt) Level (Lt) Trend(Tt) 587 605 -145 423 442 -154 805 547 -25 680 601 15 813 715 65 766 773 62

3791
Benoit
Community Manager
J
Newly Minted Pigmenteer
JAdrianNewly Minted Pigmenteer
asked in Questions & Conversations
Importing a dimension from one dimension list to another

Hey,I have a dimension list with “Actual Vendors”, that are created from our actuals transaction list. I’ve created a “budget category” dimension in the “actual vendor” dimension list, where I will tag and create new budget categories for each “actual vendor”, also created a boolean column, which checks wether I tagged the “Actual Vendor” or not. I’ve also imported our Vendor Budget list, where I’ve tagged an “Actual Vendor” to each “Budget Vendor”. I know want to add/import the “Budget Category” to the Vendor Budget list, mapping it from the Actual Vendor dimension list on the aligned “Actual Vendor” dimension. I’ve tried this formula but get the error message: Error: Dimension error: the Dimensions of the formula and the current Metric structure are not compatible. Can't implicitly remove Vendor Dimension(s) on non numerical Metric.if(vendor.'Is Budget Category?',vendor.'Budget Category','FY24 Budget Dimension Vendor List - Development'.'Budget Only Vendor')] 

2462
J
Newly Minted Pigmenteer
A
Newly Minted Pigmenteer
Angus RobertsonNewly Minted Pigmenteer
asked in Questions & Conversations
Inventory of Animals.

I am trying to model the age of sheep over years. The closing balance of a 1 year old sheep becomes the opening balance of 2 year old sheep the following year. The closing balance of 2 year old sheep becomes the opening balance of 3 year old sheep the following year. And so on.  

2956
Benoit
Community Manager
A
Newly Minted Pigmenteer
Angus RobertsonNewly Minted Pigmenteer
asked in Questions & Conversations
Inventory of animals - possible circular reference.

I am modelling the flock of sheep over a period of time.The logic: 2023 sheep * lambing percentage = 2023 Lambs bornAfter one year the lambs born are added to flock of sheep. 2023 sheep + 2023 lambsThis is then multiplied by you lambing percentage to get you current year lambs births. (2023 sheep + 2023 lambs)*lambing percentage = 2024 LambsAnd this repeats for the following years.   

1271
Benoit
Community Manager
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
Emojis in dimension to define status

Hi community, I have a numerical metric delivering a variance between Actual and Budget.I’m trying to create a metric (text), that transform a negative variance into a text (enabling me to add emojis there)My problem is that when I try the formula times out. What could lead to a formula time out?  

1421
Benoit
Community Manager
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
Sheet View Questions

How can i add sheet view as a default on board ?And secondly if we make manual calculations on sheet view , how will they flow through?

1871
Gabriel Amaro da Luz
Employee
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Add prior month result

Hi Pigment team! Can you please help modifying this formula to be as following explanation? Current formula:IF(S03_IsActuals, 'DH_Data_PL EBITDA Actuals'[FILTER: 'PL GLs'."60001"], 'TT_Base Salary USD'[REMOVE SUM: Country][BY: 'PL GLs'."60001"])I would like to add “EE_Salary_USD (Actual - Forecast)” metric in the “false” section, but with prior month result. I started like below, but I am not sure what to put in the highlighted section below: Example: Thanks in advance!

3551
Issam Moalla
Employee
I
Newly Minted Pigmenteer
IsabelNewly Minted Pigmenteer
asked in Questions & Conversations
IF function in transaction list

Hi!I am trying to populate a column in a transaction list by using a IF-formula. I want it to say that IF the Fulfillment center name = Start Depot name, then it should be classified as a Fulfillment Center (FC), and if it is not true, it should be classified as a Dip, but I get an error saying “Expressions are incompatible and cannot all be converted to Dimension ('[00] Hub'::'Fulfillment center')”Please see below the formula I am trying and screenshot of my expected result:IF('Act last Mile'.FULFILLMENT_CENTER='Act last Mile'.START_DEPOT_NAME,"Fulfillment Center","DIP")  

5972
I
Newly Minted Pigmenteer
Jeremy Stern
Newly Minted Pigmenteer
Jeremy SternNewly Minted Pigmenteer
asked in Questions & Conversations
Filter Excluding Blank Booleans

Is there a way to filter both “blank” and “non-blank” FALSE boolean cells in one filter?I am trying to filter on check boxes that have not been checked, but however I filter (= FALSE, <> TRUE, etc), it still excludes “blank” boolean boxes, aka boolean boxes that have not been checked yet. Is there a way for a single filter to include both “blank” and “non-blank” FALSE check boxes?

7333
Benji
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Can we use FORECAST_ETS function for holt & holtwinter forcasting?

hi allCan we use FORECAST_ETS function for holt and holtwinter forcasting calculation?if yes than How?

4541
Keiran
Community Manager
Kyla
Budding Pigmenteer
KylaBudding Pigmenteer
asked in Questions & Conversations
Aligning dimensionality across metrics

Hi Community,I’ve created a Commissions Forecast metric to calculate the difference between YTD Commissions and Total Target Commissions. The value is then spread over the remaining months left in the current year. I’d like to maintain the values from this metric and have it to flow through to my Total Compensation metric which has more dimensions defined in the metric structure. Any tips on how to accomplish this? Commissions Forecast Metric Dimensions: Department, MonthTotal Compensation Metric Dimensions: Department, Month, ID, Employment Type, Employment Status, Location, State. 

4192
Kyla
Budding Pigmenteer
L
Newly Minted Pigmenteer
Lester ChowNewly Minted Pigmenteer
asked in Questions & Conversations
Select specific months

How do I select the first 3 months of each FY?For ex: Revenue [SELECT: Month.Quarter] gets me the revenue for each quarter. but now I want just Q1 in each FY. How do I do that?

5961
abhilashsawla
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
Rolling Average

Hi I have a CPI metric which starts from FY2022-23 and goes on till FY 2121-22. I want to create a rolling average of first 25 values starting from FY2022-23 including FY2022-23 plus next 24 years.Then when it comes to FY2023-24, it does the same thing and include FY2023-24 and the next 24 years. and goes on and on. ThanksMusab

7344
M
Seasoned Pigmenteer
T
Newly Minted Pigmenteer
TWestNewly Minted Pigmenteer
asked in Questions & Conversations
Dimension Property

I’m trying to map one dimension in my transaction list to another using the lastnotblank function: ‘Pigment Dealer Model’ is the transaction list and ‘Dealer Type’ and ‘Dealership Id’ are both list properties; sometimes when I use the lastnonblank function it will work and other times, I get the error below: Is there a reason this function would be working sometimes, and not other times? When it works it produces this:  Any help would be much appreciated and please feel free to ask for more detail if needed. 

5602
T
Newly Minted Pigmenteer
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
Modifying Month dimension in Calendar

Hello Pigment community, Quick one here. I want to modify the Month Dimension in my calendar but “Cannot update a protected property (eg. built-in properties of calendar dimensions)”I’m currently showing Jun 23 (MMM YY) and would like to switch to Jun-23 (MMM-YY).How can I tune my own Calendar?Thanks in advance !!Guillermo

4443
abhilashsawla
M
Just Arrived
Myriem METTAJust Arrived
asked in Questions & Conversations
Fonction pour avoir la valeur des mois suivants

Bonjour,J’aimerai avoir la donnée des mois suivants. J’ai une donnée par mois et j’aimerais calculer une donnée dépendante des 3 mois suivants.  Merci par avance.  Par exemple : 1 257 k€ est la somme des mois de décembre à Février.  

5471
Issam Moalla
Employee

Badge winners

  • Rare Author
    caoimhe.gaskinhas earned the badge Rare Author
  • Read and Interpret Formulas Certified
    Diego Herrerahas earned the badge Read and Interpret Formulas Certified
  • Read and Interpret Formulas Certified
    AndrewAhas earned the badge Read and Interpret Formulas Certified
  • Read and Interpret Formulas Certified
    OAbozkhas earned the badge Read and Interpret Formulas Certified
  • Innovator
    Lauri Sulonenhas earned the badge Innovator
Show all badges
Terms & ConditionsCookie settings