Skip to main content

Explore the Community

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

845 Topics
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

60810
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

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

821
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

951
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.

4601
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

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

1583
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

35710
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 😉  

10135
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
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Using IF formula in a Metric

Dear Community, I have the following formula in a metric coming from two other metrics 'MRR BE + Ajouts manuels and MRR Facturé (= Comptable) The result of the metric is neither of the two metrics coming from the IF formula,Would you point in the right direction? or help me figure out what is wrong with the formula? Thank you very much in advance!Jose

1962
francois
Employee
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
How to build Role Dimension List in security, if I lost the access of List?

In my application, Role Dimension list is deleted and i am not able to configure and add list items there. Please help me to resolve that issue. 

783
Keiran
Community Manager
D
Seasoned Pigmenteer
DastanSeasoned Pigmenteer
asked in Questions & Conversations
BY LASTNONBLANK

Hi, I am trying to use BY LASTNONBLANK function to capture the last non blank value in “A” metric (with dimension Month), and get this value in “B” metric (no dimensions there), so that in B metric I will have only the value from most recent Month.I used the following formula in metric B:“Metric A” [BY LASTNONBLANK: Month]The result I am receiving is the sum of all months (the same result I would receive if left “Metric A” in formula without any modifiers).Do you know how I can retrieve the last nonblank value from the Metric?

11782
D
Seasoned Pigmenteer
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Aggregating by sum for Months

Dears,I would like to create a metric where I have the MRR BE, coming from the transaction list Requests MRR BE, summed by the QuickbooksId and by the Month, both of which are mapped as a dimension in my transaction list.I have the following formula: 'Requests MRR BE'.'MRR BE'[BY:'Requests MRR BE'.QuickbooksId,'Requests MRR BE'.Month] It works for QuickbooksId (ID number) , but it does not sum by Month. It ends up giving me the total per QuickbooksId (ID number) for every month of every year instead of allocating the sum of the ID per month of the year. Thank you very much in advance! Best,Jose 

1924
francois
Employee
S
SusmitaOccasional Observer
asked in Questions & Conversations
How to estimate the size of an Application?

How we can define the storage capacity and workspace memory in Pigment?

3631
Nathan
Employee
C
Budding Pigmenteer
Carolina LeeBudding Pigmenteer
asked in Questions & Conversations
Access Rights per Cost Center

Our budget construction is based on input of cost center managers, so they can add headcount and expenses as they wish.How can I give them access only to their own cost centers? With that, they would only be able to see data about this specific cost center.I’m tring something like that below but I don’t know how to link the user’s scope with the Cost center manager’s role.   

1614
Chris
Employee
A
Seasoned Pigmenteer
Alix NoyonSeasoned Pigmenteer
asked in Questions & Conversations
Metric with allocation

Hello community 😊I need to realocate offer amount in proportion of GMS order weight on checkout GMS total weight (i.e. 1 checkout contains X orders). Below you have for example Order 1303589 representing 44% of checkout 351970. Then, i need to relocate 44% of my amount offer to this order. I take the amount offer in a transaction list “LT_Offer”:See below the “TL_Offer”. I want a metric which returns in column the checkout ID, the order ID and reallocated offer amount (which is the offer amount * allocation_order_on_checkout metric)Condition: I only want computing allocated amount offer when the Id_order in TL_Offer is empty (in fact, if there is an id_order, the amount have been already assgined to the order). Here in the same example, i need to reallocate 59€ at 44% to the first order and 56% to the 2nd order.Knowing that I have a mapping between order_id and checkout_id in the order_id dimension: I want this final metric working: Thanks a lot ;) !! 

2792
A
Seasoned Pigmenteer
D
Seasoned Pigmenteer
DastanSeasoned Pigmenteer
asked in Questions & Conversations
Pigment Connector not available in my country

Hi Pigment team, We tried to install Pigment Connector, but it says that we are not able to download it as it is not available in the country we operate. We tried it both from the US and Germany.

923
D
Seasoned Pigmenteer
L
Newly Minted Pigmenteer
LuigiNewly Minted Pigmenteer
asked in Questions & Conversations
Hide empty rows OR columns

Is it possible to hide only empty rows or columns? Currently in the filter I see the “Hide empty rows / cols” option, but what if I just need to hide empty columns? Thanks!  

5695
L
Newly Minted Pigmenteer
F
Newly Minted Pigmenteer
Fabien BigeardNewly Minted Pigmenteer
asked in Questions & Conversations
Metric "By" & Dimension

Hello, I need your help on one metric. Some information :TL_RBRA : Transaction list with all orders.  “Order_id” is the primary key. There is a column “Brand_id”TL_Brand_Type : Transaction list with all Brands. “Brand_id” is the primary key. There is a column “Brand_Type”Gms_eur_without_vat = Gross Merchandise Value In the transaction list “TL_RBRA”, I have two dimensions :“Month” with the colum “ts_checkout_payment_confirmed”  “Country” with the “retailer_country”I want to make this metric : TL_RBRA.gms_eur_without_vat  [by : TL_RBRA.ts_checkout_payment_confirmed.Month , TL_RBRA.retailer_country]I want to add the dimension “Brand Type” in this metric but it is in the transaction list “TL_Brand_Type”.I have a dimension “Brand_id” to make the link between these two transactions list. I don’t want to make a “Vlookup” to add  “Brand Type” in “TL_RBRA” but make it directly in the metric.  Do you have the solution ? Thanks a lot for your help.  

5773
F
Newly Minted Pigmenteer
E
Just Arrived
EstelleJust Arrived
asked in Questions & Conversations
Problem with sign in

Hello, I’ve just registered in Gopigment and enter a password but I can’t sign in.Please could you help?Thanks

712
Benoit
Community Manager
M
Newly Minted Pigmenteer
marcelomessi85Newly Minted Pigmenteer
asked in Questions & Conversations
Filter data with formula

Hi, good afternoon everyone!I have an error and I can't solve it, could you help me with the solution, please?I have the formula: 'Bonus per year (euros)'[BY CONSTANT: Month.Year][FILTER: Month.'Monthof Year'='Month of Year'."December"]I got error return: " Error: Unknown List Property: Month.'Monthof Year' "But when I go to check the Month dimension, I see the list.Can you help me please?Thanks!

7274
M
Newly Minted Pigmenteer
C
Budding Pigmenteer
Carolina LeeBudding Pigmenteer
asked in Questions & Conversations
If Formula with 2 conditions

Hi, I want to create a formula using IF, similar to that: if(Month.'End Date'>'Switchover date','metric XX'), but I have 2 conditions:Month.'End Date'>'Switchover date’, and If it is 2022 it has to get data from metric A and if it is from 2023 onwards it has to get data from metric BHow can I do that?

5443
Ali
Employee

Badge winners

  • Pigment Like a Pro
    Noemihas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    Noemihas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Modeling Fundamentals Certified
    Evgeny.Seledkovhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Evgeny.Seledkovhas earned the badge Pigment Like a Pro
  • Rare Author
    RoryChas earned the badge Rare Author
Show all badges
Terms & ConditionsCookie settings