Skip to main content

Questions & Conversations

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

  • 823 Topics
  • 2,214 Replies
823 Topics
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?

4441
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. 

4182
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?

5951
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

7304
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. 

5582
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

4433
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
N
Budding Pigmenteer
NachoBudding Pigmenteer
asked in Questions & Conversations
YTD column

Hi!I’m trying to create a new column with YTD figures in a table where we see EBITDA by market.The logic we’re trying to find is to be able to tell Pigment that this column has to be the sum of the actual months and to group it all in a single column.  That is to say, it would be something similar to a filtering option, just as we can filter by month to see the info for a specific month, so that we can choose to see only the YTD figures.The idea is that it would be something dynamic and as we close new months that become current months Pigment would understand that the YTD info has to be updated.

6183
Benoit
Community Manager
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
how we can limit the user for input value?

Hi Community Members,Please let me know how we can limit the user for input value.Means, There is an input metric where user can provide input between 0.01 to 0.99 only.

6709
abhilashsawla
M
Newly Minted Pigmenteer
M_OlivierNewly Minted Pigmenteer
asked in Questions & Conversations
Creating a week dimension.

Guys, I have a business use case that happened to have a data in weeks, and I would like you to help on how to solve this problem. What are your suggestions..?

5651
Benoit
Community Manager
A
Budding Pigmenteer
AhmedBBudding Pigmenteer
asked in Questions & Conversations
Creating an Access Rights Board

Hi there, More and more people in my company are using Pigment. We have different access rights settings (By Cost Center/ By Business Model/ By Country etc...).Today, I'd like to create a board that allows each Pigment user to see which dimensions they have access to and which they don't.I can of course create a new application by making all accesses available to all users , but I want the user in question to be able to see only his or her accesses.I thought of creating Rights accesses by user ("User A" will have an access Read/No Write only to "User A") but you can not, as far as I know, have 2 similar dimensions in a Metric.Any suggestion?Many thanks

5232
A
Budding Pigmenteer
Rocco
Budding Pigmenteer
RoccoBudding Pigmenteer
asked in Questions & Conversations
Hard Selection on the target metric

Hello Everyone,I have in the following 2 dimension: Year & “Year1”from the FTI formula I hard selected the 200 from the Year.”FY 23”. Year is the only dimensionHow do I hard select on the target metric just one random cell, like the one highlighted below?  

3343
Mat
A
Seasoned Pigmenteer
AlexandreSeasoned Pigmenteer
asked in Questions & Conversations
Average counting blank value as 0

Hello,I would like to do the average by counting blank value as 0. How can I do that ?Thanks,Alexandre

5874
N
Budding Pigmenteer
Rocco
Budding Pigmenteer
RoccoBudding Pigmenteer
asked in Questions & Conversations
Mapping Values in different items

Any suggestion regarding oh how to complete the following:I would like to allocate top value in the cells below. In the Loss Utilisation Dash there is 1 metric more (Year Incurred) The formula I used so far is:'03. Future Taxable Income for utilization against available loss' [select: Year."FY 23"][by: -> '01.2 Year Incurred'. "FY 05"]  

2412
Mat
M
Just Arrived
Manon SJust Arrived
asked in Questions & Conversations
Price / Volume effect

Dear community,We would like to create a Price/Volume effect bridge from Budget to Actuals. We were thinking to create a metric for each KPI (Origin Price, Destination price etc.) but that means we create many metrics as the formula use many different KPI for few bridges. Is there a faster way to do it ?Thanks a lot,

1681
Nathan
Employee
G
Budding Pigmenteer
gabmactavishBudding Pigmenteer
asked in Questions & Conversations
Board customization qustions

Hi Community,I’m trying to create some nice boards and have a few questions on presentation elements that I’d like to incorporate, but don’t seem to be possible in Pigment. If possible, please let me know how, or if not possible, if there are any workarounds. Are you able to change background colours on the board, or the font? (for example - we do a lot of our reporting on a black background, so it would be nice to change from the default white. Or be able to align other formatting to our internal reporting themes) Screenshot 1 Can you remove gridlines on a Grid? (again, a lot of our reports are against a black background, so it’s a bit of an eye sore to have the white gridlines there) Screenshot 2 Is there a way to apply cell formatting to a wide range of cells, or a whole table at a time? Currently what’s happening is if I format “Revenue” for example with $ and M for millions, only that one line will change, and not everything that is grouped (Screenshot 3). Updating this has become

2281
Benoit
Community Manager
Rocco
Budding Pigmenteer
RoccoBudding Pigmenteer
asked in Questions & Conversations
Year + 'Metric'

