Explore the Community

Executive positions1️⃣ [SAAS] Head of FP&A @ mParticle, a customer data platform for every screen, built with Privacy by Design.Partner with and build strong relationships with business partners across the organization; working closely to develop and translate financial forecasts and operational metrics into actionable guidance that assists with decision making. Proactively identify areas for business improvement and produce persuasive, data-driven arguments to support good decisions.📍 Remote, New York, Seattle, San Francisco, US 2️⃣ [SAAS] VP, Finance - Financial Planning & Analysis @ PagerDuty, a cloud computing company specializing in a SaaS incident response platform for IT departments.Maturing and evolving the FP&A function to become proactive, predictive and insight oriented, enabling our business leaders to make strategic decisions and grow our business. Selecting and leveraging the latest technology and automation capabilities to ensure that standard reporting and

Executive positions1️⃣ [SAAS] VP of Strategic Finance and FP&A @ Choco, the largest free ordering platform connecting restaurants and their suppliers.As VP of Strategic Finance and FP&A, you will take on and build out strategic analysis across multiple product lines, geographies, monetisation initiatives and competitive landscapes. You will report directly to the CFO with very high visibility across the organization. 📍 Berlin, DE 2️⃣ [LUXURY] Senior Director, Financial Planning + Analysis @Louis Vuitton, a French high-end luxury fashion house.You will play a critical role in the development and implementation of financial, strategic and growth objectives aimed to provide long term profitable growth for the company. As Senior FP&A Manager you will develop and lead an impactful strategic finance team.📍 Oakland, US 3️⃣ [SAAS] Director, International Finance @LTK, the largest global influencer marketing platform.As Director International Finance you are responsible for suppor

Hey everyone! I’m trying to create a cohort framework in the backend of the model. To do this, I’m using my Datahub::Month dimension and my Revenue app::Cohort Months dimension. It should generate something like:                    0             1             2Jan 23    Jan 23     Feb 23    Mar 23Feb 23   Feb 23     Mar 23    Apr 23Mar 23   Mar 23     Apr 23    May 23 and so on. Is this the best practice to enable cohort logic for things like churn? To create my Cohort Months dimension, I can manually type integers 0 through 60 for example, but is there a way to use PREVIOUS() to just increment 1 each row to do this? Screenshot:  

Executive positions1️⃣ [SAAS] Director of Financial Planning and Analysis @ Superside, an always-on design company that delivers great design at scale to Enterprise teams.Reporting to the CFO, you will lead a team that supports the long-term strategic planning of Superside and helps all of our business areas with financial analysis & planning.📍 Fully remote 2️⃣ [BIOTECH] Director, Financial Planning & Analysis - Customer @ Sarepta Therapeutics, a medical research and drug development company.The Director, Financial Planning & Analysis (FP&A) serves as the lead partner between Finance and the Sarepta Customer Organization. This position provides critical financial input for strategic and operational business decisions and processes, challenging or advocating as appropriate, with a focus on revenue forecasts and operations, cashflow and profitability.📍 Cambridge, MA 3️⃣ [ENTERTAINMENT] Director, FP&A, Digital @ Wizards of the Coast, a family of studios specializing

Hello Pigment Community!I would like to delete an item in a Dimension (which has been created by an error in the settings when importing data), but because this Dimension is used by several blocks, I don’t want to delete data in these other blocks. Could you please help me to find a way to see if said item is used by other blocks and if I can simply delete the line containing the wrong item in the Dimension?Thank you! 😊

Executive positions1️⃣ [FINTECH] Director, GTM FP&A @ Human Interest, levels the playing field on retirement by making employer and employee retirement savings more intuitive, more affordable, and more inclusive.Be the FP&A lead supporting our Revenue teams, own financial and headcount planning, performance reporting, and be the primary finance partner to the CRO. Lead the monthly, quarterly, and annual FP&A processes for the Revenue organization, including management reporting, variance analysis, forecasting, and scenario planning.📍 Remote, US 2️⃣ [B2B SaaS] Vice President, FP&A @ Datadog, cloud-scale monitoring and security for metrics, traces, and logs in one unified platform.Lead and build a best-in-class FP&A team that can strategically think through setting up our financial processes and tools for the future, as well as create proactive working partnerships with budget owners to ensure smooth financial operations📍 New York, NY Hiring? Submit a job!Other posi

Hello Team,Is there a way to reference an object(from a transaction list) within a metric without having it auto aggregate? See screenshots for reference.  

 We are trying to make the average of all the elements of the country dimension (in rows). When we change the pivot country from rows to pages, it makes the sum of the lines and not the average. Thank you in advance for the help and the contribution to the pigment community ;)) 

