Explore the Community

I want to make a welcome message for my dashboard but I want it to be big enough to be used on my dashboard.Any help would be appreciated.This is how it looks like right now. 

Hello Pigment Community, I want to have a metric that has clients in lines and months in columns and that is filled with 1 only for the first month the client bought a thing. So in the end, on each line there should be only one 1 in the month of the first buy. For the moment I created a metric with clients in line and months in columns that is filled with 1 for all the months when the client bought a thing. My idea was to use this metric and the firstnonblank modifier but it does not work… Could you help me please ? 

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 week [CONSUMER SERVICES] Head of FP&A 📍Copenhagen, DK HelloFresh is a consumer services company that revolutionises the way people eat by providing meal kit delivery services.   [RETAIL] FP&A Director 📍Vianen, NL Foot Locker is a global retail company specialising in athletic footwear and sportswear.  [ADVERTISING SERVICES] FP&A Director 📍 Paris, FR Criteo is a global technology company specialising in digital advertising, particularly in performance marketing and personalised retargeting solutions for e-commerce businesses.  [FINANCIAL SERVICES] VP of Strategic Finance 📍Paris, FR Qonto is a French online payment institution for freelancers and SMEs.  Hiring? Submit a job!FP&A Manager 📍Bruxelles, BE Campari Group is an Italian beverage company know

Hi Pigment Community,I am reaching out to bring attention to an issue I've been encountering with Pigment, particularly in relation to the mathematical output it provides. While Pigment generally performs as expected, I have noticed instances where the results are unexpectedly incorrect.To provide clarity, I have attached screenshots displaying the metrics and their corresponding outcomes. I've highlighted the specific instances where Pigment has generated results that deviate from the anticipated values. It's worth noting that there are occurrences where the formula yields accurate results, but the inconsistency raises concerns about best practices and how formulas work. My hope is that you can help me understand the root cause of this issue and provide insights to correct this issue. I appreciate any assistance you can provide in shedding light on why Pigment might be producing these unexpected results. Additionally, I am keen to learn any best practices or recommendations to avoid s

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] Contrôleur de gestion  📍Boulogne-Billancourt, FR Odigo provides Contact Center as a Service solutions that facilitate communication between large organizations and individuals.  [FINANCIAL SERVICES] FP&A Director 📍London, UK Equiniti is a financial services company specialising in business process services, offering technology-driven solutions for administration, payments, and related services primarily in the financial and public sectors.  [MANUFACTURING] FP&A Director 📍Anderlecht, BE UCB is a pharmaceutical company with a focus on developing and manufacturing innovative medicines.  Hiring? Submit a job!Other Positions [SOFTWARE] Financial Planning & Strategy Manager 📍San Francisco, US Checkr provides background check services to

What are the best pratices for intercompany process (Eliminate inter-company transactions )

Hi Pigment Community,I’m currently working on building a conversion rate forecast in pigment and wanted to hear your thoughts on my calendar setup. Context: In our forecast model we are interested only in the current year and previous year. Information older than that is not being included in our forecast, visually and mathematically. Thus, I wanted to have an automated rolling calendar on an annual basis. This way if we are in Oct 2023 my model will show Jan 2022 - Oct 2023, rather than Oct 2022 - Oct 2023.I know that in pigment you can use item variables to easily update variables, such as year, for all views in a model. However, I have opted for a different solution. Instead I have tweaked the ‘Period type’ dimension to include a 3rd item called ‘Actual old’. I then filter my metrics on all data where period type does not equal ‘Actual old’. Additionally, my period type is decided by my switch date, which is automatically chosen based on the max date in my data transaction.Current p

Dear All, How to construct a formula for moving multiplication? Similar to MOVINGSUM but with * rather than + ;)The input is a % movement in given month as per below and I need to construct a compound growth rate. I.e. in 2028 it is 0.9438 (1.3*0.6*1.1*1.1) Regards,Adam

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 [RESEARCH SERVICES] Contrôleur de gestion  📍Paris, FR The Institut Pasteur is a leading global biomedical research institute.  [ADVERTISING SERVICES] FP&A Director 📍Chicago, US Publicis Groupe is the second largest communications group in the world.  [SOFTWARE] FP&A Senior Director 📍London, UK insightsoftware is a global provider of reporting, analytics, and performance management solutions.  Hiring? Submit a job! Other Positions [MEDIA] Global FP&A Process Owner 📍Manchester, UK ITV is a media company that operates commercial television channels, producing and broadcasting popular programs.  [FINANCIAL SERVICES] FP&A Manager 📍London, UK Tide is the leading provider of UK small business (SMEs) accounts and one of the fastes

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

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: (

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

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

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

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 Cost Center   Entity Entity   TBH Request TBH Request   Version Version Version     Month     Employee

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

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?