Skip to main content

Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

881 Topics
Ola
Seasoned Pigmenteer
OlaSeasoned Pigmenteer
asked in Questions & Conversations
FORECAST_ETS vs SEASONAL_LINEAR_REGRESSION

Could anyone provide some guidance on when to use the function SEASONAL_LINEAR_REGRESSION over FORECAST_ETS? In our specific case we have a metric with a yearly seasonality and the overall trend for the metric is going slightly downwards. We would like to use our actuals data to automatically calculate values for all forecast months. I can see that both functions gives me reasonable values for my forecast, but FORECAST_ETS gives me a clearer trend downwards while SEASONAL_LINEAR_REGRESSION gives me more flat forecast. So my question is really, which one would make most sense to use in our case and why?

2551
Thu Mai
K
Newly Minted Pigmenteer
kristian.bartelNewly Minted Pigmenteer
posted in Questions & Conversations
Creating an Application Guide, Board/Block Structures

Hi all, Curious to see how people have approached (1) creating an application guide for new users (specifically something to quick start leaders that don’t necessarily have the time to go through more in-depth tutorials), and (2) board/block structure. I know there’s some documentation on board/block structure, but just curious to get some more context on how people approach it, particularly for revenue focused planning. Thanks!

380
K
Newly Minted Pigmenteer
Y
Newly Minted Pigmenteer
YounesZNewly Minted Pigmenteer
asked in Questions & Conversations
Linear programming

Hello everyone, Is there a feature in Pigment similar to the Solver in Excel that involves solving equations based on many inputs and conditions to maximize or minimize an objective? Regards,

2054
Y
Newly Minted Pigmenteer
C
Budding Pigmenteer
connorsmithBudding Pigmenteer
posted in Questions & Conversations
Table with Metrics the Use Different Scenarios

Hello! I am seeking to make 1 Table that has 2 metrics (image below). The metrics are “P&L” and “Commentary”. For the P&L metric I am seeking to show two different scenarios (“Actuals” and “Q2 Outlook”) For the Commentary metric I am seeking to show ONLY 1 scenario. Is there any way to achieve this? It seems like the Scenario page selectors apply to ALL metrics in a table. Curious if others have found get arounds for this?

1814
W
Rasagya
Newly Minted Pigmenteer
RasagyaNewly Minted Pigmenteer
asked in Questions & Conversations
Scenario Order misplaced in Google Sheets export

Hi all - we are running into an issue with our Google Sheets connector where the order in which scenarios are selected in the saved view does not seem to get passed on to g-sheets. Explaining this in more detail below: We have added a screenshot below showing our list of scenarios. We want “Apr 24 Close / May 24 Reforecast” to be the first scenario and “FY24 Company Plan (Approved Changes)” to be the second scenario -- this is because we want Apr close to be on the left and FY24 company plan to be on the right hand side of our table. When we export this view using the Google Sheets connector, we are required to select the 2 scenarios again and their order seems to be reversed once we pull the data (see second screenshot below). Any thoughts on whether we’re doing something wrong or if there are any workarounds available for this?

2182
Andrea
Community Manager
M
Just Arrived
matt.tafesseJust Arrived
asked in Questions & Conversations
IF statement determined by boolean

Hello - I am trying to update a formula based on a boolean that is determined by the latest date in a data upload. I believe the following equation is close to what I need. Formula: “if('Is Forecast?','Go Forward Cohort'[select:'Go Forward LTV Driver'."Borrower Retention"][BY:->'Map to Cohort Month'] , if('Is Actual?',('2.002 Cohort View - Borrower Retention Lookup')[remove lastnonblank: Month][remove lastnonblank: Cohort][ADD: Cohort]))” There are two issues:1. I want to add a previous function to the first part of the if statement. If there is no data to pull from the “go forward cohort metric” I want the function to pull the last data point there is 2. When updating to the above formula my application will time out. Is there a more efficient formula that will prevent this? Thank you!

2101
Thu Mai
J
Newly Minted Pigmenteer
JV-55Newly Minted Pigmenteer
asked in Questions & Conversations
Combined Views