Executive positions1️⃣ [PROPTECH] Head of Financial Planning & Analysis @ AVIV Group, one of the world's largest digital real estate tech businesses and a subsidiary of Axel Springer.Enhance and improve our planning and performance management landscape by leveraging the power of financial and analytics systems and actively engaging with stakeholders across the group to set ambitious but achievable goals.📍 Paris, FR 2️⃣ [SAAS] Senior Director of Corporate FP&A @ Neo4j, helps organizations capture the rich context of the real world that exists in their data to solve challenges of any size and scale.This new role will lead Neo4j’s financial planning processes, including our Annual Operating Planning (AOP), quarterly forecasts and the company's long-range planning. Responsibilities also include management of the external financial reporting process, development of financial analyses models, leveraging business intelligence tools and supporting strategic initiatives.📍 Remote, US 3

Hey Team,I am working on an Existing Fixed Rate Loan walk-forward build. In the source system, the original fixed monthly payment is calculated by the following:  IF    Loan Term <> 0THEN    PMT(Interest Rate Origination Period / 12, ABS(Loan Term), ABS(LoanAcquisitionActualUPBAmt), 0, 0)ELSE    PMT(Interest Rate Origination Period / 12, Loan Term Final, ABS(LoanAcquisitionActualUPBAmt), 0, 0)Does Pigment have an equivalent function to calculate PMT? (Calculates the monthly amount required to pay back a loan given each payment is equal) Please advise - Thanks!

Executive positions1️⃣ [AEROSPACE] Director, FP&A - Space Missions & Safety @ Virgin Galactic, an aerospace and space travel company, pioneering human spaceflight for private individuals and researchers with our advanced air and space vehicles.Create, improve, and maintain financial processes. Responsible for leading, coordinating and consolidating the business unit budgeting, forecasting, and reporting processes. Includes preparation of comprehensive business reviews and updates to Executive-level audiences.📍 Tustin, US 2️⃣ [REAL ESTATE] Head of FP&A @ Mynd, an end-to-end real estate platform that helps investors find, buy, lease, manage, and sell residential investment properties.This position plays a critical role in the development and implementation of financial, strategic and growth objectives aimed to provide long term profitable growth for the company. You must be a hands-on, roll up your sleeves type of leader and should enjoy a fast-paced, start-up environment.📍

Executive positions1️⃣ [LOGISTICS] VP Corporate FP&A @ Flexport, a platform for global logistics—empowering buyers, sellers and their logistics partners with the technology and services to grow and innovate.Lead a team with responsibilities for the annual and long term plan, forecast, and monthly reporting. In addition, you will be responsible for ad hoc analysis, executive level decks for C-level staff members, and Board of Directors reporting. In this capacity, you will lead and manage results for the P&L, balance sheet, and cash flow statements.📍 Dallas, US 2️⃣ [FINTECH] VP FP&A @ Remote, a global payroll, tax, HR and compliance solution for distributed teams.You will work closely with our CFO, CEO and senior leadership team to oversee the company’s annual budget and quarterly planning process. You’ll influence and drive strategic initiatives in partnership with our Product & Engineering, Operation and Go to Market organisations.📍 Remote, UK 3️⃣ [SPORT] Director, F

Every quarter we award our most active customers from within the Pigment app with the Top Modeler badge. Our Q3 recipients are @Josh @Eda @rschimm @Megan Richards @Rares @Alexandre @Adelgo @Anas Tahri @Yannick @Roy Stolero @Erwan @Clakss @Anthony @Yann Intes @Ifat Haham @Tanguy de Becdelievre @Sai @Marie Moisan-Plouhinec @Dastan You are all rockstars! Keep it up!

