Skip to main content

Questions & Conversations

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

  • 799 Topics
  • 2,163 Replies
799 Topics
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!  

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

6843
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

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

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

5743
Ali
Newly Minted Pigmenteer
Marina
Budding Pigmenteer
MarinaBudding Pigmenteer
asked in Questions & Conversations
Dimension user - for importing data

Is there a way when different modelers upload data in the same transaction list, to have a dimension that maps the user who uploaded the specific lines? To be able to filter & make changes only to data related to 1 user. Or should this be something included in the import files ? 

1343
Marina
Budding Pigmenteer
M
Just Arrived
Mihrasp RustomjeeJust Arrived
posted in Questions & Conversations
Spreadsheet mode

Hi, I remember discussions on spreadsheet mode within Pigment that was going to be released, that a native excel user can get an excel like view within the tool? But I can’t see this in the Product Roadmap?Is this still in the pipeline?Thanks!Mihraspcc @Mohamad Mookhith @Catherine Overo 

2812
J
Budding Pigmenteer
Marina
Budding Pigmenteer
MarinaBudding Pigmenteer
asked in Questions & Conversations
Calendar - year view

Hello team, I would like to update my calendar and instead of FY 22 to show 2022 as we are still in July and having as a header “FY 22” might be misleading for external readers. When I try to update the property closing year, I get the below message. Is there a workaround here? 

2242
Marina
Budding Pigmenteer
E
Newly Minted Pigmenteer
EvaKNewly Minted Pigmenteer
asked in Questions & Conversations
Add a text metric in a table

Hello team,I have created a text metric, which I would like to use as an explanations column next to our variances for actuals vs forecast and forecast vs budget. I tried to add it in the relevant table that I have (which brings all lines of our cashflow statement and all the amounts per month and per version, meaning forecast, budget, and actual). So far anything I tried did not seem to work, as usually it says the following: “Expressions are incompatible and cannot all be converted to Number”. I would really appreciate if you could share any idea on how I could do that 😊  Thanks a lot in advance!

2171
Benoit
Community Manager
S
SusmitaOccasional Observer
asked in Questions & Conversations
synchronize Chart  with Grid/Table in the board

Is is possible to synchronize Chart  with Grid/ Table in the board ?suppose, if I want this Bar chart to show “Previous Year Vs. Current Year Country goal” for country Canada, it will change automatically synchronize when I am clicking on the above grid Country name “ Canada”, instead of selecting country from page selector. 

1591
Benoit
Community Manager
A
Anonymous
published in Questions & Conversations
Interested in a roundtable discussion?

 Hello, Pigmenteers! Many of you have expressed interest getting together to learn from each other and share expertise. This is a poll to find out what topics are of most importance to you as we start to plan our first virtual roundtable discussions. If this is something you’d like to take part in, please take the 2minute survey below. In a couple weeks we will look at your responses and choose our first topics along with potential dates. Thanks in advance and speak soon! 

1933
Natalie
Newly Minted Pigmenteer
D
Seasoned Pigmenteer
DastanSeasoned Pigmenteer
asked in Questions & Conversations
Can we create charts for Tables with different Metrics as Series of the chart?

Can we create charts for Tables with different Metrics as Series of the chart?

1614
D
Seasoned Pigmenteer
C
Budding Pigmenteer
Carolina LeeBudding Pigmenteer
asked in Questions & Conversations
Actual in Scenario feature

 How do I construct my Actual with scenario feature? The source of my actual is a transaction list and when I was using versions I used  the formula below: costs_data.'R$'[BY SUM : costs_data.'Datahub month', costs_data.'N3 - imports'.N3,  costs_data.'Cost center', costs_data.'P&L row Datahub'][BY: Version."Actual"] +-1*'Cost center expenses'.'R$'[BY SUM : 'Cost center expenses'.Mês, 'Cost center expenses'.'N3 - imports'.N3, 'Cost center expenses'.'Cost center', 'Cost center expenses'.'P&L Row'][BY: Version."Budget"]+'Expenses budget input'[BY SUM: Account.N3, Account.'P&L Rows'][BY: Version."Budget"][remove:Vendors] But with scenarios I’m a little confused on how to make that.   

1701
Andrea
Community Manager
A
Anonymous
published in Questions & Conversations
Stay up to date with feature releases: subscribe to Updates directly from Pigment!

It’s possible to subscribe to our latest product updates by email or through an RSS feed (for example into a Slack channel): To subscribe to product updates in your Slack workspace, just use /feed subscribe https://changelog.pigment.app/rss.xml 

961
francois
Employee
Marina
Budding Pigmenteer
MarinaBudding Pigmenteer
asked in Questions & Conversations
Calculation of % in properties

Hello! We have our reporting per city & city dimension has region as a property. When I am trying to create a report to show margins for example for our group I want to start with the group margin, then the region and then the city. However, the formula which is on a city level doesn’t seem to work for the margin percentages for the region & group. It works only if I create different metrics with different formula on the different level dimension but then my report can’t have the sequence I want. Is there any solution here? Is there a way to fix this with ADD?  

4564
Marina
Budding Pigmenteer
R
Newly Minted Pigmenteer
rashiberliaNewly Minted Pigmenteer
asked in Questions & Conversations
Access Rights not working on Transaction Lists

I would like to include a transaction list in a Board. The Board has several other metrics and tables. The Access Rights functionality is working fine for metrics and tables (a user can only see numbers related to their department). However, it isn’t working on the transaction list. The transaction list has Department as one of the dimension.  Am I doing something that is causing this error or access rights just do not work on transaction lists?

