Explore the Community

Hi, I am trying to find a quick way to get an AVG of 1 out 4 dimensions in the metric and use it for the further calculations. I have data based on cohort, with Cohort Month (on rows) and Cohort Age (on collumns). I would like to take and avg of cohort months and only have Cohort Age Dimension in. I was trying AVGOF formula with exclude modifier but that did not work. Also, BY AVG: CohortMonth, but that keeps the metric in. Any suggestions? 

I found Permission Syntax on community is permissions("{\"openBoard\": true , \"postConversation\":true }")OpenBoard allows us to open the Board and postConversation allows us to comment on Board.But I would like to know, if we would like to allow end user to configure board than what we need to write code in permission function.

Hi Pigment Community,We have daily scheduled imports that are uploaded automatically from an API connection with Xero.I’ve never had an issue with them for many months, but all of a sudden 3 of them had error messages this morning.Any troubleshooting ideas to resolve this? Screenshots of the specific error message below.Thanks,Gab3 out 5 imports failed The error message I’m getting 

Hi, I have two transaction lists:TBL_employees - a transaction list that includes information relating to each employee at the end of each monthTBL_accounting - a transaction list that includes all the journal entries from our accounting softwareIn the TBL_accounting we have a dimension called EMPLOYEE_ID, this dimension contains the ID of an employee for all journal entries that relate to a specific employee (ex. salaries), and a dimension MONTH that contains the month of the journal entry.In the TBL_employees we have the same two dimensions - EMPLOYEE_id and MONTH as well as a dimension called EMPLOYEE_category which specifies if the employee is a manager or an individual contributor.What I want to do is add the dimension EMPLOYEE_category into TBL_accounting using the EMPLOYEE_id and MONTH dimensions as filters but I can’t find a formula that works.The challenge is that the EMPLOYEE_category can vary for the same EMPLOYEE_id depending on the month (ex. an employee being promoted), s

If you create 3 Models, what is the easiest way to check which Dimensions, Metrics from one Model are used in another?Case: a copy has been made of a working Model and updated. Too many updates have been made and we want to make the copied Model the new Model, but we need to check which Blocks to reconnect. What is the best way to do that? Dependency Diagram in combination with Settings > Libraries? Or is there a quicker way?

 In case you missed it - we’ve announced that Pigment has raised $88M in Series C funding! The round was led by ICONIQ Growth, who’ve also invested in other iconic brands like Zoom, Airbnb, Gitlab, Snowflake and more. This new funding will enable us to keep investing in product innovation - such as AI, automation and more functionality to serve the increasing number of applications Pigment can serve. We will also scale our support and experience teams to keep serving our global community.  Thank you for your support and trust. We are proud and grateful for this community’s support. Looking forward to sharing many more milestones together ❤️ Best wishes, the Pigment team 

    The purpose of this article is to explain how you can export CSV data from Pigment and transform it into Excel so that the data is separated into columns.When you export data from Pigment, data is separated by semicolon. If you are planning to use the data in Excel, this is not very useful as all of your data grouped in a small number of columns. As a result we need to perform transformation on the extract before we can use the data.Steps to transform the data in ExcelTo transform the data in Excel, you should follow the steps below: Download CSV on Pigment   Open a new Excel workbook    Select “Get Data” -> “From File” -> “From Text/CSV”  Select the exported file (the one that was downloaded from Pigment)   Change the delimiter to semicolon if not selected automatically. Press Load Your data should now be loaded in a format that can be used for Excel analysis    

HelloI am trying to pull data on one dashboard from another , where I am trying to sum up 2 specific accounts. This is the formula I am using : 'Data - Monthly - Final'[filter: 'CoA & Function'.CoA = CoA."30012" AND 'CoA & Function'.CoA = CoA."30011"] What is wrong here? The amount come up blank. When I remove the text post “30012” I get the numbers for 30012. Is AND not something I should use here?

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️⃣ [TRANSPORTATION & LEISURE] Finance Director @Forto, whose platform technologies address the entire process stream, delivering a highly transparent, frictionless, and sustainable digital supply chain.Forto is looking to appoint an exceptional and ambitious Leader for its Global Finance function to join an already highly accomplished team. The company is seeking an entrepreneurial, hands-on financial leader who can operate at pace and will play a key role in the global scale-up journey as they work towards an IPO. This is a fascinating point at which to join an already successful business in a rapidly growing market with a proven model, a strong brand, and IPO ambitions.📍Berlin, DE 2️⃣ [INTERNET PUBLISHING] VP of FP&A @Later, the leading social media marketing and commerce platform that helps small busi

Hi Pigment Support, I’ve integrated Bamboo with our workforce planning app via API Token.However, when I try to import a report get the error “Report does not exist”.I know the report exists in Bamboo, and I have double checked the report ID which is definitely right.We have also integrated Bamboo with other services we use without issue.Any hints on how to fix this?Thanks!Naomi

 Month is supposed to be a list demension but if i write t the formula it came like a function.Thats why the formula is false 

Hello, Is there a possibility to have the Hint feature enabled by default or a conditional format that highlights cells where end users can manually make changes? Thanks in advance,Best,Anas