There have been a few instances where we need to take the fist value of a metric and have it populate earlier periods that are blank and take the last value and populate remaining blank periods.Lets assume we have a metric called Salary, with a set of values from a limited period (i.e., Mar - Jun):Jan Feb Mar Apr May Jun Jul Aug     5000 5000 5250 5250     Below is the final result we need :Jan Feb Mar Apr May Jun Jul Aug 5000 5000 5000 5000 5250 5250 5250 5250  I’ve seen the use of the previous function to populate the earlier periods:if(isnotblank(Salary), Salary, previous(Month on -rank(Month.’Start Date’))and a slightly adjusted formula to populate the later periods (i.e., take out the - in front of the rank function): if(isnotblank(Salary), Salary, previous(Month on rank(Month.’Start Date’))I’ve been unable to find documentation on how the previous function uses the on parameter.Is there another way to accomplish this or

I try a simple formula in a Transaction list of 91.000 items and it doesn’t get the result. It has been updating for 5 minutes, finished and the cells remained empty.  

Hi, community! I have an error “This CSV size is too big. Please reach the support for more information” I cant find information about the maximum size of csv. I think it will be interesting for another members.  

Is there a spell check function within Pigment? If so, how do I activate it and configure the settings ( UK English for example)

How do you align values or text in a column?See below example. How would I center the values listed in the AOV column?:  

Executive positions1️⃣ FEATURED 🌟 [FINTECH] VP of Finance @ Kaiko, bridge traditional and blockchain ecosystems by providing reliable and actionable financial data and services.Responsibility for investor relations, financial due diligence as well as the execution of mergers and acquisitions, company structuring as well as oversight of the finance & accounting and financial planning & analysis teams, company audits and financial operations of the organization plus tax and asset management strategy of the company.📍 Paris, FR or London, UK→ Send a note to Ambre (CEO) for a direct intro 2️⃣ [DaaS] CFO @ Inrix, help the world avoid global gridlock by empowering cities, drivers, and businesses around the globe.Responsible for the company’s worldwide Accounting, FP&A, Tax, Treasury, Investor Relations, and Audit functions, the CFO will be a key member of the company’s management team and report to the President & CEO.📍 Kirkland, US 3️⃣ [SaaS] Director, Corporate FP&A @

Hi Pigment team,I am working on the report, which contains multiple columns with amounts (i.e. tax codes with its own amounts for each employee). Something like following:The issue is, when I want to import this into my Transaction List, I have to manually create 4 columns with different names (NYSD, MPEP, etc.) to capture amounts. And, this source file comes with additional columns (new Tax codes) every time, so I need to change the import settings every time to add new columns.Is there way to automatically add these column headers to, maybe dimension list, and make the system capture new amounts automatically?

We’ve connected Greenhouse to Pigment and aren’t sure how to import the “Target Start Date” field.We’re currently sourcing the Job data type → Open Recs, and most fields needed for workforce planning appear, but target start date is missing. Any suggestions here?

Hi everybody, It is very time-consuming to reorder dimensions with a hundreds of items. Drag-and-drop would be ideal, but it is not there or I couldn’t find it.I have a workaround of creating a `sort order` field for the dimension, but this look to hacky to me. Any tips on easier reordering?

You have probably heard about NPS, a survey that allows a company to measure its customers’ satisfaction. At Pigment, we care a lot about your feedback & we use the NPS survey to have more insights about your experience with the product & the company.  How do we measure the NPS? At Pigment, we send out your first NPS survey one month after your account creation, and then every 6 months after that. You will receive it via email or directly in Pigment and it will look like this:  You will be invited to provide a score from 1 to 10 and, as a follow-up, you will receive an optional question to give more details about your score. Any constructive feedback is welcome and represents an invaluable source of information to make Pigment even better!This optional survey is of great help to us!! If you prefer to opt out, simply ignore. It will disappear after several reminders. What happens after you give your feedback?Once you’ve shared your feedback, your CSM will be notified and will ha

Hello,I know it is possible to create a MoM KPI, but if I add it as a KPI in a board, each month I have to change the month concerned.Is it possible to calculate automaticaly the MoM based on the last month selected in the board ? Example (picture below): In my board I selected the first 9 months of the year. For my MoM KPI, I selected september to offset with the month before. So the result is September-August. But if I select the 10 first months of the year, the KPI does not change. I expect to see automatically October-September.ThanksAdèle 

Executive positions1️⃣ FEATURED 🌟 [B2B SaaS] VP F&A @ Intercom, the Engagement OS, enables businesses to build stronger customer relationships that drive growth and scale.Reporting to CFO Dan Griggs and based in San Francisco, the VP of FP&A will play a key role in supporting Intercom’s continued growth and path to IPO.Bring a strategic mindset combined with sound operational experience and stakeholder partnership to develop and provide insightful, value-added analysis across the company and help drive financial outcomes.📍 San Francisco, US→ If you want to know how strategic is the role to the company, well, contact for the job is Des, Founder and CEO at Intercom (des@intercom.io) 2️⃣ [B2B SaaS] Vice President, Financial Planning & Analysis @ MongoDB, the developer data platform company empowering innovators to create, transform, and disrupt industries by unleashing the power of software and data.Lead a growing and high performing global FP&A team. Create and implemen