Skip to main content

Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

967 Topics
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

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

3711
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

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

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

1881
francois
Employee
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #52 (SEON, Foot Locker, MUFG...)

 For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every weekExecutive Positions  [STAFFING & RECRUITING] Head of FP&A 📍 San Francisco, US Addison Group offers a full suite of consulting, recruiting, and executive search capabilities across multiple sectors, including IT, finance and accounting, non-clinical healthcare, human resources, administrative, and digital marketing.  [MARKETING SERVICES] Head of Financial Controlling 📍 Paris, FR Biggie is a communications consulting group, born from the merger of the media agency Repeat, the trading desk Gamned, the video creation studio Kazam, and the influence strategy agency Beastly.  [SOFTWARE DEVELOPMENT] FP&A Director 📍 Remote, FR Cint is a software company that specializes in providing solutions for market research and data collection. The company offers a range of software products an

870
Benji
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!

3941
francois
Employee
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
# deals signed per month

Hello,I would like to create a metric that count the number of deals per month depending on the dimension below. In order to do so we should use “ ID prm client and “date of first contract signature” from the below dimension.How can i do that ?Thanks for your help.

3356
Benoit
Community Manager
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
The latest Month

Dear Community, I have a transaction List and have a Property which Type is Dimension (Month) Text.I’m looking to create a metric that tells me the latest month on that property. How can I achieve that? Thanks in advance :D

4063
Guillermo Puls
Budding Pigmenteer
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
Counting through a Boolean

Dear community, This is a quick one. I have a Boolean metric with one dimension (Employee). The metric shows a list of employees with the tick box marked.I am struggling to generate a KPI that show me the number of employees in the list. What’s the best way to approach this outcome?Many thanks in advance :D Metric: if(Transaction List. Bolean property'[by firstnonblank: Same Transaction List.Employee Name],true) I obtain a list like 

4181
Nathan
Employee
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #51 (Visa, Spotify, Grammarly...)

For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every weekExecutive Positions  FP&A Director [IT SERVICES & CONSULTING] 📍 San Francisco, US Visa is a world leader in digital payments, facilitating payment transactions between consumers, merchants, financial institutions, and government entities across more than 200 countries and territories each year.   Head of Strategic Finance [EDUCATION] 📍 Vienna, AT GoStudent is one of the world’s leading tutoring providers and, with a €3bn valuation, Europe’s highest-valued EdTech company.   Head of Corporate & Strategic FP&A  [ENERGY] 📍 The Hague, NL Yinson Holdings Berhad is a global energy infrastructure and technology company, listed on the Main Market of Bursa Malaysia Securities Berhad.   Hiring? Submit a job! Other Positions  Strategic Finance Analyst [SOFTWARE]  📍 London, U

800
Benji
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Average MRR invoiced per cohort

I tried to calculate the average MRR invoiced per cohort but it’s not working.i tried to drill down but dit not find the solution.For example: MRR by cohort for Cohort 14 in jan 23 is equal to 4315€ and '# MRR invoiced by client is equal to 6.The calculation should do 4315 divided 6, but it’s not.Can you help me ?Thanks  

2232
C
Seasoned Pigmenteer
K
Just Arrived
KLIUJust Arrived
asked in Questions & Conversations
Creating Customer Count metric

I want to create a Metric for Customer Count. We have ACV $ and Churn $s, do you know you and/or someone on the Support team can help / work together to make sure I am doing it right? Can we jump on a quick 30min call? TY

2171
Benoit
Community Manager
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Org Chart Hierarchy setup

Hello!I am trying to build an org chart for my company. Most part is good to go, but I noticed that the “Position <> Manager” metric for Reporting seems to confuse the overall structure at the end. When looking at below snapshot, I clicked the ‘Strategic Finance’ team and employee A” is our CFO. My goal is to show “B” and “C” employees underneath “A” employee only because this flow is for the “Strategic Finance” department, However, it’s showing +6 who are NOT part of “Strategic Finance” department. Is there any way to fix this? Thanks!!   

3594
Y
Newly Minted Pigmenteer
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Last quarter calculated item not displaying the right amount

Hello,I have used the LQ calculated item to create a table but the amount displayed in April 2023 LQ is the amount of jan 23 actual.  Can you help me ? Thanks  

1094
C
Seasoned Pigmenteer
KatieP
Just Arrived
KatiePJust Arrived
asked in Questions & Conversations
Google Sheets Connector & Data imported not matching format or filters set in saved view

When building & refreshing an existing connection to Pigment, the view I have saved does not pull through to google sheets in the format that I saved the view. It also does not pull through all the page filters that I have, specifically the years page filter.This causes the whole import to pull through for all existing years for all scenarios that I am pulling in. It also pulls through all data rows even if there is no underlying data. For example I am pulling a full P&L and instead of pulling through just the Revenue Accounts for Account L1 Net Revenue it also pulls through every Opex, CoR, etc. account L0. This causes a ton of extra useless empty rows in our google sheet. This is a lot to scroll past & causes noise in our workbooks. Is there a better workaround here? Right now I have one tab just for the Pigment connection & then have to manipulate the data on another tab to get the format cleaned up. 

1031
Benoit
Community Manager
Sofia Costa
Budding Pigmenteer
Sofia CostaBudding Pigmenteer
asked in Questions & Conversations
reducing values in a droplist | transaction lists

Hello community, I’m creating a transaction list to be inputted manually by an end user.How can I have a reduce list for a certain dimension?eg: in a country dimension with all countries, the list available needs to be only the European countries. As a workaround I’m creating extra lists to have these sub-lists. But it will not be a very clean strategy in the end. Does anyone have another way to overcome this?Thank youSofia

1925
Chris
K
Seasoned Pigmenteer
KevinSeasoned Pigmenteer
asked in Questions & Conversations
Creating an Identity Matrix

I have a dimension that is a number (30 Day Cohort).  I think I will need an identity matrix for some calculations later in my model.  Is it possible to create a metric that has the 30 Day Cohort x 30 Day Cohort?  Here is a simple example of what it would theoretically look like.I have tried playing around with the Value function to convert to numbers and do some sort of comparison to the dimension but it doesn’t return what I would like:IF(VALUE('30 Day Cohort'.Name)<VALUE('30 Day Cohort'.Name),0,1)[BY SUM: '30 Day Cohort']Any ideas or things to try would be much appreciated.  At the end of the day, the 1s in the matrix will eventually be values calculated from other metrics but I think I need this matrix to do those calculations.  But then again I may not given Pigment’s various functions and how it handles dimensions.  So any and all ideas are welcomed :)  Thank you in advance!