Hi, Is it possible to create 3 distinct views on 3 distinct metrics, and combine the metrics into 1 table that incorporates the 3 distinct views? Alternatively, say I have a table constructed from multiple rows that are each a metric. It would contain 3 sections (Revenue, COGS, and OPEX). Is there a way to have unique row pivot selections for each of the 3 sections and not having the row pivot selections impact all rows instead? Or will this require 3 unique tables, separating the 3 sections?

3133
CamilleMomo
Seasoned Pigmenteer
A
Just Arrived
AabhiiJust Arrived
asked in Questions & Conversations
Pigment to Azure Export 404 Error

Hi all, I am trying to export data in a given metric to azure data factory. I am following the guide in the pigment documentation exactly, however when i go to pull the data, I get a 404 error. I have set up the export keys and I am using the correct applicationID and the correct metricID. Any insights into what else I may be missing would be great. Thank you

1101
Mat
G
Newly Minted Pigmenteer
Gabriel OrtizNewly Minted Pigmenteer
asked in Questions & Conversations
Excel connector and date format

Hello Pigment community, I am trying to use the excel connector for Pigment and I have realized that when pulling the data the dates are formatted as text. When I change the format to date and I pull the data again it reverts to the text format. Is there a solution to this limitation? Thank you in advance, Gabriel Ortiz

1441
W
A
Seasoned Pigmenteer
A_GarneriSeasoned Pigmenteer
asked in Questions & Conversations
Aggregate data based on a condition using a custom window size

Hi Pigment community, A similar topic has been opened before, the proposed solution was this: However, not all the time I need the same amount of data to aggregate, since my metrics are variable (sometimes I would need to aggregate 10 values, sometimes 1), what its the possible workaround? Tried using a formula like this: CUMULATE('Metric 1 to Aggregate'[FILTER : Month.'Start Date'<=(Month+'Metric 2 Lead Time Weeks').'Start Date' AND (Month+'Metric 2 Lead Time Weeks' + 'Metric 3 Lead Time Periods'-1).'Start Date'>= Month.'Start Date'],Month,"".SUM) Trying to isolate only the months I want to aggregate, but it doesn’t works.I tried to make and very detailed post but for whatever reason the topic wasn’t creating. Tell me if you need more details. Thanks in advance,

3185
Issam Moalla
Employee
K
Seasoned Pigmenteer
KevinSeasoned Pigmenteer
asked in Questions & Conversations
Invite Members in Bulk

Is it possible to invite members to multiple applications at once? Currently I have been going into each application, clicking on Settings, clicking on Roles, permissions & access, and then inviting members there. It would be great if I could select multiple applications for which I am the owner and do a bulk invite. Is there any functionality similar to this in Pigment?

1742
K
Seasoned Pigmenteer
Benoit
Community Manager
BenoitCommunity Manager
published in Career Forum
The FP&A Jobs Report #85 (Poshmark, Gong, Bose, GE Healthcare...)

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 Highlights Poshmark [RETAIL] FP&A Director 📍Redwood City, US Poshmark is a leading fashion resale marketplace powered by a vibrant, highly engaged community of buyers and sellers and real-time social experiences. Insight Global [STAFFING & RECRUITING] FP&A Director 📍Atlanta, US Insight Global is a staffing and talent solutions company that specializes in providing workforce solutions. Dechra Pharmaceuticals [MANUFACTURING] Head of FP&A 📍Northwich, UK Dechra Pharmaceuticals is a UK-based company that develops, manufactures, and distributes veterinary pharmaceuticals and related products. Other Positions Gong [SOFTWARE] FP&A Manager 📍San Francisco, US Gong is a revenue intelligence platform that uses artificial intelligence to analyze sales calls, meetings, and emails. Bose [MANUFACTURING] Senior FP&A Advisor 📍Atlanta, US Bose C

4160
Benoit
Community Manager
Jared Dolich
Seasoned Pigmenteer
Jared DolichSeasoned Pigmenteer
asked in Questions & Conversations
Align Block Exercise - Values aren't adding up right?

Hi. I just finished the Align Block Dimensions for Formula Operations exercise. In the final table, we are to add the four metrics we created. No problem. But, when I look at the table my bonus metric does not match the “solution”. When I check the data, it adds up correctly to year and the formulas match. Any suggestions? Same formula. Did I miss a stop in the course? I didn’t see any instructions on how to build this table, so i’m kind of winging it. Here’s my result: Here’s the solution:

