Skip to main content

Questions & Conversations

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

  • 757 Topics
  • 2,071 Replies
757 Topics
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 

7161
Benoit
Community Manager
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.

2851
Benoit
Community Manager
R
Newly Minted Pigmenteer
rashiberliaNewly Minted Pigmenteer
asked in Questions & Conversations
Secondary Axis

How can I add a secondary axis to my chart?

3523
Keiran
Community Manager
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)? 

5622
Dmitrii
Seasoned Pigmenteer
E
Newly Minted Pigmenteer
ErwanNewly Minted 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

2632
E
Newly Minted Pigmenteer
MKohli
Seasoned Pigmenteer
MKohliSeasoned 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  

3153
MKohli
Seasoned Pigmenteer
L
Newly Minted Pigmenteer
LoliNewly Minted 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?

1175
L
Newly Minted Pigmenteer
J
Budding Pigmenteer
JoshBudding 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]

1291
Nathan
Employee
A
Seasoned Pigmenteer
Alix NoyonSeasoned 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

2462
A
Seasoned Pigmenteer
S
Newly Minted Pigmenteer
Sergio B.Newly Minted 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. 

752
S
Newly Minted Pigmenteer
M
Just Arrived
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:  

1911
Nathan
Employee
A
Seasoned Pigmenteer
Alix NoyonSeasoned 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!

5556
A
Seasoned Pigmenteer
Keiran
Community Manager
KeiranCommunity Manager
posted in Questions & Conversations
Aggregating a Dimension Flag by Quarter

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 dimension Then I aggregated the values in a Metric dimensioned by Quarter instead of Month I was then able to create a similar metric to before, but this time, if any month in the quarter contained ‘Ramping’ the whole month, would display as ‘Ramping’ 

780
Keiran
Community Manager
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Filtering to get only the dimensions shared in two transaction lists?

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

61010
Ben A
Employee
A
Anonymous
published in Questions & Conversations
3 Tips when asking a question (to get the best answer)

Hello Community members! Asking a modeling question to the Community? Here are 3 tips to help you get the best possible answers from your peers. Give context around what you are trying to achieve and the different solutions you’ve come up with so far. This will help us understand your thought process and how you’ve come there, but most importantly help us write an explanation that makes sense in your case.   When describing the blocks used in your example, make sure to identify each block’s type (Dimension, Transaction list, Metric, or Table). Additionally, make sure your block names are understandable by everyone (if they use a special naming convention in your application - please explain what they are).   Explain the data type and dimensions of the blocks you list. This helps people understand the types of data you are working with. If you’re using a transaction list, explain the property types. For example: TX_Actuals: transaction list, properties: order (data type= Order) Amount

2641
A
M
Just Arrived
Megan RichardsJust Arrived
asked in Questions & Conversations
Best practices for comparing to external benchmarks

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?

851
Nathan
Employee
C
Seasoned Pigmenteer
Chelsea
posted in Questions & Conversations
Introducing Pigment Academy!🍎

It is back-to-school time, no better time to launch our Pigment Academy!  No need to wait outside for the bus because these on-demand learning paths are available 24x7 from the comfort of your home.  Excited to learn more and create a personalized learning path? Access our Full Catalog of Academy offerings and filter it based on one or all of the following settings: AudienceExecutives Business users ModelersCategoryBasics User Experience Reporting Formulas Bringing in Data Calculation EngineContent TypeMicro-lesson On demand Video Certification Activity QuizPersonalize your learning journey based on what you need to learn, when you need to learn it. But that’s not all! Academy and Community are also BFFs – Enter a keyword or two in the Community search and you’ll find resources from both. Plus, throughout Academy, you’ll also find links to relevant and helpful articles on Community. So, what are you waiting for? Enroll in Pigment Academy today!

2200
C
Seasoned Pigmenteer
E
Newly Minted Pigmenteer
EvaKNewly Minted Pigmenteer
asked in Questions & Conversations
A board brings incorrect number

