Questions & Conversations

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')] 

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.  

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.   

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?  

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?

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!

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

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?

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

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. 

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?

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

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. 

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

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.  

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.

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.

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

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

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?  

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

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"]  

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,

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

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.