1742
R
Newly Minted Pigmenteer
C
Budding Pigmenteer
Carolina LeeBudding Pigmenteer
asked in Questions & Conversations
Modeling by version (Budget and Forecast)

I am modeling our people expenses but I will need that for other modeling. I want to prepare it by version (budget, forecast 1, forecast 2, etc) and I want to let it easier to switch between versions as we need.For that, I am creating thoose metrics:Metric 1: Headcount Starting Point: that is the number of headcount we have just before starting planning the budget or forecast: (configured by: Version, month, cost center and seniority)Metric 2: Headcount addition: that will be where we will input the number of new headcount we are planning to have (configured by: Version, month, cost center and seniority)Metric 3: Total Headcount: Is the sum of  metrics 1 and 2 that gives me the final number of headcount (configured by: Version, month, cost center and seniority)My question is: How can I make sure that metric 3 only picks up data for the appropriate version? And also, how can I change the version it picks up accordingly with our planning time? For example: In November 22 we are going to

5431
francois
Employee
C
Budding Pigmenteer
Carolina LeeBudding Pigmenteer
asked in Questions & Conversations
Calculated item

Calculated item is only possible for columns? I’m trying to compare two rows but this “Add Calculated Items” is showing only in the column. 

4513
Nathan
Employee
Marina
Budding Pigmenteer
MarinaBudding Pigmenteer
asked in Questions & Conversations
Data export with formulas

Hello team! Is there an option to export data from Pigment and be able to trace back the formulas for calculated items than just having plain values?

1001
Benoit
Community Manager
D
Seasoned Pigmenteer
DastanSeasoned Pigmenteer
asked in Questions & Conversations
Filter non-dimension columns

How can I filter ‘Amount’ column, which is a number formatted column, so that it takes only negative numbers?GL.Amount[by sum:GL.Month,GL.Account, GL.'Department Pigment'][Filter : Account.'Account Code'="11010"]In the above formula, I am summing up transaction amounts from “GL” Transaction List  by Month, Account, and Department (which are all dimensions). However, I also want Pigment to take only negative amounts. I tried to paste [GL.Amount < 0] within the filter, but it keeps telling me that the system cannot do that, as GL.Amount is not a dimension but number.

1393
D
Seasoned Pigmenteer
T
Newly Minted Pigmenteer
TeeEllNewly Minted Pigmenteer
asked in Questions & Conversations
Find latest date in date list metric

Hi! I have a metric called “launch dates” with different project names. Project     |     Launch DateOne                7/1/2022Two                7/15/2022Three              8/1/2022Four                12/10/2022 From this metric (all the values are *date* type), I want to pull the latest date (in this case, 12/10/2022) into a new metric (LatestLaunchDate) to use it in a calculation. A simplified version of what I’m thinking would be:=IF(Month.Year > LatestLaunchDate, 1, 0) For any month prior to and including the month with the LatestLaunchDate, one calculation would apply. For any month after the LatestLaunchDate, a different calculation would apply. I tried a few versions of the MAX and BY MAX modifiers/functions but didn’t get the result I wanted. 

1762
T
Newly Minted Pigmenteer
Marina
Budding Pigmenteer
MarinaBudding Pigmenteer
asked in Questions & Conversations
Moving sum fixed start date, dynamic end date

Hello! I would like to calculate a movingsum formula where the starting month is always fixed (eg Jun 18) but the last month is always the current month. So for Mar 22 I would like the cumulative sum from Jun 18 to Mar 22 but for Apr 22 I would like the sum from Jun 18 to Apr 22. How can I do this? 

4247
Nathan
Employee
MKohli
Seasoned Pigmenteer
MKohliSeasoned Pigmenteer
asked in Questions & Conversations
Challenges with Application Duplication

Wondering if anyone has encountered some of the same issues I have after duplicating an application and found ways to resolve them.1. The duplication process has been complete for over a day and I still see [PARTIAL] on the new application. Is this something to be worried about? After duplication my new application has an error related to the User Roles metric which has limited details on how I might fix the problem. Not entirely sure why this error would appear since the application is an exact copy of an existing application where everything works. New ApplicationOld Application 

2102
MKohli
Seasoned Pigmenteer
Marina
Budding Pigmenteer
MarinaBudding Pigmenteer
asked in Questions & Conversations
Conditional formatting - color scales

Is there a way to use conditional formatting color scales without defining min & max manually? It would be nice if Pigment could identify automatically the lowest & highest value within the desired range and update the formatting respectively. Thanks

1641
C
Seasoned Pigmenteer
D
Seasoned Pigmenteer
DastanSeasoned Pigmenteer
asked in Questions & Conversations
Does Pigment support ChartHop integration?

Hi Pigment team, Does Pigment support ChartHop integration? ChartHop is not listed as one of the available tools for integration. Is there a way to create such integration? Best,Dastan

671
C
Seasoned Pigmenteer

Badge winners

  • Chatterbox
    Misbahhas earned the badge Chatterbox
  • Author
    Misbahhas earned the badge Author
  • Pigment Like a Pro
    Teo Storkhas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    Teo Storkhas earned the badge Pigment Modeling Fundamentals Certified
  • Read and Interpret Formulas Certified
    FelipeFonsecahas earned the badge Read and Interpret Formulas Certified
Show all badges
Terms & ConditionsCookie settings