Hi team!I would like some help, as I cannot find out what is going wrong.I have a metric that we add adjustments on top of our initial forecast and along with other metrics they all end up in a table. My problem is that for one specific line the number is not correct, in fact, i drill down to see where this number comes from but the amounts that I see (the correct ones) don’t give the amount shown in the table! So I am trying to understand what else is pulling but not showing so as to fix it! Any idea what could it be?

341
E
Newly Minted Pigmenteer
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Connecting data from two transactions?

Dears, I have a dimension “Self Served” that I get from an extract directly intro a transaction list A, in this transaction list  A I have another dimension “Client ID” that is shared with another transaction list B, and I added another column in transaction list B to get the dimension “Self Served” but I get an error, is there a way to connect both transaction lists with something similar to a vlook up in Excel? I dont want to keep importing or manually adding “Self Served” into the dimension “Client ID” so I can use the function ITEM. I am trying to automate the data so it comes directly from the extracts.  Thank you very much for your insights! BR,Jose

1001
francois
Employee
M
Just Arrived
Megan RichardsJust Arrived
asked in Questions & Conversations
Freeze columns in a metric view

When I add a metric to a board, the rows are automatically ‘frozen’ so that they remain visible when I scroll to the right.Is this an option with columns too? Sometimes there are too many rows and I get lost when the date columns are no longer visible.

4781
Benoit
Community Manager
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Using something similar to Vlookup

Dear Community, I have a transaction list in which I want to add a percentage based on a dimension I have, but I get the sum of the all the percentages in every line. I want to do what would be a simple VLook up in excel from the following dimension: If you have any guidance or any idea how to do that on Pigment it would really help me. My end goal is to have each amount that is on every line multiplied by a percentage based on the dimension name of the offer. Thank you very much in advance!Jose

3753
francois
Employee
A
Seasoned Pigmenteer
Alix NoyonSeasoned Pigmenteer
asked in Questions & Conversations
Modelisation

Hello community 😀Currently I have this metric which gives me Paid costs by country.I want to allocate the “Global” row to other countries knowing that i have an allocation metric of contries according to their weight of sales compared to the total sales.  I was thinking about doing someting like this - but it is not working : Could you help me please ? :) Thanks a lot!

1623
Nathan
Employee
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Using Countof with BY

Dear Community, I have the following metric:BillsMonths.'MRR SS'[BY:BillsMonths.Mail,BillsMonths.Month]   I am trying to create another metric based on the previous metric, with the following formula:COUNTOF('Billsmonth Spread')[BY SUM: 'Data Hub'::BillsMonths.Month] And I get the next error in the playground formulaAnd if I create the metric with the dimension I get the same number for every monthWould you please point me in the right direction? Thank you very much in advance!Jose

36310
J
Seasoned Pigmenteer
A
Seasoned Pigmenteer
Alix NoyonSeasoned Pigmenteer
asked in Questions & Conversations
Adding several metrics

Hello all,  I want to aggregate 7 metrics with the following dimensions: version, month, order_id. One of these has checkout_id dimensions in addition, then i removed it. In addition, 2 metrics (Offer_order_Level and Wallet_order_level) have day in dimension structure instead of month (for a matter of optimization), however, month is a property of day. I do not achieved to aggregate those metrics. Could you help me please? Thanks a lot 😉  

10565
A
Seasoned Pigmenteer
A
Seasoned Pigmenteer
Alix NoyonSeasoned Pigmenteer
asked in Questions & Conversations
Filter data which are not dimension

Hello guys,  I want to filter a metrics according to items which are not dimensions - how is it possible? Indeed the yellow part below is not working as Alma_fees_eur is not a dimensions but is a defined as a number. Thanks a lot!  

3022
A
Seasoned Pigmenteer

Badge winners

Show all badges
Terms & ConditionsCookie settings