- - Search the Knowledge Base
Academy
Product Roadmap
Events

Community
Explore the Community
Questions & Conversations

Questions & Conversations

Got a question about your models? Want to start a discussion? It's here!

103 Topics
266 Replies

When you subscribe we will email you when there is a new topic in this category

103 Topics

Recently active

Most replies Most views Newest first

JoseEnthusiastic 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

1 day ago

AlexandreNew Pigmenteer

asked in Questions & Conversations

Try to do the equivalent of vlookup

Hello,I want to use a vlookup on a non-dimension column. Is it possible ?Exemple : Dimension A : I have those 2 columns : I want to retrieve the Manager via the e-mailDimension B : I have my e-mails and my managers. Question : How can I get my managers in Dimension A ?Thank you :)

1 day ago

CamilleBJust Arrived

posted in Questions & Conversations

Best practice for tracking recruitment goals

Hello,I would like to know if you have a best practice to share regarding the recruitment plan.At first we have a line for a recruitment to be done. Once the recruitment is completed, we have the name of a future employee. How do you keep track of that and follow this in the most automated way ? (to avoid duplicates on the actuals and forecast)Thank you :)

3 days ago

LuigiNew 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!

7 days ago

Chelsea

posted in Questions & Conversations

Congrats to our newly-certified Pigmenters!

Join me in congratulating @Keiran, @markdeprez, @Jake, @CamilleMomo, and @Tess.Hunt on becoming our newest additions to the Modeling Fundamentals Certified club! 🥳🥳🥳 Interested in earning that badge for yourself? Check out the certification quiz on Pigment Academy for all the details.

8 days ago

JoseEnthusiastic 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

9 days ago

JoseEnthusiastic 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

9 days ago

abhilashsawlaNew Pigmenteer

asked in Questions & Conversations

How create current date matric, which fetch current date automatically?

I want same feature like Today() in Excel.

9 days ago

JoshNew Pigmenteer

posted in Questions & Conversations

Show aggregate values in Chart Views

I would like to be able to show Aggregate (aka SUM or AVERAGE) values in charts on Tables or Metrics. When creating an aggregate field in Pigment on the Grid View, you can see Totals or when using Show Value As you can see items like Revenue per customer (Revenue and # of Customers are two separate metrics). However, when moving to Chart View the aggregate values are not visible in the Chart View

11 days ago

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

11 days ago

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

11 days ago

James WakefieldNew 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.

11 days ago

rashiberliaNew Pigmenteer

asked in Questions & Conversations

Secondary Axis

How can I add a secondary axis to my chart?

15 days ago

JoshNew Pigmenteer

asked in Questions & Conversations

As of Date for KPI

How do you create/show a date as a KPI. I want to show the last day of actuals for a data set and bring that into a board as a KPI. Is that possible?

15 days ago

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

15 days ago

ErwanNew Pigmenteer

asked in Questions & Conversations

HR statistics - employee average age calculation

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

16 days ago

Ronit_SNew Pigmenteer

asked in Questions & Conversations

Changing calendar settings

Hi,I’ve bullied an app and set up the calendar and set the start month to January. Now that everything is set up we want to change the start month to February . Is it possible?Thanks

18 days ago

MKohliNew Pigmenteer

asked in Questions & Conversations

Blank Dimension Appearing in Grid View Non-existent in Data

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

21 days ago

LoliNew Pigmenteer

asked in Questions & Conversations

New items uploaded - Detail

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?

21 days ago

JoshNew Pigmenteer

asked in Questions & Conversations

Best way to convert Annual assumption to Monthly metric

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]

23 days ago

Alix NoyonEnthusiastic Pigmenteer

asked in Questions & Conversations

Modelisation

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

24 days ago

Sergio B.New Pigmenteer

asked in Questions & Conversations

Having issues drilling down into transasctions

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.

24 days ago

francoisEmployee

posted in Questions & Conversations

How to make your formulas easier to understand

When modeling in Pigment, it's easy to be focused on your output and not thinking about others trying to read your formula. This guide will give you a few tips on how you can make your formulas easier for others to understand. Table of ContentsTip 1 - Use line breaks and tabulations Tip 2 - End your parenthesis at the beginning of the line Tip 3 - Factor your multiplications, additions and modifiers Keeping a good formula hygiene Even though Pigment uses all kinds of functionality to make your formulas more understandable, like having the opportunity to name your dimensions and metrics with user friendly names, but if you like to use Pigment at its full potential you'll get complex formulas quite soon. Chaining modifiers, crossing different sources, and adding conditions will all make your formula more difficult to read.Here are a few tricks to make it easier for you to read your own formulas, for your colleagues, and for us Pigment teams to help you build meaningful calculations fo

25 days ago

MurielPJust Arrived

asked in Questions & Conversations

How to create a formula with iterations / sequences

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:

25 days ago

Alix NoyonEnthusiastic Pigmenteer

asked in Questions & Conversations

Filter with text data

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!

25 days ago

Page 1 / 5

Badge winners

avancisinhas earned the badge Pigment Modeling Fundamentals Certified
Sofia Costahas earned the badge Thought Leader 1
Habib Bhirihas earned the badge Pigment Modeling Fundamentals Certified
Sébastien Tramolayhas earned the badge Pigment Modeling Fundamentals Certified
ClareHutton_QueBIThas earned the badge Pigment Modeling Fundamentals Certified

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Single Sign-On Need help?

Log into the Pigment Community

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.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.