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
nancy
Seasoned Pigmenteer
nancySeasoned Pigmenteer
asked in Questions & Conversations
Boolean security

Hi Team,Can anyone help me to define security for a Boolean.In my use case there is a requirement that user can select only one scenario (3 scenarios created in a dimension) for each country and product family. Thanks in advance  

3021
Benoit
Community Manager
A
Budding Pigmenteer
AhmedBBudding Pigmenteer
asked in Questions & Conversations
Pushing Data from Gsheet to Pigment

Hi here,The possibility to Push Data from Gsheet to Pigment is very useful, thanks.However, when pushing the informations, it seems that the line are being added to the previous lines and not replacing them.For example, if someone is reviewing his budget in Gsheet and we want to push the information in Pigment, new figures will be added the previous pushed figures.Is there a way to “update” the Named_Range and not adding it? Thanks

1724
Benoit
Community Manager
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Find certain text and exclude

Hello!Can someone please help me to upgrade the following formula?I would like to add following statement: “If there’s [N/A] in the job name, (blank) result in the ‘Model FCST Month Dimension’ property.IF(ISBLANK('[FCST] Greenhouse List'.'Start Date (Offer) Dimension'),IF(ISBLANK('[FCST] Greenhouse List'.'Manual Input'),'[FCST] Greenhouse List'.'Forecast Start Date Dimension','[FCST] Greenhouse List'.'Manual Input'),'[FCST] Greenhouse List'.'Start Date (Offer) Dimension')Thanks in advance!!   

4323
Y
Newly Minted Pigmenteer
B
BenedikteOccasional Observer
asked in Questions & Conversations
Filter function for multiple contitions

Hi, I am looking for a way of using the filter function with two conditions. Example: Looking for a sum of specific accounts and cost centers. lets say for accounts: 400,401 and 406 and from cost centers 21;1000;1150;1321;1400;2321;2400.I am already using the filter to look for the sum of the accounts, but found out that I need it on specific cost centers as well Any ideas how to solve this? :) - Benedikte

2014
B
M
Newly Minted Pigmenteer
MikhailIvinNewly Minted Pigmenteer
asked in Questions & Conversations
Filtering different elements of a dimension in the same metric

Hi everybody. I’ve come across a task to post one metric to a dashboard in the form of several graphs each of which will show the only element of a dimension. Let’s say we have different networks: 2g, 3g, 4g in a single metric. I need three graphs to show traffic per network type: The first one should be 2g traffic, another one - 3g, the last one - 4g.They should not be synchronized by this dimension (‘Technology’ dimension on the graph). How to properly do it? Thank you.

1331
francois
Employee
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Count by hired and terminate dates and employee type

Hello, What is best way to setup the metric formula to summarize the # of headcount by following three?by Division (using Division property) by monthly (using Effective date property. This is basically monthly HC Data exported date.) by Worker type. (using Worker Type property)  Thanks in advance! 

1353
Y
Newly Minted Pigmenteer
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Write Access for boolean Type data type

HiCan we provide Write access to Boolean data type?if yes, please let me know how.

1202
abhilashsawla
S
Newly Minted Pigmenteer
sbenkovNewly Minted Pigmenteer
asked in Questions & Conversations
Growth of Negative Items and Conditional Formatting

I’m having issues properly showing the growth and variance of negative items.As an example, if actual EBITDA was -0.25 and budget was -1.0, I can get the difference to display correctly, but my only options for % variance are-75% (-.25- -1.0)/-1 or  +300% (-1- -.25)/-.25Neither of those are correct.  It should be +75%.  I can use “Reverse Signs” but that doesnt apply to conditional formatting.  Has anyone figured out a better way to show this in a table?

1401
W
K
KhadijaFrequent Reader
asked in Questions & Conversations
Multiple IFS

Dear all,Can you please help me with this function? I keep getting the error note.  I am trying to say IF(X or Y then) and IF(A or B then).The function is as follows:  

3392
K
T
Budding Pigmenteer
Team PlanafinBudding Pigmenteer
asked in Questions & Conversations
Board Visualization

Hi Team, As we know pigment is all about visuallization, how interesting and convenient we can make board for the end user and visually appealing . On community we have article on Board Inspiration also where we get tips on board preparation but it would be more helpful if we could have some pictorial representation of how we can make our board more eye catching and sensible for end user at the same time. It would be preferred if we could have some sample images of recommended board. Or is there any article on the same which i may have missed than kindly help me locate that. Thank you in advance