5514
K
Seasoned Pigmenteer
K
Seasoned Pigmenteer
KevinSeasoned Pigmenteer
asked in Questions & Conversations
How to replicate the MAXIF Excel function

I have a metric that has two dimensions that have pasted values from another source.  What I would like to do is return the last month that there is a value > 0 for a specific row in the metric.  In Excel terms, this would be done with a MAXIF function where I would return the max month with the condition that “Net Installs” is > 0.  From the screenshot below I want to return the month dimension value of Dec 24Can this be accomplished using just the BY modifier and the MAX aggregation method?  Any insights are very much appreciated.  Thank you in advance.   

3502
K
Seasoned Pigmenteer
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #50 (Criteo, Kraft Heinz, CoachHub...)

For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every weekExecutive Positions  [SOFTWARE] FP&A Director,📍Remote, FR Cint is a global software leader in digital insights gathering and has the world’s largest consumer network for digital market research, made up of over 155 million engaged respondents across more than 130 countries.  [MANUFACTURING] FP&A Director,📍Franklin, US Mars is a unified force of 140,000+ Associates and the world’s leading manufacturer of chocolate, chewing gum, mints, and fruity confections.   [MANUFACTURING] FP&A Director,📍Boston, US By delivering ultra-high performance and energy efficiency, Lightmatter’s compute engine will power rapid advancements in AI while lowering its environmental footprint.  Hiring? Submit a job!Other Positions  [FINANCIAL SERVICES] Strategic Finance Lead,📍London, UK

1620
Benji
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Sum of last 12 months before the switchover month

Hello, i would like to do the sum or the average of last 12 months before the switchover month. Thanks for your help

5383
Gawain
Community Manager
K
Budding Pigmenteer
Kamil SobczakBudding Pigmenteer
asked in Questions & Conversations
Aggregation from Month to Quarter > Seasonality in quarter assumption > Distribution back to Month

Hey team, I have an issue to chose the proper modifiers in one of the metric blocks. I have a quota values by month by sales rep and wanted to sum these values into the quarters as a first step. So I’m writing a formula= Metric block with quotas by month [by sum: Month.Quarter]Next step is to use in quarter seasonality which is by Month, see the screenshot below. Total for a quarter is 100%. What’s the syntax to spread quarterly quota value to months ( I was testing add constant but it didn’t work) and then use the in quarter seasonality?  

7654
Gawain
Community Manager
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
NETWORKDAYS formula

Hello,  Can you please help me creating a formula to show net working days for each month?The excel formula will be like this: So far, I created a dimension  I referenced the article here but could not really understand what I should do to get list of working days for each month.  Thank you!

10022
Y
Newly Minted Pigmenteer
K
Budding Pigmenteer
keerthanarameshBudding Pigmenteer
asked in Questions & Conversations
Multiple Break down levels

Hi,What’s the criteria to have a another level of breakdown?I was able to have two levels of break down for one of the metric but for the boxed one “R&D SAAS Total” another level of break down doesn’t show up even though the  dimensions are all different for each level that I wanted to select. Can anyone share what is the rule/condition to be followed for such multiple level of break down in a table?Thank you! 

7494
K
Budding Pigmenteer

Badge winners

  • Partner Solution Consultant Certified
    YounesZhas earned the badge Partner Solution Consultant Certified
  • Pigment Modeling Fundamentals Certified
    Alexxyuhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Alexxyuhas earned the badge Pigment Like a Pro
  • Read and Interpret Formulas Certified
    Ben Essalamahas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    Nancy S.has earned the badge Pigment Modeling Fundamentals Certified
Show all badges
Terms & ConditionsCookie settings