Dear Community,I need to set an expiration year.I am using the formula “Year + 10” on a Metric with only Year Dimension.I would like this to be more friendly to the end user.I would like to set a metric that i can add to year (ex= Year + “metric”) . I tried with a metric with no Dimensions with a value 5. It did not work.The end is for  the user just by changing the metric at the “metric” would change the Expiration Year. 

2024
Benji
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Using LASTNONBLANK with a FILTER OR REMOVE

Dears,I want  to creat a metric or a property dimension where I get the last non blank dimension from a transaction list that also has some constraints like certain dimensions from that transaction list be equal to something. I have the following formula:'01_MRR-T Requests MRR BE'.'Billing Unit'[BY LASTNONBLANK: '01_MRR-T Requests MRR BE'.'Company or Partner Id'][REMOVE:'01_MRR-T Requests MRR BE'.'Product Final'='MRR-D Product final'."Licences"]Is says that I need to add as a dimension  MRR-D Product final, so even if I just want to use it as a constraint do I need to add to the dimensions in the metric structure?  Thank you very much in advance,Jose 

6292
Benji
Rocco
Budding Pigmenteer
RoccoBudding Pigmenteer
asked in Questions & Conversations
if the result is >0 allocate it to Next Year

Hello everyone, What I would like from the formula:if the result i bigger than 0 allocate it (aggeregate it) to next FY year The only dimension used is month,Any Idea is welcome 

1113
Nathan
Employee
G
Just Arrived
GuillermoJust Arrived
asked in Questions & Conversations
Waterfall chart comparing two scenarios

Hi!I’m trying to compare two scenarios in a waterfall chart so I can see which was the total revenue expected in Scenario 1 vs which is the new expectation in Scenario 2 while seeing the main drivers of this change. I’m trying to compare scenarios in a table and then convert it into a graph but it is not working. How can I do it?Thanks! 

3661
Andrea
Community Manager
Rocco
Budding Pigmenteer
RoccoBudding Pigmenteer
asked in Questions & Conversations
Mapping Dimension items in another Dimension

I have not been able to map items in another dimension.My current situation is this one:however when I look at metrics I cannot seem to find them mapped!Could you please give me some suggestions? Where do i need to click? 

1602
Benoit
Community Manager
K
Budding Pigmenteer
keerthanarameshBudding Pigmenteer
asked in Questions & Conversations
Vendor Mapping

Hi!Can someone please help me to find the vendor names from the description of a transaction from a list of vendor list that I already have?Right now, with the help of ITEM function its able to only recognize if the description has only the full vendor name from the list. But I want to populate vendor names by finding the vendor names in the description among other extra texts as well.For example,if my Description is “Amazon.com” ITEM function is able to recognize the vendor name and populate Amazon.com from the list that I have as a dimension. if the description is “Orders from Amazon.com”, its not able to find “Amazon.com” among the other texts in the description.So I’m looking for a way to find these vendor names from the description which has other text apart from the vendor name and populate it.Thank you!

4774
Benji
J
Newly Minted Pigmenteer
Jessica TNewly Minted Pigmenteer
asked in Questions & Conversations
IF formula modelling

Hello,Can you please help me with this question?I want to do a formula using IF or many IF condition.I am working with a block having months in columns and currencies in rows.Explanation: My formula is suppose to say if at the level of dimension month we select let’s say February month, I am suppose to obtain in January and february each actual rate and for the rest of the months, having february rates. And I am suppose to have the same logic if I select any month.Waiting for your response.Thanks.

6693
MKohli
Seasoned Pigmenteer
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Reallocation Logic

Hi Pigment team! I am trying to setup a reallocation logic. Can you please help with creating the formula? Right now, the total cost $1,517,587 is booked all in US (screenshot 1), but I want the cost to be re-allocated to international countries (screenshot 2). You will see the total still matches with screenshot 1. For my another metric for reallocation, what is best way to create a metric to show a table as screenshot 3?  ​​​​​​ Thanks in advance for reviewing!

492
Y
Newly Minted Pigmenteer
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Board Permission

HiWe have Two Applications.Hub BudgetingIn Hub Application, we have defined all roles and its permission & Access Write.Following Roles, we created in Hub Calculation.Requirement:CEO Role only can open and comment Cost Summary and Final Reporting  P&L Board in Budgeting Application.To Fulfil that requirement, we have created a Metric in Budgeting Application for Board Permission. In Board Access Configuration, This Board Permission: CEO Metric is defined for following boards. On Board also, we defined that Board Permission: CEO Metric for that Board. After defining that Board Permission, we are not able to achieve my requirement and all roles are able to access that board.Please let us know, if we are doing anything wrong and any best practice and Solution for the same.

2357
Benoit
Community Manager

Badge winners

Show all badges
Terms & ConditionsCookie settings