7583
Benji
Guillermo Puls
Budding Pigmenteer
Guillermo PulsBudding Pigmenteer
asked in Questions & Conversations
FX Conversion Challenge

Hi Pigment Folks, I have the following FX conversion rate challenge,ContextI build my Balance Sheet from staging transaction amounts in local currency from Transactions list and structuring the amounts over a hierarchy were account number is the lower level.My problem comes when trying to convert the amounts to our reporting currency. - I have a metric where I input the conversion rates on a monthly basis. - The balance sheet has the following behaviour: Every month, the cumulative amounts should be converting to the latest rates. And every year should be converting to the last month of the year rates.ChallengeI’m looking to create an FX metric that I can apply to the staged amounts that it’s flexible.I mean that whenever I’m showing data by years, quarters and months select the right rates.For years would multiply the staged cumulative amounts by last month of the year rateFor month would multiply the staged cumulative amounts by each month ratesFor quarters would multiply the staged

8572
Nathan
Employee
nancy
Seasoned Pigmenteer
nancySeasoned Pigmenteer
asked in Questions & Conversations
EBITDA

Hi Team,Please suggest me a way to calculate the difference between Income (List item) and Total Expense (Calculated item) in order to calculateate EBITDA.Screenshot attached below for your reference. 

3972
Benji
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Why Empty Row is added automatically in This Table and how to remove it.

Hi I Have created a table, but an Empty Row is getting added there with data and not getting any Error while applying formula. Please help to solve this problem and Screen Shot is attached here for your reference. 

1075
Benoit
Community Manager
MKohli
Seasoned Pigmenteer
MKohliSeasoned Pigmenteer
asked in Questions & Conversations
Unique Counting w/ Filters