1444
CDALMAY
R
Newly Minted Pigmenteer
Rahul KumarNewly Minted Pigmenteer
asked in Questions & Conversations
R&D Capitalization Schedule

Hi All, I am trying to create a R&D cost Capitalization schedule and need some help. Essentially which I am trying to do is spread the cost over 3 years but then add the incremental monthly amount as well. For example: If Jan 2024, my R&D cost is $1200 and $2400 for Feb, then I should see $100 (1200 / 12) for Jan 2024 till Dec 2024 and for Feb cost, it should be $300 ($2400/12 + 100). I hope i am clear in my ask. Thanks

2171
CDALMAY
M
Newly Minted Pigmenteer
Moosa MalickNewly Minted Pigmenteer
asked in Questions & Conversations
How to Calculate MoM Change Using Formula

Hi, I am trying to calculate the MoM change in a metric, I know there is an option of ‘Show Value As’, but that just creates a view on top of the existing numbers and does not perform a calculation on the cells. Is there a way I could do a MoM change using a formula? Thanks

1201
CDALMAY
Jared Dolich
Seasoned Pigmenteer
Jared DolichSeasoned Pigmenteer
asked in Questions & Conversations
To See Block Size - Full Read Needed?

Hi Pigment Community. So, it just occurred to me as I’m going through the courses that I cannot tell if I’m creating blocks/metrics that are too big. I read an article by @Samya Barkaoui on block building best practices that mentioned I need full read access to see these statistics. Is that correct? Who do I contact to obtain this and is this something that modelers don’t normally need in Pigment?

2533
Issam Moalla
Employee
Benoit
Community Manager
BenoitCommunity Manager
published in Career Forum
The FP&A Jobs Report #84 (Juni, Mastercard, Etsy, Storio Group...)

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 Highlights Storio Group [SOFTWARE] FP&A Director 📍London, UK Storio Group specializes in creating innovative digital solutions and custom software for businesses. Flink [IT & INTERNET] FP&A Director 📍Berlin, DE Flink is a rapid grocery delivery service that operates in various cities. Juni [FINANCIAL SERVICES] Head of FP&A 📍Stockholm, SE Juni is a financial management platform designed for e-commerce and online businesses. Other Positions Mastercard [IT SERVICES & CONSULTING] FP&A Manager 📍Waterloo, BE Mastercard is a global technology company in the payments industry. Fresh [MANUFACTURING] FP&A Manager 📍Jersey City, US Fresh is a skincare and beauty brand that offers a range of products made with natural ingredients. Verkada [SOFTWARE] FP&A Manager 📍San Mateo, US Verkada is the largest cloud-based B2B physical security platf

