Skip to main content

Explore the Community

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

881 Topics
D
dariousKeen Learner
asked in Questions & Conversations
Count Blank over Count All with Dimensions

Hi Pigment Community, I am trying to create a KPI that tracks the ratio of blank cells to filled cells for a column in a transaction list. In addition I want this KPI to be dimensioned so that it can be affected by the page filters, however I can’t seem to figure out a solution and was wondering if any of you had a solution for me. So far I have attempted 4 different solutions, however none of them have given me exactly what I am looking for. Below I have provided screenshots of the different parts that contribute to my problem. As I have tried different solutions and none of them have worked I have provided information for each formula, as I don’t understand why each one gives me a different output. My end goal is to have the proper ratio of (all blanks) / (all blank + nonblank) which can be filtered by dimensions using the page option. Specifically: year, deal status, and HB - Deal Owner. Extra info:All deals - total row count = 5,504All deals.segment = blank = 292Ratio = 292 / 5504

2951
Issam Moalla
Employee
D
dariousKeen Learner
asked in Questions & Conversations
Year-Over-Year Moving Average Calculation

Hi Pigment Community!I am trying to create a year over year moving average but can’t seem to figure it out. I was wondering if any of you had some suggestions for me. The issue I am trying to solve is that I have a conversion rate calculated in a metric. Using that metric I would like to calculate the difference in moving average between the current year and previous year. Formulaically it would be: (Moving Average Current Year) - (Moving Average Previous Year) * 100. In addition I want to incorporate my switchover date so that my metric will continuously update itself as new information comes in.  Currently I have this formula in mind, but it doesn’t work. Perhaps there’s a better way, or my formula could be tweaked. MOVINGAVERAGE('[ % ] Opportunity to Customer', 3) - MOVINGAVERAGE('[ % ] Opportunity to Customer', 3, 0, '[ % ] Opportunity to Customer'.DATE(YEAR(EDATE('Switchover date', -12)), MONTH(EDATE('Switchover date', -12)), 1)Opportunity to Customer - MetricWhat I envision is: (

6792
D
P
Newly Minted Pigmenteer
ParaNewly Minted Pigmenteer
asked in Questions & Conversations
Newbie question

Hi, I am very new in Pigment and try to get used to the multidimensional thinking.I have a transaction list containing employee and department and a calculated salary metric with monthly salary per employee. I want to group the salaries per department. Please assist

4995
Benoit
Community Manager
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #58 (Siemens, TikTok, YouGov...)

 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, US EagleView is a leading provider of aerial imagery, property insights and software.   [MANUFACTURING] FP&A Director 📍Paris, FR Sodiaal is a dairy cooperative specialising in the production and marketing of a diverse range of dairy products.  [MANUFACTURING] Head of Finance 📍Cologne, DE Siemens is a technology company focused on industry, infrastructure, transport, and healthcare.   Hiring? Submit a job! Other Positions [MARKET RESEARCH] FP&A Manager 📍London, UK YouGov is an international online research data and analytics technology group.   [SOFTWARE] Senior FP&A Specialist 📍Remote, Canada Clio is the leader in cloud-based legal technology offering practice management, payments,

760
Benji
D
Newly Minted Pigmenteer
Daniel CicakNewly Minted Pigmenteer
asked in Questions & Conversations
Customer Rank globally & regional in one Board Widget?

Hi Community,is it possible to have a monthly ARR ranking metric which combines globally & regional rankings? e.g.Page Filter “None/All”, globally,Page Filter “EMEA”, ranking within “EMEA”,Page Filter “AMERICAS”, ranking within “AMERICAS”,etc.I was able to create a global & a regional view but it would be great to have this combined for our Dashboard, so that we can toggle through the regions. Thanks & BR,Daniel

4403
D
Newly Minted Pigmenteer
E
Just Arrived
EmiliaJust Arrived
asked in Questions & Conversations
Access to a Metric

Hello,I granted everyone admin rights to see and write in the application, however there is one specific metric, which no one else besides me can see. Did you maybe have a similar case or know what the issue might be?Thanks!

2891
Benoit
Community Manager
CamilleMomo
Seasoned Pigmenteer
CamilleMomoSeasoned Pigmenteer
asked in Questions & Conversations
Impossible to change color on open text ?

It seems that it is not possible to change the color of an “open” text widget. When changing color it goes back to “filled”.Is it a bug or should I create an Idea ?Thanks!

861
Benoit
Community Manager
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #57 (Qonto, Figma, Contentsquare, Personio...)

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  [HOSPITALS & HEALTH CARE] Head of FP&A,📍Sevenoaks, UK The Active Care Group is the UK’s leading national provider of complex care, harnessing innovation to raise standards and deliver better outcomes.  [TELECOMMUNICATIONS] FP&A Controller,📍Rotterdam, NL KPN is a telecommunications company that provides a variety of services, including fixed and mobile telephony, internet, and television.  [SOFTWARE] FP&A Director,📍Boulogne-Billancourt, FR Odigo provides Contact Center as a Service (CCaaS) solutions that facilitate communication between large organizations and individuals thanks to a global omnichannel management solution.  [FINANCIAL SERVICES] FP&A Director,📍Paris, FR Qonto is the leading European business finance solution. It sim

850
Benji
Chris
ChrisKeen Learner
published in Company News
New changes to block's header!

We’ve recently updated our block headers for a more simplified look. This article is designed to outline all the new behaviors.  Introducing the Formula icon for hiding the formula bar!  There is now an formula icon that can be used to hide and show the formula bar. Members can click the new formula icon to expand and collapse the formula bar. Also when using the drilldown options, Members can click on “Show/Hide formula breakdown” to expand and collapse the formula bar.We optimised the experience for each type of user. If the Member is considered a “modeller” (either have the ‘Can Configure Block’ or the ‘Can Open Block Explorer’) then the formula and the formula breakdown will be displayed by default. All remaining Members will be considered as “contributors” and the formula and formula breakdown won’t be displayed by default. All users have the ability to show/hide formulas. Block Header Changes: New options in block menu: A new option menu now appears in the top right. This menu in

3380
Chris
D
Seasoned Pigmenteer
DastanSeasoned Pigmenteer
asked in Questions & Conversations
Selecting the 2nd Most Recent value for the Transaction list

When I want to get the most recent date of the sale of a particular product, I can use BY FIRSTNONBLANK aggregator to get the value from the Transaction list of product sales data into the metric.But, how do I select the 2nd most recent date?For instance, I have the following sales table:Product         Qty.        DateProduct A.      30.        5/12/2023Product A.      40         3/26/2023Product A.      15.        1/11/2023I would like the metric, which I’m creating, select the 2nd row’s date, i.e.:Product A.   3/26/2023

2667
BrunoRodriguez
Employee
A
Just Arrived
azianiJust Arrived
asked in Questions & Conversations
XIRR function does not return value

Hello, I am using this formula to calculate the IRR amount, but it does not return anything. Could anyone help please ? Thanks in advance.IF(CoC<1,XIRR(Amount[ADD: Company][filter: LEFT('Transaction ID'.Name,8) = Company.Company][BY SUM:'Transaction ID'],-0.2,FALSE,Day),XIRR(Amount[ADD: Company][filter: LEFT('Transaction ID'.Name,8) = Company.Company][BY SUM:'Transaction ID'],0.1,FALSE,Day))  

3972
Benoit
Community Manager
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
Count if on Text metrics

Hi folks,The following query is about generating a Metric with data type dimension “Employee”The metric is counting how many items of a Text metric 1 are in another Text Metric 2.I use the following formula:If ( Text Metric 1 = Text Metric 2, “Employee”) [REMOVE Lastnonblank: Month, 'Employee']My problem is that I have no results when I should have. Thanks in advance!! New Metric - Type Dimension (Employee) Text Metric 1 Text Metric 2 Cost Center Cost Center   Entity Entity   TBH Request TBH Request   Version Version Version     Month     Employee

4952
Benoit
Community Manager
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
Access Rights Without User Dimension

Hi Team I have a use case where i have certain questions as a dimension and there are in total 160 of them. We ask each property manager these question but for lets say Property A , we ask 50 questions and for property B we ask all 160 of them.  How do i apply access right so only relevant questions get assigned to each of the properties? It doesnt need user access , just need to define it by property itself and questions. Secondly, then i need to create a metric to track progress rate as to how many of these questions are still blank and for that as well, i need to divide it by only the applicable questions. So for example property A have 50 questions to answer and he have only done 5 so far, then my progress rate should be 5/50 i.e 10% not 5/160 which is taking the whole 160 questions in the original list of questions. ThanksMusab

1631
Nathan
Employee
C
Budding Pigmenteer
connorsmithBudding Pigmenteer
asked in Questions & Conversations
Linear Forecast: Selecting Ranking Dimensions

Hi there! On the topic of the FORECAST_LINEAR formula: Is there a way to select certain values for the ranking dimension? For example, if:Forecasted Sales =FORECAST_LINEAR('Sales','Month’) Is there way to choose certain months you want to use for the regression? In my case I am trying to using TTM (which I currently have as a Boolean property of Month)

1904
C
Budding Pigmenteer
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #56 (Ubisoft, Wolt, Wefox...)

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  [MANUFACTURING] Head of FP&A,📍Munich, DE Lilium GmbH is a German aerospace company which is the developer of the Lilium Jet, an electrically powered personal air vehicle capable of VTOL flight.  [IT & SERVICES] FP&A Director,📍Tysons, US Alarm.com is the leading platform for the intelligently connected property centered on security and remote monitoring.  [MANUFACTURING] FP&A Director,📍Rueil-Malmaison, FR The Mayoly Spindler Laboratory is an independent and international French laboratory that has been developing for more than a century.  Hiring? Submit a job!Other Positions  [GAMING] Junior FP&A Analyst,📍Paris, FR Ubisoft is a provider of gaming services that publishes and distributes video games in both physical and online formats

720
Benji
W
wyunngOccasional Observer
asked in Questions & Conversations
Many-to-Many Index Match Based on Dual Properties in Transaction Lists

How can you adapt the index match function in a transaction list to handle a many-to-many relationship, where a combination of 'Region' and 'Department' might correspond to multiple 'Project Codes' and vice versa?For example, both Region '1' and Department 'A' could be linked to multiple Project Codes, and a single Project Code could be applicable to various combinations of Regions and Departments. What techniques or formulas can we use to index match on these two properties simultaneously while managing such a many-to-many relationship?

2241
Benoit
Community Manager
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 

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

2074
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 

4181
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

1332
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

1872
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!  

1904
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,

874
C
Seasoned Pigmenteer
Benji
BenjiPigment Academic
published in Career Forum
The FP&A Jobs Report #55 (Dr. Martens, Foot Locker, YouGov...)

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   [BUSINESS CONSULTING & SERVICES] FP&A Managing Director,📍London, UK CFGI is a unique and highly specialized financial consulting firm that is strategically positioned to help companies through a range of routine and complex business scenarios.   [MANUFACTURING] FP&A Director,📍Paris, FR Candia belongs to the Sodiaal cooperative group, France's leading dairy cooperative.  [ADVERTISING SERVICES] VP of FP&A,📍New York, US DoubleVerify is a leading software platform for digital media measurement and analytics.   Hiring? Submit a job!Other Positions   [IT & INTERNET] FP&A Manager,📍Paris, FR Leboncoin is France’s go-to destination for buying, selling and matching top talents with great companies.  [FINANCIAL SERVICES] FP&

1200
Benji
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

2272
E
Seasoned Pigmenteer

Badge winners

  • Pigment Like a Pro
    basilhas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    basilhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Modeling Fundamentals Certified
    Juliette92has earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Juliette92has earned the badge Pigment Like a Pro
  • Pigment Like a Pro
    Sam Hhas earned the badge Pigment Like a Pro
Show all badges
Terms & ConditionsCookie settings