Explore the Community

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)

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

 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 Direct

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

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!

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!

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]

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

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

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

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

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

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)

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]

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?

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 

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.

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 

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 mappin

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

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!  

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,

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]

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

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?