Skip to main content

Questions & Conversations

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

  • 817 Topics
  • 2,202 Replies
817 Topics
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Dimension property value by version

Hello,I created the below metric but the result is not what i expect.I would like to have only the “new deals. TTR first date” for the “Budget 2024” version.Currently my metric is displaying the “new deals” dimension list of all my version (Reforecast july 2023 and Budget 2024). Version is a property of New deals.You will find below the new deals dimension list.thanks for your help 

1617
C
Seasoned Pigmenteer
L
Newly Minted Pigmenteer
Lester ChowNewly Minted Pigmenteer
asked in Questions & Conversations
Scenarios for Transaction Lists

How do you guys lock headcount for a 3+9 or a 6+6 for example? Our headcount comes as an import from our HRIS load. But since we can’t apply scenarios to transaction lists, our locked 3+9 contains items from the current day.

2124
L
Newly Minted Pigmenteer
V
VianneyOccasional Observer
asked in Questions & Conversations
function "Today" in Pigment

Hello Pigment community, I am having trouble creating a metrics to compute my ageing balance. The aim is to create a metric that would calculate the delay in days between the due date of each invoice and the current day (today). I tried to find workaround on this in the community but i can’t make them work in my case. I saw as well that a replica for Pigment of the excel function TODAY() was under development but i did not see if that was live or not. Can you help me ?  Thanks a lot 

4681
BrunoRodriguez
Employee
D
dariousKeen Learner
asked in Questions & Conversations
Error: Unknown List Property: Country mapping.'Country Group'

Hi, good morning everyone! I have an error and I can’t solve it, could you help me out with a solution please? I have the formula: 'All Deals'.'Deal ID'[BY COUNT: 'All Deals'.'Country/Region'.Country.'Group', 'All Deals'.Segment.'Segment Simplified', 'All Deals'.Pipeline.'Pipeline Simplified', 'All Deals'.'Create Month']Every time I try to run the formula I get the error: Error: Unknown List Property: Country mapping.Country For more context: All Deals is a transaction list that has various dimensions and lists within it. I am trying to build a formula that will have the country group on the y-axis and month on the y-axis. I have used the dimension “Country mapping” to convert all the different languages of countries to english. The dimension “Country mapping” has a dimension called “Countries english names” that comes from the “Country” Dimension, specifically the ‘english’ column. Using my formula I expect to call the “country mapping” dimension and then through its associated proper

1412
D
A
Budding Pigmenteer
AhmedBBudding Pigmenteer
asked in Questions & Conversations
Allocate values to the following months

Hello to all Pigment enthusiasts,To estimate my number of Headcounts over the coming months (Forecast), I'm taking the Headcounts on an HR board (here with Position ID with Contract) that you see on the lines in this metric.(Dimensions: Position ID, Month, Period Type) I'd like to be able to push the values over the following months. Concretely, even if the person (PO 312) is recruited in March 2024, he must be present in all the following months and therefore should have 1 in April 2024, May 2024…Many thanks for your help

2102
A
Budding Pigmenteer
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Sort by metric result highest number

Hello!Can someone please help how I can sort by highest number? I would like to sort the vendor name by 2023 Total amount. Thank you!  

1994
Y
Newly Minted Pigmenteer
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Formula retrieving not the full data

Hi, I have the below formula but my formula is only showing the clients for which the “Year of contract signature” is FY23 but is not displaying the contract signed in FY22,FY21… and cohort client type = “On Onboarding”)Thanks for your help,

884
C
Seasoned Pigmenteer
E
Seasoned Pigmenteer
ElodieSeasoned Pigmenteer
asked in Questions & Conversations
Tenure cohort calculation

Hello,I am trying to create a metric with the number of sales by seniority in month.I have a metric with the number of new hires and a tenure cohort dimension made up of 0, 1 and 2+ months. For example if I have 2 new hires in September 2023, I want to see 2 in the “0” line in Sept-23, then 2 in the “1” line in Oct-23 and 2 in the “2+” line in Nov-23.I hope this is clear enough! Thanks!Elodie

