Explore the Community

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 Pigmen

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

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

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

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

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.

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!

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 

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:

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 :) )T

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

How can I add a secondary axis to my chart?

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)? 

Hi community,HR team asked us an interesting modelling questionThey want to know the employee average age within the company. As TODAY() function doesn’t exist yet in Pigment, the only option I found so far is to :1/ Create a metric with today’s day that will need to be updated when required2/ Allocate a date of birth to each employee in a transaction list or similarQuestion : How to write the right formula to get an age (like 36 for 36 yo) result per employee per month taking in consideration the employee base changes over the years, and then be able to determine an average ?Thank you for your help,Erwan

Been having an issue where when in Grid view for my most recent month some of my data is falling under a Blank category for 2 dimensions even though none of the underlying data has Blank values. When drilling down to the transaction there are no blanks and the data is correct in the grid view. I’ve cleared my cache and realaunched chrome but still have the issue persist even after reloading the original transaction list.Please see images below  

When I upload info in a table, and the upload is giving me e.g. 2 new items in that table, do I have a detail of those 2 new items anywhere? To know exactly what I have as new.I know when I upload and some items are not being populated for any reason, I can see in the “i” of information button the specific cases, but with the “new items” I don’t see that button with the specific items which are being added.If there exists an option to see, could you please tell me?If not, could we have it?

Hi, I plan for benefits at an annual level using a metric called “Benefits as % of salary” with dimensions year, subsidiary, and version. As an example, for FY22 I have manually entered 5% as my assumption. What is the best way to then convert the annual assumption 5% to a monthly metric? As in I want to show the actual benefits as % of Salary by month and then show 5% going forward when the version switches to forecast. My annual forecast may also change by year, so I cannot use [remove lastnonblank: year]

hello :) I want to apply a filter on a metric, it tells me that it can be converted to dimension and i do not undertand why. This is the initial metric: And i want to apply this filter: [FILTER:'Job Id'.Contrat = Contract.'Included in People Costs']→ in order to compute costs only for contracts that are included in people costs

I’m having issues drilling down by transaction with metrics I’ve created in my P&L. For context, I’ve used the “Break down by” functionality, and then am able to see lower level metrics. From there, I’m not able to further drill down by transaction. 

I would like to adapt in Pigment a simple formula used in excel (Metric 1 in yellow, with details in cell F2) :NB : The grey cell C2 is a manual input initiating the sequence.Issue: as the calculation is like a sequence using each previous value, there would be iterations within the same metric.I’ve tried the below formula to overcome the issue, it works for few months but you can see it’s not scalable:  

Hello! I have a dimension in “Environment prod-2022” which is “id_order” → I put on the right the brand name and the retailer name, which are text type data from a transaction list (TL_RBRA).Then, i created a table “Top Retailers / Brands”, in which i aggregate my date by Id_order dimension, i want to create a view in which i display the brand name next to the id_order and another view in which in display the retailer name next to the id_order. Retailer_name and Brand_name are both properties of Order_Id but are not dimension but text type, then i do not achieve to pit in the pivot brand_name and retailer_name next to the order_id.  At the end, i want the 2 views in a board.How can i do it? Thanks a lot!

I would like to know what has worked well for other users for showing / comparing to external benchmarks.Did you add Benchmark as a scenario and manually input the numbers you want to compare KPI against?Is there something that works better?

I was looking into a ticket with a colleague and found a use case where a customer was using a Metric to track if an employee is ramped or ramping.The configuration is a simple metric, dimensioned by Employee and Month with a datatype of a Dimension (Used to flag whether an employee is ramping or ramped)Dimension Flag MetricDimension Flag Metric ConfigurationThis works perfectly when bucketing sales into either being made during the Ramping/Ramped phase to help with forecasting. However, if you want to account for quarters you end up with values in Ramping and Ramped. To account for this I assigned a value to each dimensi

Dears,I created a new metric in which I subtract two metrics that have the same dimensions. Since the metrics are coming from different transaction lists that share the same dimension (customer email) , one frome Resquests MRR BE and the other from BillsMonths I dont share the same customer email in both metrics, and I want to perform the substraction of only those emails that are in both transactions. I tried using filters with ISDEFINED for the email in each transaction to see if the metric will only give the emails that are shared in both transactions but I couldn’t do the right formula. If would be very helpful if you can point me in the right direction?Thank you very much in advance! Jose