Explore the Community

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 positions1️⃣ [SOFTWARE] VP of FP&A @Acumatica, a leading provider of cloud business management software that empowers small and mid-size businesses to unlock their potential and drive growth.Acumatica is hiring a VP of FP&A to work from our Kirkland, Washington office and lead our worldwide financial planning and analysis team. The position is critical to Acumatica’s continued growth and development. Experienced FP&A professionals who drive business insights and continuous improvement, bring a quantitative, data-driven mindset, and have outstanding communication and interpersonal skills please apply for this new position!📍Kirkland, US 2️⃣ [SOFTWARE] VP of Strategic Finance and FP&A @Choco, whose platform connects restaurants and suppliers, improving the order process to save time, money, and food.The VP of

We are currently utilizing a Google Sheets connector to a worksheet that has a series of data that contains old logic that we wish to calculate within Pigment going forward.  In this particular example, the Google Sheet worksheet contains both  Annual Amounts (which we want to import), as well as Monthly Amounts (which we want to ignore and recalculate within Pigment as this was using a historical spread methodology to be augmented in Pigment).  We are finding during the configuration of the Import, when we elect to Ignore (delete the columns from the import definition) and kickoff the integration we get failures, stating the following: Two questions: Is it assumed that in the below example, the desired data must come first and cannot be situated after data that is desired to be ignored? Is ignoring columns when utilizing a Google Sheets Connector not allowed?  

Hi. First time poster here. :)We import transaction-level data with revenue and other info. One dimension in the data is “account cohort month”, which lists the month an account was created. This is a dimension list in the calendar of our hub. However we have many transaction-level rows with a blank “account cohort month”. This is correct, as there are specific internal rules to what is considered an account.When we try to create metrics pulling revenue from the transaction-level load, it is excluding all those with a blank “account cohort month”. We don’t want to exclude the blanks. When we analyze the cohorts, we want all the cohort months but also a bucket for “no cohort” or similar.What’s the best practice for handling this? The transaction-level data is MANY rows, so manipulating the data in Pigment is probably ill-advised. We could have blanks populated as “NULL” or “No Cohort” before loading to Pigment, but since this isn’t a calendar item, would that even work? (Or how would we

Every quarter we award our most 20 active users of Pigment with the Top Modeler badge 🏆 We’re delighted to announce the recipients for Q1 2023 as:@Emilia , @Eda, @venitiav, @lpaul, @Alexandre, @Anas Tahri, @CBGong, @laura, @Olivia Van Gerven, @rschimm, @Yannick, @Antoine, @Josh, @Thanh, @Rares, @Anthony, @Clément Betin, @ClementineEv, @Vmanek, @Guillermo Puls  🥳🥳🥳Thank you for your commitment and exploration of Pigment! We’re excited to hear more about how you’re using Pigment at your organisation 👏 We’ll be back after Q2 with another round! 

Hello, can you please help me with formula something similar to vlookup?Trying to fill in the Division property using the Department code dimension.Tried using “ITEM('PL GL Data'.Department,'Department Code'.'Department Name')”, but error says “ Error: Expressions are incompatible and cannot all be converted to Dimension (Department Code)” Thanks in advance!   

Hello Community!  I created a metric where I can see the revenue of a product split by different countries per month. I can then use the aggregator “MAX” to give me the maximum obtained revenue - e.g. in which country the revenue was the highest that month. I would like to use this value (thus the name of this country) in a separate table where I have already other information on this product. What I would like to add in this table is thus “Product X - Top performing country”. Would this be possible? Thank you very much in advance! 

Hi, Is there any way as an admin to track when an user last logged into Pigment / track this over time? Would be great to have in order to track the actual adoption of Pigment across the business, given that a lot of user will only be consuming information (not making any changes to the assumptions, which would have appeared in the History logs). 

Generally, we create metric for current month or year and use it for further calculation.If we can use variable in formula than we will not have to create metric for the same.So I would like to know that we can use variable in formula, if yes then how?

Hello, I want to automate the loading of a statement. To do this, I have a database that assigns each keyword in a label to a category.I would like that when I reload my statement, Pigment recognizes the keyword in each label and assigns it to the corresponding category thanks to the created database. What formula can I use? Thank you 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 ThursdayExecutive positions1️⃣ [IT SERVICES & CONSULTING] Corporate Finance Director @Coalition, the world's first Active Insurance provider designed to help prevent digital risk by combining comprehensive insurance coverage and cybersecurity tools.The Coalition FP&A team is passionate about solving some of the company’s most pressing business issues. The team is responsible for leading Coalition’s budget, driving annual and quarterly planning processes, allocating and deploying the company's resources efficiently, performing financial analyses, and partnering with teams across the company. The role requires someone who is highly analytical and strategic, a great communicator, approaches problems in a structured manner, and is comfortable with ambiguity. You’ll get substantial visibility, focus on the highest-priority business i

Hey team, Can we load data from Pigment into BigQuery? Thanks

I accidently changed a property from text to dimension and I lost all the date that was on the property of this dimension, this dimension list is extremely crucial and is the building block of other boards. Is there anyway I can have it back please?

Hi Pigment community,I want to realise a LTM (Last Twelves Months) analysis for a metric.For the moment, I’m able to cumulate only by the beginning of the period with the function:CUMULATE(Revenues,Month)[Filter: Month.Year = Year."FY 22" OR Month.Year = Year."FY 23" OR Month.Year = Year."FY 21"]I can make it “restart” each year with using CUMULATE(Revenues,Month,Month.Year) but I want to cumulate the last 12 Months onlyLTM Revenue Feb 22 should be starting from Feb 21 and not Jan 21.How can I do that?Many thanks

Hi everyone, How can I change the scale on y axis for bar chart? Pigment has set up the scale automatically which is not perfect as I would prefer to see it starting from 0. Is there a way to update this?  

Hi friendsI am unable to build vertical waterfall chart so, I would like to know how we can build vertical waterfall chart, if it is possible.

Hello,I need to export a Table with API, when I test in Postman my get URL, I have an error 500 after 15 seconds.When I filter my table in Pigment, it works so can we adjust the API timeout ?Thank’s for your help.Nicolas.

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 Thursday Want this in your inbox every week? Sign up here!  Executive positions1️⃣ [SOFTWARE] VP Finance @Armis Security, the leader in asset visibility and security addressing the new threat landscape created by connected assets.This position reports directly to the CFO. You will be responsible for implementing financial processes and systems as Armis continues to grow, heading towards IPO and beyond. Experience leading a company through an IPO process and operating as a public company post IPO; this leadership role actively partners with other leaders across Armis in addition to leading the finance organization.📍 New York, US 2️⃣ [CHEMICAL] Director, Financial Planning @LGC, an international life sciences measurement and tools company.The Director Financial Planning role involves developing and managing financial analysis procedures,

 Welcoming the Pigment Community Lounge, our new corner of Community dedicated for casual discussion 💬 Weekly questions, FP&A industry talk, favourite movie – what have you! Come share in the Lounge :) The purpose of the community is to promote connection among Pigment users, which is why we want to get to know you even better. Go check it out here, see you in the Lounge!