810
Benoit
Community Manager
Benoit
Community Manager
BenoitCommunity Manager
published in Career Forum
The FP&A Jobs Report #83 (Safran, Deliveroo, Figma, Spotify...)

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 Highlights Hilton [HOSPITALITY] Global FP&A Director 📍McLean, US Hilton is a multinational hospitality company that owns and operates a wide range of hotels and resorts worldwide. LGC [RESEARCH] FP&A Director 📍London, UK LGC is a leading, global life science tools company, providing mission-critical components and solutions into high-growth application areas across the human healthcare and applied market segments. Safran [MANUFACTURING] FP&A Director 📍Plaisir, FR Safran is a multinational aerospace and defense company based in France, specializing in aircraft engines, aerospace propulsion, and equipment. Cedar [STAFFING & RECRUITING] FP&A Director 📍London, UK Cedar is a financial technology company that provides patient engagement and financial management solutions for healthcare providers. Other Positions Deliveroo [INTERNET M

1090
Benoit
Community Manager
C
Budding Pigmenteer
connorsmithBudding Pigmenteer
asked in Questions & Conversations
"Failed to acquire a shared lock during metric creation" Error Message

I have recently been getting the following error message semi frequently:“Failed to acquire a shared lock during metric creation” It is mostly happening when I am trying to edit P2P imports (ie. within a Metric, click Import Data, click Edit on an existing import configuration) Anyone know what this means?

1891
M
Employee
K
Budding Pigmenteer
Kamil SobczakBudding Pigmenteer
asked in Questions & Conversations
Fx management in Pigment - Workoforce app

Hi Everyone, We would like to have an easy workflow and process for compering Budget USD salaries at budget FX rates vs Budget USD salaries at actual FX rates. Is it a right approach to create a FX version dimension like FX actuals, FX forecast, FX budget etc? Or is it more efficient to utilise our current Version dimension and once we have a budget version we just make a copy of it and update FX rates in that version based on actuals to get the re-calculated USD budgeted salaries as per most recent rates? So the use case is: having an easy way to understand the FX impact in the BvA report. Example:Employee with 10,000 EUR salaryBudget EUR/USD rate: 1.2Budget USD: 12,000 USD salary Netsuite Actuals EUR: 10,000 EUR salary (same)Netsuite EUR/USD rate: 1.3Actuals USD: 13,000 USD Salary BvA = (1000) USD We would like to then easily explain to budget holders that this 1,000 USD overspend is pure FX and not their "real" action on spending more. Thanks!

1343
Nathan
Employee
Keiran
Community Manager
KeiranCommunity Manager
posted in Questions & Conversations
Finding specific text in a string

This was asked internally, and I thought I’d share the answer in case it’s of use to others! If you have a specific term you want to look for, in this case ‘Intern’, it can come up in Position names, but you may get false flags for longer words like ‘International’ To identify these, I’ve created an IF statement that checks if the term is in use by checking for the trailing space, or checking if it’s the last word in use. First, use RIGHT, with 6 being the number of characters required to identify the word. RIGHT(Positions.Name,6) Second, look for the word “Intern “ including the trailing space. IF(CONTAINS("Intern ", Positions.Name), TRUE, FALSE) Then you just need to nest these to make one formula IF(RIGHT(Positions.Name,6) = "Intern", TRUE, IF(CONTAINS("Intern ", Positions.Name), TRUE, FALSE)) It even works with International Interns!

2112
KarlW
Community Manager
M
Newly Minted Pigmenteer
MarieJNewly Minted Pigmenteer
asked in Questions & Conversations
Formula timed out due to dimension list too long

Bonjour, Je suis face à une difficulté et le message d’erreur ‘Formula timed out’ sur mon P&L; J’ai un metric qui calcule mon Budget P&L à partir de plusieurs sources (Revenue, Coût, HR, etc.) ; j’aimerais créer un autre metric reprenant le P&L avec une dimension en plus (une dimension Fournisseur présente uniquement sur les coûts) ; grâce à laquelle je peux voir mes coûts à la granularité fournisseur directement dans le P&L. J’ai donc modifié la structure du metric (en rajoutant la dimension fournisseurs, et modifié la formule avec des ADD sur les autres metrics alimentant cette dernière) ; néanmoins je retombe systématiquement sur un message formula timed out > 3 minutes. Je suppose que c’est lié à ma liste fournisseur (qui est longue) , mais je ne vois pas comment faire pour optimiser la formule ?

981
CDALMAY
B
BenedikteOccasional Observer
asked in Questions & Conversations
Error during formula computation. Some values overflows 10^14

Hi, I have been getting this error message in my formulas, and need some help to solve this, anyone that have knowledge of this error? Thank you very much in advance! Regards,Benedikte

1544
B
Rasagya
Newly Minted Pigmenteer
RasagyaNewly Minted Pigmenteer
posted in Questions & Conversations
Pigment to Workday integration (sending data to Workday)

Hi all - we currently have an integration set up to bring in data from Workday to Pigment. We are now looking to explore how we can export data from Pigment back into Workday to create a closed-loop integration. Anyone familiar with this set up? Would love to connect to see how we can set this up. Thanks!

2791
Julien
Community Manager
C
Newly Minted Pigmenteer
cayleybNewly Minted Pigmenteer
asked in Questions & Conversations
How do I hide empty rows and columns in google sheets export?

When saving views and using the Pigment Connector to export them to google sheets, I’m unable to retain the “hide empty rows and columns” filtering selection. Is this a feature in Pigment or are there plans to add this feature any time soon? Thanks!

2885
CDALMAY

Most helpful members this week

Badge winners

  • Pigment Like a Pro
    Sam Hhas earned the badge Pigment Like a Pro
  • Innovator
    IrenePhas earned the badge Innovator
  • Pigment Modeling Fundamentals Certified
    imene.mbarekhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Gerahas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    Gerahas earned the badge Pigment Modeling Fundamentals Certified
Show all badges

Popular tags

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings