Skip to main content

Explore the Community

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

806 Topics
Dmitrii
Seasoned Pigmenteer
DmitriiSeasoned Pigmenteer
asked in Questions & Conversations
Easier way to reorder dimensions? Drag and drop maybe?

Hi everybody, It is very time-consuming to reorder dimensions with a hundreds of items. Drag-and-drop would be ideal, but it is not there or I couldn’t find it.I have a workaround of creating a `sort order` field for the dimension, but this look to hacky to me. Any tips on easier reordering?

1013
Dmitrii
Seasoned Pigmenteer
2 years ago
Anastasia
Employee
AnastasiaEmployee
published in Company News
Pigment NPS Survey: How we measure your satisfaction and how we make sure that your feedback helps us improve the product

You have probably heard about NPS, a survey that allows a company to measure its customers’ satisfaction. At Pigment, we care a lot about your feedback & we use the NPS survey to have more insights about your experience with the product & the company.  How do we measure the NPS? At Pigment, we send out your first NPS survey one month after your account creation, and then every 6 months after that. You will receive it via email or directly in Pigment and it will look like this:  You will be invited to provide a score from 1 to 10 and, as a follow-up, you will receive an optional question to give more details about your score. Any constructive feedback is welcome and represents an invaluable source of information to make Pigment even better!This optional survey is of great help to us!! If you prefer to opt out, simply ignore. It will disappear after several reminders. What happens after you give your feedback?Once you’ve shared your feedback, your CSM will be notified and will ha

3130
Anastasia
Employee
2 years ago
A
Newly Minted Pigmenteer
AdelgoNewly Minted Pigmenteer
asked in Questions & Conversations
MoM KPI

Hello,I know it is possible to create a MoM KPI, but if I add it as a KPI in a board, each month I have to change the month concerned.Is it possible to calculate automaticaly the MoM based on the last month selected in the board ? Example (picture below): In my board I selected the first 9 months of the year. For my MoM KPI, I selected september to offset with the month before. So the result is September-August. But if I select the 10 first months of the year, the KPI does not change. I expect to see automatically October-September.ThanksAdèle 

5191
Benoit
Community Manager
2 years ago
A
Anonymous
published in Career Forum
FP&A Jobs #4 - 20th Oct

Executive positions1️⃣ FEATURED 🌟 [B2B SaaS] VP F&A @ Intercom, the Engagement OS, enables businesses to build stronger customer relationships that drive growth and scale.Reporting to CFO Dan Griggs and based in San Francisco, the VP of FP&A will play a key role in supporting Intercom’s continued growth and path to IPO.Bring a strategic mindset combined with sound operational experience and stakeholder partnership to develop and provide insightful, value-added analysis across the company and help drive financial outcomes.📍 San Francisco, US→ If you want to know how strategic is the role to the company, well, contact for the job is Des, Founder and CEO at Intercom (des@intercom.io) 2️⃣ [B2B SaaS] Vice President, Financial Planning & Analysis @ MongoDB, the developer data platform company empowering innovators to create, transform, and disrupt industries by unleashing the power of software and data.Lead a growing and high performing global FP&A team. Create and implemen

2480
A
2 years ago
A
Newly Minted Pigmenteer
AdelgoNewly Minted Pigmenteer
asked in Questions & Conversations
Widget Text Format

Hello,Is it possible to change the format of a text Widget ? → Background color→ Text Size→ Text Color→ Center the text in the boxIf not, when do you plan to develop this feature ? ThanksAdèle

1401
Benoit
Community Manager
2 years ago
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
Unique field missing from data mapping for uploads

Should there be a “Unique” column in the below grid? If so, how do make sure that it appears at the mapping stage?: 

924
P
Budding Pigmenteer
2 years ago
P
Budding Pigmenteer
PatMacBudding Pigmenteer
asked in Questions & Conversations
How to unhide an item

Say I have a dimension list (“Country” for example) included in a grid (within a board) -If I hide an item, how do I unhide it If I hide an item, is there an undo function to take me back to the unhidden view? 

1574
P
Budding Pigmenteer
2 years ago
A
Anonymous
published in Career Forum
FP&A Jobs #3 - Oct 13

Executive positions1️⃣ [FASHION] Director of Financial Planning and Analysis @ Fox Racing, the global leader in motocross, mountain biking gear and apparel.Oversee the annual and multi-year planning process, as well as the effective use of systems and tools required for implementation and reinforcement.📍 Irvine, CA On-site 2️⃣ [MANUFACTURING] Head of Financial Planning & Analysis @ IQE, the leading global supplier of advanced semiconductor wafers.Develop the Group’s FP&A capability including the recruitment of appropriately skilled team members and the implementation of appropriate FP&A tools as part of the Group’s broader IT transformation programme📍 Newport, London, Home Other positions3️⃣ FEATURED 🌟 [FINTECH] Finance Manager @ Moonfare, a digital platform leading a new era of private equity investing.You will be the cornerstone of providing the growing business with top level local reporting, analytics and accounting support. Next to coordinating and supplying data to