2602
E
Seasoned Pigmenteer
J
Budding Pigmenteer
JoshBudding Pigmenteer
asked in Questions & Conversations
As of Date for KPI

How do you create/show a date as a KPI. I want to show the last day of actuals for a data set and bring that into a board as a KPI. Is that possible?

6905
Chris
O
Newly Minted Pigmenteer
OyvindBNewly Minted Pigmenteer
asked in Questions & Conversations
How to use equivalent of PREVIOUS() on dimension

Hi!I want to add “Weeknumber” to my “Day” dimension.Since WEEKNUM() is not available, I want to use the equivalent of SHIFT/PREVIOUS to calculate the weeknumber.I have a dimension called Weeknumber (1-53), and would like to do something along the following line, in order map Days → Weeknumbers: //Check if first day of year, IF(LEFT(Day.'dd-MM-YYYY',5)="01-01" ,ITEM(1,Weeknumber.Week),// Else: check if workday = Monday then add 1 to week countIF(Day.'Day of Week' = 'Day of Week"."Monday",PREVIOUS(Day.Weeknumber)+1,//IF NOT Monday, then keep current weeknumPREVIOUS(Day.Weeknumber))However, both PREVIOUS and SHIFT does not seem to work. Is there a workaround?

2302
Issam Moalla
Employee
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
How to calculate the Variation % of two calculated items

Hello,In the table below i would like to to calculate the Variation % between YTD actual and YTD RF which are 2 calculated items ? Thanks for your help 

1251
Benoit
Community Manager
K
Newly Minted Pigmenteer
kristian.bartelNewly Minted Pigmenteer
asked in Questions & Conversations
Metric with Data Type Dimension (Month) to Boolean Metric

Hello,I have a metric where the data type is the month dimension and am struggling to figure out how to convert it to a Boolean metric with month as a dimension of that.The first metric is an assumed/forecasted launch date for each customer (ignoring that these are old customers and therefore in historical periods). With the second metric I am trying to convert that assumed launch date to a Boolean where any month is “TRUE” that is greater than the assumed launch date in the first metric. For example, the first line here would correspond with an assumed launch date of Aug-23, the second line with an assumed launch date of Jun-23 and so on (also ignoring that these are historical periods). I’ve been spinning my wheels on this for a bit and don’t see any articles on data transformation from metrics with a data type being the month dimension. But essentially I am trying to transform these into a Boolean metric with the month dimension (rather than it as a data type) so that the forecasted

3932
K
Newly Minted Pigmenteer
J
Seasoned Pigmenteer
Justin GrooverSeasoned Pigmenteer
asked in Questions & Conversations
Challenges with Calculated Items & Aggregators with YoY Calculations

I am trying to create multi year P&L views, with months in the columns.  After the last month of the year, I want to show the annual total, YoY $ value, and YoY % change. (Months->Annual Total->YoY $ change->YoY % change).  The challenges I’m encountering are as follows - example with numbered notes shown in snippet below:Inability to choose position of aggregators.  Pros of using aggregators vs calculated items are that gross margin % calcs roll up correctly, and the values are retained when I collapse the months and only want to show the annual total.    Gross margin % calculated items roll up incorrectly.  It displays the sum of the months’ percentages, rather than the annual gross profit value divided by the annual revenue value.  Pro of calculated item is ability to choose column positioning.  Is there any way to hide a value in a calculated item?  The YoY % calculation displays a nonsensical value when calculating against % margin values.  Only workaround I’ve curren

8359
S
Newly Minted Pigmenteer
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Org chart icon not displaying

Hello,I don’t see the format Org chart icon (see first screenshot)Maybe i am missing a metric or something else. Here the current structure of my table:Employee is on the left side.Thanks for your help,

2701
C
Seasoned Pigmenteer
B
Newly Minted Pigmenteer
Bill LustgartenNewly Minted Pigmenteer
asked in Questions & Conversations
Calculating directly in a table?

