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
Is there a way to apply conditional formatting to a column/row with the option of removing the formatting on specific cells within that column/row?In the attached example, I would like the bottom row to not be subject to the conditional formatting.
Are any Key shortcuts in Development?A shortcut from Editing to User mode in Board would be helpful, and one for aligning Widget might be great.
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 weekHighlights [SOFTWARE] FP&A Analyst 📍München, DE Commercetools is the leading composable commerce platform, allowing companies to dynamically tailor and scale shopping experiences across markets. [MANUFACTURING] Head of FP&A 📍Dublin, IE Zoetis is a global animal health company that develops, manufactures, and markets veterinary medicines and vaccines for livestock and companion animals. [SOFTWARE] FP&A Director 📍Remote, US Gong is a revenue intelligence platform that leverages artificial intelligence to analyze sales interactions, providing insights to help improve sales effectiveness and drive revenue growth for businesses. [HOSPITALITY] Head of Strategic Finance 📍Luton, UK TUI is one of the largest leisure, travel, and tourism companies globally, offering
Hello,I am working on a business case where I need to take the data and create some sophisticated business items. I want to see the forecast at different levels by who is inputting it and how to confirm the forecast is done. Here are some of the things that need to come out of the data that is provided.Alignment between top-down and bottom-up revenue targets. Consistent driver-based approach to cost planning, particularly around travel costs. Showing if forecast has been entered and how to change/override that number.Any help would be great.
The purpose of this article is to provide guidance on the data files/formats that are to be used to import into Pigment. Included in the article is an Excel guide that includes an example structure of common use cases. Before preparing your file to be imported, its important to note that all excel files must be converted into a .CSV before they can be imported into Pigment. Check out this support article from Microsoft on how to save as .CSVTips for Data imports into Pigment 👩🏻🏫 Separate Dimension IDs from Dimension Names ⛓ Where you have a dimension with IDs in your source system you should include:- the IDs in a column,- the Name of the dimension in a second column.This will allow you to follow best practice to load your data with IDs, but, also have a display name based on the Name. If you don't have Ids, we can load using the 'Name', however, this can cause issues down the line if dimensions start to change names (E.g. Account 51000 - Revenue becomes Account 51000 - Revenue
Hello,In my transactions list, I have a field called “Chain Simulate” which merges the dimensions “Ship Mode”, “Ship Mode Simulate” and “POL (code)” and returns as text property. Is there any way to merge the three dimensions and return in dimension property? The combinations are already created as a dimension in the background. My purpose is to : Based on the combination in the column “Chain Simulate”, it should return a number in the Lead Time column. Besides, the Lead time per combination is added within a dimension & also created a mapping Metric. Issues : I am able to merge & return the value only as a “Text” property so this text property cant perform a lookup to the below dimension or mapping. Kindly let me the know also best way to retrieve the Lead time based on the combination. Dimenison : Mapping Metric : ( This is pulling the data from above chain dimension) Let me know if its clear or not.
Hello,We import our sick leave period data into a transaction list in Pigment:Each employee could have several records of different periods.But it's possible to have overlap periods for one person, for exemple: Emp_2 has an overlap period from 03/04/2023 - 03/08/2023. So for this case, I have two needs:1. Create a metric to affiche those employees who have overlap period2. Even it's error and we warn it, we still want to calculate these sick leave period from the earliest start date to the lastest end date. PS: I’m not sure if it’s helpful to create unique ID for all records in the transaction list. We can do it if need. Thanks you in advance for any advice!!
Hello Pigment Community. I am trying to calculate the commission that we have to pay to our partners and it is based on the first year of MRR that each new client signed through a lead from our partners has generated. That means, that if we sign a new client in 2022, on 2024 we will pay a commission for that client based on the MRR that it generated through its first year, in this case 2022 and not the MRR that it is generating now in 2024. At the moment I have this formula; This is showing me only the first 12 month of MRR for each client as you can see in the following screenshot: The problem with this method is that if we have a client that starts in a different month than January for example November, we want that the MRR for December and November for that client next year to be the same as it was on the previous year. Therefore I am looking for a formula that allows me to Move only the first 12 months of MRR to the next years. Than you in advance :)Gabriel.
Hello Pigment!I am having an issue with a formula.I have a dimension called 'MRR-D Invoice '. I want to create the column “latest_suscription_duration” which takes the same value as“subscription_duration” according to the max end date, and that, for each customer. This is similar to a group by function in sql. Anyone knows how to do that ? I tried this but it gave me weird results because I didn’t group by customer reference :'MRR-D Invoice .'Subscription_duration'[BY max 'MRR-D Invoice '.'End_date' ] PS : End_date is a dimension, Subscription_duration is an integerCustomer_reference End_date Subscription_duration Latest _subsciption_duration Customer A 24-Jan 3 3 Customer A 21-Jan 12 3 Customer A 23-Jan 4 3 Customer B 24-Feb 12 12 Customer B 23-Feb 12 12
Hi,I’m trying to calculate a moving average where blanks are counted as zero’s. When trying to leverage the “is defined” formula I get a calculation time-out error. Please advise.
Hello Everyone, I am working on a headcount report where in I have Actuals and Budget along with the variance. Now I want to reference scenarios in the formulas somehow to create a metric to use this logic: If Actuals is blank and Budget is there, it means that that seat is not filled yet. Is there anyway to do it?
Hello,I need to create a form for end users to assign a cross-dimension (direction and activity) to 2 new dimensions (Analytical Dim level 1 and Analytical Dim level 2). To do this, I was thinking of:Creating a table with the direction/activity cross and the associated data. Creating 2 metrics with the direction and activity dimensions A. to select: Analytical Dim level 1 B. to select: Analytical Dim level 2However, I would like the selection of "Analytical Dim level 1" to only display the child items of Analytical Dim level 2. Is it possible to do this and if so, how?Thank you in advance for your help.
Could someone please help let me know if I could have my calculation shown in points vs bps? Thank you
I am building an attrition model based on month dimension and a dimension called ‘30 Day Cohort’. I am almost certain that I will run into a circular reference if I do not use the Previous function. However, because I am working with 2 dimensions I am unclear on how to reference the previous month and previous ‘30 Day Cohort’ dimension simultaneously. Is this possible? Can I combine multiple Previous functions? Is it possible to nest two Previous functions? To start my model, I have “initialized” the metric with both the starting values in the first month and the forecasted new subscribers in the first ‘30 Day Cohort’ (0 in my case): What I would like to do is calculate a formula on the value in the previous month and previous cohort and then do so recursively (this is why I think I need to use the Previous function). So for Oct 23 and cohort 1, I would want to do my calculation based on the Sep 23 and cohort 0 value (1,895); for Oct 23 and cohort 2, I would want to do my calcula
I have configured an Automation that triggers in my scenario “Forecast”. The automation contains a conditional recipient, but the issue is that the recipient is defined by my metrics value in scenario “Baseline” instead of the value in scenario “Forecast”. Is this the way it is supposed to work or is there any way around it?
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.