1170
A
2 years ago
J
Seasoned Pigmenteer
Justin GrooverSeasoned Pigmenteer
asked in Questions & Conversations
Can I Apply Conditional Formatting to All Columns of a Calculated Item?

I have a budget & forecast vs actuals table as shown below.  Actual, Current Budget, and Current Forecast are Version Type dimensions that are associated with the Version dimension as properties.  The 5 columns within the red box are calculated items.  I applied conditional formatting to the variance calculated items.However, when the month changes, the formatting goes away as shown below: The intent for the above views is to associate the month dimension with an application variable of “Last Closed Actuals Month” - dynamically updating to show stakeholders their monthly and YTD variances.Is there any way to apply the conditional formatting across the entire calculated item?  Or a different approach to BvA views entirely?  The approach shown above contains 6 conditional formatting rules (3 columns x2 rules each), so doing this for every month doesn’t seem viable.  Thanks!  

1962
J
Seasoned Pigmenteer
2 years ago
C
Budding Pigmenteer
CBGongBudding Pigmenteer
asked in Questions & Conversations
Dimension property help

I am trying to get a formula to work showing each persons quota by quota code based on tenure. I have created a Years dimensions that outlines  year 1 = $1 year 2 = $2  ect ect with the quota value being a property in that dimension. I have then created a metric outlining each quota code by month and then plugged in the year dimension to help map how many months of what quota are needed.  All I need is to to get the below to show the number value for that year dimension listed. What is the last piece I am missing to get this to work ?  I keep getting errors. Thank you for your help!! 

1412
C
Budding Pigmenteer
2 years ago
J
Seasoned Pigmenteer
Justin GrooverSeasoned Pigmenteer
asked in Questions & Conversations
How to Avoid Circular References in Rollforwards

I am trying to create something in Pigment similar to the simple excel model shown below.  The key piece I cannot currently achieve is making the Churn amount be calculated as: Beginning ARR * a percentage driver.Same as above with formulas shown.  Formula works as it is cell specificWhen trying to do the equivalent in Pigment, I get a circular error.Dec 21 Ending ARR is hardcoded here for the sake of the exampleFor the sake of the example, I’m assuming Jan is actuals and Feb is forecast.  For reference, my Pigment formulas are as follows:Beginning ARR: 'Ending ARR'[select: Month-1].  I have also gotten the same result with PREVIOUS(Month)+Bookings[select: Month-1]+Churn[select: Month-1] Bookings: no formulas - direct entry Churn: attempted formula was Beginning ARR * Churn_Percent, but resulted in circular error Ending ARR: previous(Month)+Bookings+Churn Churn_Percent: Churn/'Beginning ARR'.  I allowed overrides on this metric to be used as a driver in forecast monthsIs there any work

2845
francois
Employee
2 years ago
J
Newly Minted Pigmenteer
JuliaSpNewly Minted Pigmenteer
asked in Questions & Conversations
IF AND OR function together

HiI need to create a formula that as multiple conditions like in the screenshot.My formule doesn’t work, can you help ?Thanks,

1782
J
Newly Minted Pigmenteer
2 years ago
S
Newly Minted Pigmenteer
SophieNewly Minted Pigmenteer
asked in Questions & Conversations
Can you copy formatting from one metric to another in a table?

Can you copy formatting from one metric to another in a table?

721
Elliot
Employee
2 years ago
M
Newly Minted Pigmenteer
Martin DecremeNewly Minted Pigmenteer
asked in Questions & Conversations
API output format

Hi 👋🏼I’m planning on using your API to ingest Pigment data in our datalake, DB Snowflake. I got a two folded question:What are your current API limit rates? (number of lines returned, number of calls, ...) Do you plan to offer Json or XML as an output format for their API? Right now, only CSV is returned.Thanks, Martin

1802
M
Newly Minted Pigmenteer
2 years ago
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Using Modifiers BY with MINOF

Dears, I am trying to get the first Month we have data of a customer to group it by cohort, and I want to add that date as a property of customer.I was able to get that data using the following formula:'Requests MRR BE'.Date[BY FIRST: 'Requests MRR BE'.'Company or Partner Id' ] The problem is that it only works as long as I have sort the date ascending in the transaction list, and I would like to retrieve that data without having to sort my transaction list. Is there a way I can integrate MINOF in a modifier so that instead of the first value it finds it takes the smallest? Thank you very much in advance, Jose

1522
Ben
Community Manager
2 years ago
A
Anonymous
published in Company News
Have you heard? Pigment has secured $65M additional funding in an extension to our Series B round!