Hi Community,Having a weird issue where when scheduling a webhook push from looker I’m unable to import all the data when setting the delivery to be All Results vs Results in Table. When doing Results in Table i’m able to import everything instantly but when configuring and sending a test for all results it doesn’t seem like any import is kicked off. Wondering what is occurring on the backend and if this a looker or Pigment issue. Setting I need to apply When having it for Results in table the import worked  

 I need to add a column to calculate the income [ m- (m-1)] in order to get the difference in income between two months do you know how to do it Thanks  

Hello!I have created AR rules to give a person access to one country only. I have verified the access on all blocks through the impersonate feature and everything seems to be working. However, the person doesn’t have access to some tables (though he has access to the correct data in the metrics composing the table)… This message appears:Could you please help me to understand what is happening here?Thanks!Elodie

I would like to know what is the best practice for Actual , Budgeting and forecasting.Option 1: Create a separate Version DimensionOption 2: Create Scenario for Actual, Budgeting and forecasting

Pigment User Group meetups are here again! 😍Join us to meet the Pigment team and fellow Pigment users for an afternoon of program and mingling 🎉 The goal of the Pigment User Groups is to connect, elevate, and inspire a community of customers within their local area to meet each other in person (and receive some Pigment swag ofc). When & Where?San Francisco: April 26th Paris: April 27th New York City: May 10th Boston: May 11th How do I sign up?Get in touch with your CSM for further details and to secure a spot! :) Agenda:1:45pm - 2:00pm   Arrivals2:00pm - 5:00pm   Program5:00pm - 7:00pm   Happy Hour See you there! 👋

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 positions1️⃣ [SOFTWARE] Vice President, Financial Planning & Analysis @ Acumatica, a cloud ERP company that provides cloud business management software for small and mid-size businesses.Acumatica is hiring a VP of FP&A to lead their worldwide financial planning and analysis team. The position is critical to Acumatica’s continued growth and development. The responsibilities of the role include building and leading a best-in-class worldwide FP&A function, developing and maintaining high-quality business partnering activities, and collaborating with executives to provide financial expertise and guidance on strategic initiatives.📍 Kirkland, US 2️⃣ [SOFTWARE] Senior Director, Technology & Services FP&A @ Deltek, the leading provider of small business and enterprise software for project-based businesses.The

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📣 Research opportunity with Pigment 📣Our research team at Pigment is looking to learn more about individuals in Finance teams at growing companies. We are looking to speak to individuals working in Finance teams at businesses with over 2,000 employees. The team will give you a gift voucher for your time. If this sounds interesting, drop an email to ellen.humphreys@gopigment.com.Thank you!Executive positions1️⃣ [SOFTWARE] Vice President, Financial Planning & Analysis @ Billtrust, the leading innovator in AR automation and B2B payments.As the Vice President of Financial Planning and Analysis you will be responsible for providing management with an analysis and insight of Billtrust’s financial results in coordination with the broader Finance team. You will oversee all aspects of the annual budget, quarterly forecasts, data analyt