Hi Community, Wondering if someone has been able to manage counting unique customers for a metric dimensioned by customer & product.We have an ARR Metric defined by Customer ID, Product and Month. I would like to have a count by month of the unique customers which have an ARR value. The standard approach using the formula below is effective in having total customer accounts but I am then unable to filter on the products available. IF('Ending ARR'[remove sum: 'Product Type'] <> 0 and ISDEFINED('Ending ARR'[remove sum: 'Product Type']), 1 , blank)I worked to try and resolve this issue by leveraging the below formula which does allow me to filter on products and not double count total logos but when filtering on a single product the number becomes understated. Exec filtering on a product that is part of a set>1 would yield 0.5 or 0.33 vs 1Switch(IF('Ending ARR' <> 0 and ISDEFINED('Ending ARR'), 1 , blank)[remove sum: 'Product Type'],  1,1,  2,0.5,  3, 1/3)*IF('Ending AR

4551
Fabien
Employee
K
KhadijaFrequent Reader
asked in Questions & Conversations
Data Import Error Message

Dear all, I have been trying endlessly to import data into this transaction list, but we get this error message of excluded values from the CSV source. We’ve already imported data into other lists and it’s the first time we get this error message so I was wondering if you could help us with it.Here is the error messagethe excluded data was supposed to be added on properties that are dimensions. The data we’re importing is very simple text And the dimensions already exist on Pigment, we’ve already created them.I would really appreciate your help dear Pigment Community!

2386
Nathan
Employee
A
Seasoned Pigmenteer
Alix NoyonSeasoned Pigmenteer
asked in Questions & Conversations
Contains function within a IF condition

Hello, I want to create a if function, in which the logical test is a contains function. If the result from contains function is TRUE => put a value from a dimension, if the result is FALS => put another value from a dimension. I tried to do that like this (in a column dimensioned into FF_fg_non_Ankorstore, supporting the logical test): IF((CONTAINS("FF",TL_OLC.'Lb Charge Type')=  TRUE,FF_fg_non_Ankorstore."FMV",FF_fg_non_Ankorstore."AKS") But it is not working. Could someone help me on that ? Thanks a lot!

2125
A
Seasoned Pigmenteer
J
Seasoned Pigmenteer
JoseSeasoned Pigmenteer
asked in Questions & Conversations
Error during formula computation. Some values overflows 10^14

Dears, I have been getting this error recently when I perform divisions on Pigment. I understand division by 0 or blank can give NA, that is why I use an IF in the formula to make sure we do not computate those values. Thank you very much in advance!Jose

2102
francois
Employee
A
Seasoned Pigmenteer
AlexandreSeasoned Pigmenteer
asked in Questions & Conversations
Compare Scenario

Hello,Is there a way to compare easily Scenario between them ?E.g: I want to compare Budget 1 vs Budget 2 with variation (value and %). But I also want to compare Budget 2 vs Budget 3 the same way and I don’t wan’t to create another view with another calculated item, because I have numerous scenario to compare.The idea is to have a var (value and %) between 2 scenario by selecting them. Is it possible ?Thanks

2656
A
Seasoned Pigmenteer
T
Newly Minted Pigmenteer
TomCNewly Minted Pigmenteer
asked in Questions & Conversations
Filtering Transaction Lists on Dashboards

I can see the page options for metrics and graphs that allow filters to be linked to the same as the board. However is the same available for Transactions lists?  Many thanks!

832
T
Newly Minted Pigmenteer
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Metrics level condition formatting

Hi Can we define condition formatting based on metrics?

714
abhilashsawla
K
KhadijaFrequent Reader
asked in Questions & Conversations
Aggregate a dimension to a metric

I have a transaction list with a property that is filled through a dimension list with a month, this transaction list has also another property where I want to aggregate the latter property that is filled through the dimension list (month) and a number metric containing the number 2. But I get this error message “ Expressions are incompatible and cannot all be converted to Dimension (Month)”.My end goal is to have my needed property with the property containing the month dimension + 2I don’t want it to be done manually so I want it to be added to this metric containing the number 2.I hope my question is clear. I am impatiently waiting for your feedbacks!

1524
Nathan
Employee
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
By Sum and filter

Hello!  I am trying to summarize the cost by department and division by monthly basis using transaction list from another app. The setup is set as how I would like to see but the sum of amount is not same as what I expect. Can you please help? Thanks in advance! This is the logic I used to create a metric:'PL GL Data'.'Net Amount (USD)'[BY SUM:'PL GL Data'.'PL L0','PL GL Data'.Division,'PL GL Data'.Department,'PL GL Data'.Month][FILTER:'PL GLs'.'PL Cat 1'='PL Cat 1'."Headcount Costs"]Here’s the PL GL Data transaction list. For sanity check, I filtered out “Headcount Cost” for PL Cat 1 and March 2023 transactions only. Total should be $9,100,788.45 but I am getting $9,124,046.48   

2694
Y
Newly Minted Pigmenteer
E
Budding Pigmenteer
ELeff_AccBudding Pigmenteer
asked in Questions & Conversations
Google Sheet Connector Error when ignoring columns

We are currently utilizing a Google Sheets connector to a worksheet that has a series of data that contains old logic that we wish to calculate within Pigment going forward.  In this particular example, the Google Sheet worksheet contains both  Annual Amounts (which we want to import), as well as Monthly Amounts (which we want to ignore and recalculate within Pigment as this was using a historical spread methodology to be augmented in Pigment).  We are finding during the configuration of the Import, when we elect to Ignore (delete the columns from the import definition) and kickoff the integration we get failures, stating the following: Two questions: Is it assumed that in the below example, the desired data must come first and cannot be situated after data that is desired to be ignored? Is ignoring columns when utilizing a Google Sheets Connector not allowed?  

691
E
Budding Pigmenteer
B
Newly Minted Pigmenteer
Bill LustgartenNewly Minted Pigmenteer
asked in Questions & Conversations
Best practice for blank dates?

Hi. First time poster here. :)We import transaction-level data with revenue and other info. One dimension in the data is “account cohort month”, which lists the month an account was created. This is a dimension list in the calendar of our hub. However we have many transaction-level rows with a blank “account cohort month”. This is correct, as there are specific internal rules to what is considered an account.When we try to create metrics pulling revenue from the transaction-level load, it is excluding all those with a blank “account cohort month”. We don’t want to exclude the blanks. When we analyze the cohorts, we want all the cohort months but also a bucket for “no cohort” or similar.What’s the best practice for handling this? The transaction-level data is MANY rows, so manipulating the data in Pigment is probably ill-advised. We could have blanks populated as “NULL” or “No Cohort” before loading to Pigment, but since this isn’t a calendar item, would that even work? (Or how would we

1661
MKohli
Seasoned Pigmenteer
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Using something similar to Vlookup

Hello, can you please help me with formula something similar to vlookup?Trying to fill in the Division property using the Department code dimension.Tried using “ITEM('PL GL Data'.Department,'Department Code'.'Department Name')”, but error says “ Error: Expressions are incompatible and cannot all be converted to Dimension (Department Code)” Thanks in advance!   

6534
Y
Newly Minted Pigmenteer

Badge winners

Show all badges
Terms & ConditionsCookie settings