🙌 You’ve probably seen the news today, Pigment has secured $65M additional funding in an extension to our Series B round!We couldn’t be more excited to be backed by leading and experienced investors Meritech and IVP. Previously, they’ve invested in companies like Snowflake, Tableau, Figma, Discord and many more epic brands! This new funding will help us continue to innovate our platform while doubling down on expanding our presence and customer support across all our regions.THANK YOU for helping us get there. As stated by our co-CEO Eléonore, we would not be here without you!Once again, thanks for the partnership and here’s to a bright future together! 

13561
Benoit
Community Manager
2 years ago
C
Seasoned Pigmenteer
Chelsea
posted in Questions & Conversations
What do you want to learn about Pigment?

Pigment Academy is just getting started, and we want to help you be as successful with Pigment as possible!Let us know what you want to learn next on your journey to becoming a Pigment pro.

462
A
2 years ago
L
Newly Minted Pigmenteer
LuigiNewly Minted Pigmenteer
asked in Questions & Conversations
Dimension to text

Hello! Is there a way to convert a Dimension property into Text? I’ve done several times this the other way around using the ITEM function, but can’t find a way to make Dimension → TextThanks!

6581
Ben A
Employee
2 years ago
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
IN not available to use anymore?

Dears, I tried to use the formula IN and it seems to not be available anymoreIN function | Community (gopigment.com) I just want to add a boolean formula in a trasancation to get back true when I have a dimension in another column = “ XXX” Thank you very much in advance BR ,Jose 

3313
J
Seasoned Pigmenteer
2 years ago
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Understanding why pigment sums all the values in a metric ?

Dears, I have the following formula: With the following metrics:  and the following structure :The main di,mension client has mapped a segment as a property and I want to do the calculations by that property (Segment). My two metrics are also in terms of the property; and I want to calculate the the value that I have in MRR BE by Customer for each month divided by the Total Users by each month.If I go to drill down, I have the following information: Le calcule de MRR BE by Customer and Type is correct as well as the Total Users, but the Final calculation it seems to sum everything again instead of just dividing the two calculations.   Thank you very much in advance for your guidance,BRJose

6437
J
Seasoned Pigmenteer
2 years ago
A
Just Arrived
Anne-LaureJust Arrived
asked in Questions & Conversations
Security question

Hello,We have an issue with data modeling and security for one of our boards in our people application.This board concerns new positions belonging to one team, company, department and recruiting manager. All of our metrics are dimensioned by Company x Departement x Teams as when we created the metrics, there was only one manager for each combination. However, the org has changed and there can now be several recruiting managers in one team with no hierarchy relationship. Due to confidentiality reasons a manager cannot see open position details of other managers' even if they belong to the same team.None of our metrics are dimensioned by employee. So how can we add security based on managers without changing all of our metrics and adding the employee dimension (we have done manual inputs on the metrics so it would erase everything)? (We have already logged in a ticket but if someone has an idea in the meantime it would be very helpful :) )Thanks!@ClementineEv 

7131
Benoit
Community Manager
2 years ago
agnar
Seasoned Pigmenteer
agnarSeasoned Pigmenteer
asked in Questions & Conversations
Change formatting of all rows in tables

In a table, the row headings (the pivoted fields that you can view either in Tabular or Tree layout) are by default formatted with dark grey font on a light grey background. But if I want it to make it *pop* I can’t think of other way than to go row-by-row and go through the menu:Is there a better way?

1923
Benoit
Community Manager
2 years ago
James Wakefield
Newly Minted Pigmenteer
James WakefieldNewly Minted Pigmenteer
asked in Questions & Conversations
Max time range

Can Pigment do 100 years at an annual level for a time range?I tried the calendar in settings but it didn't apply.

2161
Benoit
Community Manager
2 years ago
R
Newly Minted Pigmenteer
rashiberliaNewly Minted Pigmenteer
asked in Questions & Conversations
Secondary Axis

How can I add a secondary axis to my chart?

3453
Keiran
Community Manager
2 years ago
C
Budding Pigmenteer
Carolina LeeBudding Pigmenteer
asked in Questions & Conversations
Calendar Format

Hi, I have set up my calendar but it is in USA Format (MM/DD/AAAA). How can I change the format to the brazilian type (DD/MM/AAAA)? 

4622
Dmitrii
Seasoned Pigmenteer
2 years ago

Badge winners

  • Pigment Like a Pro
    Pierre-E Louishas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    Pierre-E Louishas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Jordan C.has earned the badge Pigment Like a Pro
  • Read and Interpret Formulas Certified
    Wafaehas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    luciemaheyhas earned the badge Pigment Modeling Fundamentals Certified
Show all badges
Terms & ConditionsCookie settings