Hello. I have created a table with multiple metrics. The calculations work currently, except the percentages are aggregating or calcing oddly when I display the table. When we’re looking at data at NOT the lowest level, the % is incorrect.In the screenshot below, I basically want the Account Churn % to display Churned Accounts / Active Accounts BOP. So 1%, 4%, 5% etc. I looked into Calculated Items, but doesn’t seem like that would work in this case. Am not looking to alter the metric itself, but rather to add a row for display purposes only.Thanks. 

3783
Nathan
Employee
Vamsi Kaki
Just Arrived
Vamsi KakiJust Arrived
asked in Questions & Conversations
Inbuilt Pigment Application

Hello,Does Pigment Academy has pre-built applications which can be downloaded and use for practice purpose?Thanks,Vamsi

2481
Benoit
Community Manager
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
difference vs last 4 years ago

Hello,I am trying to get current month vs 4 years before same month variance. Can you please help?I tried using the offset calculation to offset by 48 months ago, but it is giving me 4 years ago value rather than the difference.  So, Aug 23 is 10.9 and Aug 19 is 9.5. So I need to get the result of 1.4 in a new column.  Thanks in advance!      

1471
Nathan
Employee
R
Newly Minted Pigmenteer
rykasaNewly Minted Pigmenteer
asked in Questions & Conversations
Load specific accounts from Quickbooks

Is it possible with the Quickbooks integration to only load specific accounts from the Income Statement? For instance, I only want to import revenue accounts into a block. Is that possible? 

1142
R
Newly Minted Pigmenteer
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Internal mobility between teams

Hello,I would like to correct the below formula so I can have the team of each employee by month based on his entry date and exit date with no time limitation.The way the formula is currently it does not take into account the  fact that I have 2 lines in my transaction list for an internal mobility. It only take into account the latest subteams.Here is an example:‘Dataload HR tool - Employee.’  is my transaction list with all the info by employee.Currently for this employee, i have the following result.But it should be “Finance & Planning” team until jan 24 and from Feb 24 until the end “Product data” The data will be updated each month on the latest version of the ‘Dataload HR tool- employee’. Thanks for your help

5002
francois
Employee
K
Just Arrived
Kamya NJust Arrived
asked in Questions & Conversations
Download Academy template apps

How can I download Academy template apps into my company's workspace?

3691
Benoit
Community Manager
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Count of FTE with internal mobility

Hello, I did the below formula in order to count the number of FTE. It’s works well except for the internal mobility where it counts 0. One of the employee concerned by this case is the below employee:  What do i need do to in the formula to take into account the internal mobility ?Thanks in advance

3573
C
Seasoned Pigmenteer
Vamsi Kaki
Just Arrived
Vamsi KakiJust Arrived
asked in Questions & Conversations
How to create Dimension list and Transaction List?

Hello, How to create a Dimension and Transaction list?and also How to create properties in the lists. Thanks,Vamsi

2111
Benoit
Community Manager
R
Newly Minted Pigmenteer
rykasaNewly Minted Pigmenteer
asked in Questions & Conversations
Employee images from BambooHR

We have employee images stored in BambooHR. Is there a process for downloading those images so that we can upload them into Pigment for the org chart feature? I’m not able to download it through the integration. If not directly through the integration, how can I do this?  

4501
Nathan
Employee
L
Newly Minted Pigmenteer
Lester ChowNewly Minted Pigmenteer
asked in Questions & Conversations
How do you count unique months in a metric?

How do I get a unique count of months in a metric in a view?For instance, I have Revenue (Dim: Month): Jan23 : 10Feb23 : 15Mar 23 : 20 I’m looking at this metric in a quarterly view, Month > Quarter and I want to annualize this number. So the math would be (10 + 15 + 20) * 12/(3) (3 months in this time frame). I want this to recalc when I view it from a yearly perspective so it would be 12 months. Any ideas on this?  I tried doing Revenue [REMOVE COUNTUNIQUE: Month] but that just found the number of uniques in my Month Dim List and multiplied by that.

1871
francois
Employee
E
Just Arrived
EmiliaJust Arrived
asked in Questions & Conversations
Formula timed out

Hi,Could you please tell me what Formula timed out does mean and how it can be sorted?Thank you!

3891
francois
Employee

Badge winners

Show all badges
Terms & ConditionsCookie settings