Connect with other users, discuss how you're using Pigment, and get inspired
Find everything you need to get going
Learn about Pigment features
All the best practices and the guides from the Pigment team
I have a metric that has two dimensions that have pasted values from another source. What I would like to do is return the last month that there is a value > 0 for a specific row in the metric. In Excel terms, this would be done with a MAXIF function where I would return the max month with the condition that “Net Installs” is > 0. From the screenshot below I want to return the month dimension value of Dec 24Can this be accomplished using just the BY modifier and the MAX aggregation method? Any insights are very much appreciated. Thank you in advance.
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, FR Cint is a global software leader in digital insights gathering and has the world’s largest consumer network for digital market research, made up of over 155 million engaged respondents across more than 130 countries. [MANUFACTURING] FP&A Director,📍Franklin, US Mars is a unified force of 140,000+ Associates and the world’s leading manufacturer of chocolate, chewing gum, mints, and fruity confections. [MANUFACTURING] FP&A Director,📍Boston, US By delivering ultra-high performance and energy efficiency, Lightmatter’s compute engine will power rapid advancements in AI while lowering its environmental footprint. Hiring? Submit a job!Other Positions [FINANCIAL SERVICES] Strategic Finance Lead,📍London, UK
Hello, i would like to do the sum or the average of last 12 months before the switchover month. Thanks for your help
Hey team, I have an issue to chose the proper modifiers in one of the metric blocks. I have a quota values by month by sales rep and wanted to sum these values into the quarters as a first step. So I’m writing a formula= Metric block with quotas by month [by sum: Month.Quarter]Next step is to use in quarter seasonality which is by Month, see the screenshot below. Total for a quarter is 100%. What’s the syntax to spread quarterly quota value to months ( I was testing add constant but it didn’t work) and then use the in quarter seasonality?
Hi! Is there a way I can change the color setting such that Unbilled and Billed dimensions are in different colors? Thanks in advance!!
I have a dimension that is a number (30 Day Cohort). I think I will need an identity matrix for some calculations later in my model. Is it possible to create a metric that has the 30 Day Cohort x 30 Day Cohort? Here is a simple example of what it would theoretically look like.I have tried playing around with the Value function to convert to numbers and do some sort of comparison to the dimension but it doesn’t return what I would like:IF(VALUE('30 Day Cohort'.Name)<VALUE('30 Day Cohort'.Name),0,1)[BY SUM: '30 Day Cohort']Any ideas or things to try would be much appreciated. At the end of the day, the 1s in the matrix will eventually be values calculated from other metrics but I think I need this matrix to do those calculations. But then again I may not given Pigment’s various functions and how it handles dimensions. So any and all ideas are welcomed :) Thank you in advance!
currently the user needs to expand the filter selection and select the specific filter criteria. Was wondering if there is any action buttons similar to “SLICERS” in Excel ?
Hello, Can you please help me creating a formula to show net working days for each month?The excel formula will be like this: So far, I created a dimension I referenced the article here but could not really understand what I should do to get list of working days for each month. Thank you!
Image URLs can be entered into text formatted Metrics and List properties and be displayed as images that get larger when you place your mouse on them. This article discusses the steps necessary to get images displayed in grids. Table of ContentsUse cases for images in Metrics and Lists How do I set up an Image in a Metric or List property? Step 1: Get an Image URL Step 2. Set Data type to Text and Display as Image Display text as an Image in Metrics Display text as an Image in Lists Step 3. Place URL into Metrics or List properties How to approve an Image URL Domain Tip: Adjust the layout size for images to appear larger All Image URLs used in Metrics or List properties must come from a domain that is approved by a Security admin. Learn more about Approved domains for images. Use cases for images in Metrics and Lists Images in grids can be a powerful addition to your Boards. They can be used to put a face to an employee or to add an image to a SKU making it easier to ide
Dependent dropdowns, dynamic content in Automations, and SSO for all! Hi friends, It's almost back-to-school time, and while you've hopefully been soaking up the summer sun, we've been crossing off your supply lists proactively with some shiny summer releases ☀️ We've shuffled things around in the newsletter this month, but scroll through and you'll find: The return of FP&A Week, back and better than ever Personal views, dynamic content in automations, and a couple more juicy product updates Our first-ever Academy event so you can help shape your Pigment learning journey Some familiar faces in our Community spotlight 👀 And, of course, you already had my name in your inbox once this month talking about SSO, which gets another shout-out 📣 Summer may be almost over (sorry for the reminder!), but we're just getting started. So settle in, and let's see what's new. FP&A Week is back! FP&A Week is back from October 10th to 13t
Hi,What’s the criteria to have a another level of breakdown?I was able to have two levels of break down for one of the metric but for the boxed one “R&D SAAS Total” another level of break down doesn’t show up even though the dimensions are all different for each level that I wanted to select. Can anyone share what is the rule/condition to be followed for such multiple level of break down in a table?Thank you!
We’ve created two scenarios for the BP on 24: Target and BudgetThese two scenarios are items belonging to the dimension “Version”.In the attached table, we want to add two new comparative columns, one being "Target bp 24/FY23" and the other "Budget bp 24/FY23". However, it does not allow us to add this calculated item because we cannot compare different dimensions (version and year).How can we do this comparison? it is crucial to be able to compare as many scenarios as we want with the previous year's figures
Dears,I have the historic sales per month, and we have strong seasonality, but also and upward trend. I would like to use the FORECAST_ETS function, however, I don’t understand how to get the value of seasonality. For example I know every July and August we have a drop and then it gets higher on September. In this case the seasonality would be 12? If I want something more exact can I use Python and then get the equation and plug in pigment? For calculating a better seasonality number, alpha, beta and gamma, is there a way to get those numbers in Pigment, or I need to have another application, such as Python or R? Thanks in advance! Jose
Hi Team I need to compute cell by cell XIRR . So for example, first IRR will be calculated from FY21 to FY 22, FY21 to FY 23 . them FY21 to FY24 and goes on and on. Is there a way to achieve this? So its an expanding calc starting with FY21 and keeps on expanding by brining in additional year. ThanksMusab
Hi, all, I am currently working on a 3 segment cashflow model within pigment. We are currently trying to model the operating cash flow but are stuck with an issue regarding a circular dependency.Within the model, we calculate cash flows (investing, operating and financing). The operating cash flows use management fees to calculate the tax paid, however the management fees are based on total assets which include cash and cash equivalents, which in turn is based on the net cash flow (derived from the combination of investing, operating and financing cash flows). This ends up with a circular reference. Our excel document avoids the circular reference by utilizing the net cash flow from the previous quarter, however doing this in pigment ends with the same circular reference
26 Articles
33 Articles
98 Articles
31 Articles
14 Articles
22 Articles
42 Articles
1 Article
7 Articles
39 Articles
21 Articles
Contact our support team and we'll be happy to help you get up and running!
Already have an account? Login
Single Sign-On Need help?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.