Explore the Community

Hello,I have a metric where the data type is the month dimension and am struggling to figure out how to convert it to a Boolean metric with month as a dimension of that.The first metric is an assumed/forecasted launch date for each customer (ignoring that these are old customers and therefore in historical periods). With the second metric I am trying to convert that assumed launch date to a Boolean where any month is “TRUE” that is greater than the assumed launch date in the first metric. For example, the first line here would correspond with an assumed launch date of Aug-23, the second line with an assumed launch date of Jun-23 and so on (also ignoring that these are historical periods). I’ve been spinning my wheels on this for a bit and don’t see any articles on data transformation from metrics with a data type being the month dimension. But essentially I am trying to transform these into a Boolean metric with the month dimension (rather than it as a data type) so that the forecasted

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   [HOSPITALS & HEALTH CARE] Head of FP&A,📍Remote, US Brave Health is a virtual behavioral health company offering online therapy and psychiatry services to the Medicaid population in 15 states across the U.S.  [CONSUMER SERVICES] Head of FP&A ,📍Paris, FR Ornikar is a comprehensive digital platform to ease young people’s access to mobility.  [SOFTWARE] VP of Strategic Finance,📍Oslo, NO Ardoq is a dynamic, data-driven tool for Enterprise Architecture and a key tool for your digital transformation journey.  Hiring? Submit a job! Other Positions  [CONSUMER SERVICES] Finance Manager,📍England, UK / Tallin, EE Starship Technologies builds self-driving local delivery robots that are safe, reliable, clean, and cost-efficient.  [FINANCIAL SERV

I am trying to create multi year P&L views, with months in the columns.  After the last month of the year, I want to show the annual total, YoY $ value, and YoY % change. (Months->Annual Total->YoY $ change->YoY % change).  The challenges I’m encountering are as follows - example with numbered notes shown in snippet below:Inability to choose position of aggregators.  Pros of using aggregators vs calculated items are that gross margin % calcs roll up correctly, and the values are retained when I collapse the months and only want to show the annual total.    Gross margin % calculated items roll up incorrectly.  It displays the sum of the months’ percentages, rather than the annual gross profit value divided by the annual revenue value.  Pro of calculated item is ability to choose column positioning.  Is there any way to hide a value in a calculated item?  The YoY % calculation displays a nonsensical value when calculating against % margin values.  Only workaround I’ve curren

Hello,I don’t see the format Org chart icon (see first screenshot)Maybe i am missing a metric or something else. Here the current structure of my table:Employee is on the left side.Thanks for your help,

We’re coming to you with a new badge and rank system 🏆 Why the overhaul? We want to award different kinds of participation in the Community and our previous system wasn’t designed for that. Also, the new badges just look better don’t they… In the end it’s about recognizing the contributions of our most active members – we’re so grateful for the amazing community we’ve built together. Our new badge system consists of 9 different badges, which have different levels you can achieve.*Author – Posts (question, conversation, article) 📝 Helper – Answers 🎓 Chatterbox – Replies 💬 Star – Likes Received ⭐ Connoisseur – Likes Given 📚 Innovator – Submit a Product Idea 💡 Builder – Idea Delivered into Product 🛠️ Socialite – Attend Pigment Events (online or offline) 🫂 Pigment-versary – Pigment Community Anniversary 🎂*On top of these badges, we also have specific badges relating to Partners and the Academy. We’ll begin rolling out the new badges this week and expect to be done by the end of th

Hello. I have created a table with multiple metrics. The calculations work currently, except the percentages are aggregating or calcing oddly when I display the table. When we’re looking at data at NOT the lowest level, the % is incorrect.In the screenshot below, I basically want the Account Churn % to display Churned Accounts / Active Accounts BOP. So 1%, 4%, 5% etc. I looked into Calculated Items, but doesn’t seem like that would work in this case. Am not looking to alter the metric itself, but rather to add a row for display purposes only.Thanks. 

Hello,Does Pigment Academy has pre-built applications which can be downloaded and use for practice purpose?Thanks,Vamsi

Hello,I am trying to get current month vs 4 years before same month variance. Can you please help?I tried using the offset calculation to offset by 48 months ago, but it is giving me 4 years ago value rather than the difference.  So, Aug 23 is 10.9 and Aug 19 is 9.5. So I need to get the result of 1.4 in a new column.  Thanks in advance!      

Is it possible with the Quickbooks integration to only load specific accounts from the Income Statement? For instance, I only want to import revenue accounts into a block. Is that possible? 

Hello,I would like to correct the below formula so I can have the team of each employee by month based on his entry date and exit date with no time limitation.The way the formula is currently it does not take into account the  fact that I have 2 lines in my transaction list for an internal mobility. It only take into account the latest subteams.Here is an example:‘Dataload HR tool - Employee.’  is my transaction list with all the info by employee.Currently for this employee, i have the following result.But it should be “Finance & Planning” team until jan 24 and from Feb 24 until the end “Product data” The data will be updated each month on the latest version of the ‘Dataload HR tool- employee’. Thanks for your help

How can I download Academy template apps into my company's workspace?

Hello, I did the below formula in order to count the number of FTE. It’s works well except for the internal mobility where it counts 0. One of the employee concerned by this case is the below employee:  What do i need do to in the formula to take into account the internal mobility ?Thanks in advance

Hello, How to create a Dimension and Transaction list?and also How to create properties in the lists. Thanks,Vamsi

We have employee images stored in BambooHR. Is there a process for downloading those images so that we can upload them into Pigment for the org chart feature? I’m not able to download it through the integration. If not directly through the integration, how can I do this?  

How do I get a unique count of months in a metric in a view?For instance, I have Revenue (Dim: Month): Jan23 : 10Feb23 : 15Mar 23 : 20 I’m looking at this metric in a quarterly view, Month > Quarter and I want to annualize this number. So the math would be (10 + 15 + 20) * 12/(3) (3 months in this time frame). I want this to recalc when I view it from a yearly perspective so it would be 12 months. Any ideas on this?  I tried doing Revenue [REMOVE COUNTUNIQUE: Month] but that just found the number of uniques in my Month Dim List and multiplied by that.

 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  [STAFFING & RECRUITING] Head of FP&A 📍 San Francisco, US Addison Group offers a full suite of consulting, recruiting, and executive search capabilities across multiple sectors, including IT, finance and accounting, non-clinical healthcare, human resources, administrative, and digital marketing.  [MARKETING SERVICES] Head of Financial Controlling 📍 Paris, FR Biggie is a communications consulting group, born from the merger of the media agency Repeat, the trading desk Gamned, the video creation studio Kazam, and the influence strategy agency Beastly.  [SOFTWARE DEVELOPMENT] FP&A Director 📍 Remote, FR Cint is a software company that specializes in providing solutions for market research and data collection. The company offers a range of software products an

Hi,Could you please tell me what Formula timed out does mean and how it can be sorted?Thank you!

Hello,I would like to create a metric that count the number of deals per month depending on the dimension below. In order to do so we should use “ ID prm client and “date of first contract signature” from the below dimension.How can i do that ?Thanks for your help.

Dear Community, I have a transaction List and have a Property which Type is Dimension (Month) Text.I’m looking to create a metric that tells me the latest month on that property. How can I achieve that? Thanks in advance :D

Dear community, This is a quick one. I have a Boolean metric with one dimension (Employee). The metric shows a list of employees with the tick box marked.I am struggling to generate a KPI that show me the number of employees in the list. What’s the best way to approach this outcome?Many thanks in advance :D Metric: if(Transaction List. Bolean property'[by firstnonblank: Same Transaction List.Employee Name],true) I obtain a list like 

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  FP&A Director [IT SERVICES & CONSULTING] 📍 San Francisco, US Visa is a world leader in digital payments, facilitating payment transactions between consumers, merchants, financial institutions, and government entities across more than 200 countries and territories each year.   Head of Strategic Finance [EDUCATION] 📍 Vienna, AT GoStudent is one of the world’s leading tutoring providers and, with a €3bn valuation, Europe’s highest-valued EdTech company.   Head of Corporate & Strategic FP&A  [ENERGY] 📍 The Hague, NL Yinson Holdings Berhad is a global energy infrastructure and technology company, listed on the Main Market of Bursa Malaysia Securities Berhad.   Hiring? Submit a job! Other Positions  Strategic Finance Analyst [SOFTWARE]  📍 London, U

I tried to calculate the average MRR invoiced per cohort but it’s not working.i tried to drill down but dit not find the solution.For example: MRR by cohort for Cohort 14 in jan 23 is equal to 4315€ and '# MRR invoiced by client is equal to 6.The calculation should do 4315 divided 6, but it’s not.Can you help me ?Thanks  

I want to create a Metric for Customer Count. We have ACV $ and Churn $s, do you know you and/or someone on the Support team can help / work together to make sure I am doing it right? Can we jump on a quick 30min call? TY

Hello!I am trying to build an org chart for my company. Most part is good to go, but I noticed that the “Position <> Manager” metric for Reporting seems to confuse the overall structure at the end. When looking at below snapshot, I clicked the ‘Strategic Finance’ team and employee A” is our CFO. My goal is to show “B” and “C” employees underneath “A” employee only because this flow is for the “Strategic Finance” department, However, it’s showing +6 who are NOT part of “Strategic Finance” department. Is there any way to fix this? Thanks!!   

Hello,I have used the LQ calculated item to create a table but the amount displayed in April 2023 LQ is the amount of jan 23 actual.  Can you help me ? Thanks