Hi Community,we just started to push Salesforce Data into Pigment.Currently we face the issue, that our Salesforce amounts  (Type currency) cannot be imported into Pigment as number, due to the currency symbols.Is there any workaround instead of converting all Salesforce amount currency fields into number fields? (we have a lot)Thanks,Daniel

Hi,I have two applications. Hub (All Dimensions and Security Role.) Budgeting (All Calculations)I want to know how I can define security in budgeting application by using of Hub application role dimension.

Hi Team,Can anyone help me to define security for a Boolean.In my use case there is a requirement that user can select only one scenario (3 scenarios created in a dimension) for each country and product family. Thanks in advance  

Hi here,The possibility to Push Data from Gsheet to Pigment is very useful, thanks.However, when pushing the informations, it seems that the line are being added to the previous lines and not replacing them.For example, if someone is reviewing his budget in Gsheet and we want to push the information in Pigment, new figures will be added the previous pushed figures.Is there a way to “update” the Named_Range and not adding it? Thanks

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 +  Upcoming FP&A EventsExecutive positions1️⃣ [TECHNOLOGY, INFORMATION & INTERNET] Head of Financial Reporting @THG, a fast-moving, global technology business that specializes in taking brands direct to consumers.You will be reporting to the Group Financial Reporting Director and support across our financial reporting and Group finance function. You will have a strong financial reporting skill base, able to support across UK and global compliance, lead the THG PLC Group audit along with supporting on one-off projects as they arise. Sitting at a Group level, you will see all divisions of the business and work closely with our commercial teams, tax, treasury, and investor relations, you will therefore be someone who is personable and keen to build strong relationships and networks across the business. You will have strong pro

Hello!Can someone please help me to upgrade the following formula?I would like to add following statement: “If there’s [N/A] in the job name, (blank) result in the ‘Model FCST Month Dimension’ property.IF(ISBLANK('[FCST] Greenhouse List'.'Start Date (Offer) Dimension'),IF(ISBLANK('[FCST] Greenhouse List'.'Manual Input'),'[FCST] Greenhouse List'.'Forecast Start Date Dimension','[FCST] Greenhouse List'.'Manual Input'),'[FCST] Greenhouse List'.'Start Date (Offer) Dimension')Thanks in advance!!   

Hi, I am looking for a way of using the filter function with two conditions. Example: Looking for a sum of specific accounts and cost centers. lets say for accounts: 400,401 and 406 and from cost centers 21;1000;1150;1321;1400;2321;2400.I am already using the filter to look for the sum of the accounts, but found out that I need it on specific cost centers as well Any ideas how to solve this? :) - Benedikte

Welcome to our May Customer Connect, where we bring Pigment customers together to share knowledge and best practices around a particular topic!  “If a cell was updated in the forest with nobody there to see, did it really happen?“ - FP&A Analyst, probably 🤷‍♂️ It’s been a few months since our last Customer Connect, but we’re back at it again – this time focusing on Collaboration! Customer Connect will take place on Thursday 25th of May at 15:00 (CEST). This month is all about collaboration: a key priority for you, and therefore for us. This is why we'll soon be launching exciting new features, so tune in for a sneak peek! 👀 Not only will you be hearing from fellow customers, we’ll also have Pigment’s product experts on the call. In the session we’ll be sharing and discussing all things comments, access rights, automations and more. Ultimately, you'll leave this month's Customer Connect with actionable insights on promoting collaboration in a controlled way within your workspace. 

Hi everybody. I’ve come across a task to post one metric to a dashboard in the form of several graphs each of which will show the only element of a dimension. Let’s say we have different networks: 2g, 3g, 4g in a single metric. I need three graphs to show traffic per network type: The first one should be 2g traffic, another one - 3g, the last one - 4g.They should not be synchronized by this dimension (‘Technology’ dimension on the graph). How to properly do it? Thank you.

Hello, What is best way to setup the metric formula to summarize the # of headcount by following three?by Division (using Division property) by monthly (using Effective date property. This is basically monthly HC Data exported date.) by Worker type. (using Worker Type property)  Thanks in advance! 

HiCan we provide Write access to Boolean data type?if yes, please let me know how.

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📅 Upcoming FP&A eventsExecutive positions1️⃣ [FINANCIAL SERVICES] Head of FP&A @Dojo, which empowers businesses by creating the tools and technology that turn transactions into meaningful relationships.You’ll join our newly established Strategic Finance/FP&A team which is a high-performing, specialized group working directly with the Exec team and Founders. As we enter into our next phase of rapid growth and prepare for imminent international and product expansion, it is more crucial than ever for us to ensure we scale in a commercially sustainable way. As the Head of FP&A, you will report to the Director of Strategic Finance with a high level of autonomy and responsibility, and exposure to our executive and senior leadership teams and influencing decisions. This is a 16-month FTC covering maternity leave, and as we

I’m having issues properly showing the growth and variance of negative items.As an example, if actual EBITDA was -0.25 and budget was -1.0, I can get the difference to display correctly, but my only options for % variance are-75% (-.25- -1.0)/-1 or  +300% (-1- -.25)/-.25Neither of those are correct.  It should be +75%.  I can use “Reverse Signs” but that doesnt apply to conditional formatting.  Has anyone figured out a better way to show this in a table?