- - Search the Knowledge Base
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!

71 Topics
187 Replies

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

71 Topics

Recently active

Most replies Most views Newest first

Tess.HuntCommunity Manager

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!

743

1 month ago

abhilashsawlaNew Pigmenteer

posted in Questions & Conversations

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

I want same feature like Today() in Excel.

1 hour ago

JoseNew 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

16 hours ago

Carolina LeeNew Pigmenteer

asked in Questions & Conversations

Balance Sheet: Net Income

Which formula can I use for Net Income at my balance sheet in the begging of the year where I need to transfer all Net income to Retained earnings / losses and start accumulate again? See below an example. I read this article below but I couldn’t understand:

1 day ago

Alix NoyonNew 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 😉

1 day ago

Alix NoyonNew 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!

1 day 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.

1 day ago

JoseNew 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

3 days ago

abhilashsawlaNew Pigmenteer

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.

3 days ago

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

6 days ago

JoseNew 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

8 days ago

SusmitaNew Pigmenteer

asked in Questions & Conversations

How to estimate the size of an Application?

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

15 days ago

Carolina LeeNew 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.

20 days ago

Alix NoyonNew 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 ;) !!

20 days ago

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

21 days ago

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

21 days ago

Fabien BigeardNew 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.

22 days ago

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

23 days ago

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

24 days ago

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

27 days ago

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

1 month ago

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

1 month ago

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

1 month ago

EvaKJust Arrived

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!

1 month ago

SusmitaNew Pigmenteer

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.

1 month ago

Page 1 / 3

Badge winners

Anatole Sauvathas earned the badge Pigment Modeling Fundamentals Certified
Laëtitiahas earned the badge Pigment Modeling Fundamentals Certified
Estherhas earned the badge Pigment Modeling Fundamentals Certified
Jérémyhas earned the badge Pigment Modeling Fundamentals Certified
MKohlihas earned the badge Thought Leader 1

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.