Skip to main content

Questions & Conversations

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

  • 817 Topics
  • 2,205 Replies
817 Topics
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

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

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

2445
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

2432
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

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

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

1594
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   

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

721
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

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

6834
Y
Newly Minted Pigmenteer
O
Newly Minted Pigmenteer
Olivia Van Gerven
asked in Questions & Conversations
Use maximum values in new metric

Hello Community!  I created a metric where I can see the revenue of a product split by different countries per month. I can then use the aggregator “MAX” to give me the maximum obtained revenue - e.g. in which country the revenue was the highest that month. I would like to use this value (thus the name of this country) in a separate table where I have already other information on this product. What I would like to add in this table is thus “Product X - Top performing country”. Would this be possible? Thank you very much in advance! 

1412
O
Newly Minted Pigmenteer
O
Newly Minted Pigmenteer
OyvindBNewly Minted Pigmenteer
asked in Questions & Conversations
Viewing login activity by User

Hi, Is there any way as an admin to track when an user last logged into Pigment / track this over time? Would be great to have in order to track the actual adoption of Pigment across the business, given that a lot of user will only be consuming information (not making any changes to the assumptions, which would have appeared in the History logs). 

1352
O
Newly Minted Pigmenteer
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Can we use variables in formula?

Generally, we create metric for current month or year and use it for further calculation.If we can use variable in formula than we will not have to create metric for the same.So I would like to know that we can use variable in formula, if yes then how?

2242
abhilashsawla
M
Newly Minted Pigmenteer
Myriam AKILNewly Minted Pigmenteer
asked in Questions & Conversations
Assign a category based on keywords

Hello, I want to automate the loading of a statement. To do this, I have a database that assigns each keyword in a label to a category.I would like that when I reload my statement, Pigment recognizes the keyword in each label and assigns it to the corresponding category thanks to the created database. What formula can I use? Thank you for your help

1196
M
Newly Minted Pigmenteer
E
Just Arrived
Elliot TrabacJust Arrived
asked in Questions & Conversations
Loading data from Pigment into BigQuery

Hey team, Can we load data from Pigment into BigQuery? Thanks

1251
Keiran
Community Manager
K
KhadijaFrequent Reader
asked in Questions & Conversations
Accidentally deleted property content

I accidently changed a property from text to dimension and I lost all the date that was on the property of this dimension, this dimension list is extremely crucial and is the building block of other boards. Is there anyway I can have it back please?

1861
K
A
Budding Pigmenteer
AhmedBBudding Pigmenteer
asked in Questions & Conversations
Cumulate Last Twelves Months

Hi Pigment community,I want to realise a LTM (Last Twelves Months) analysis for a metric.For the moment, I’m able to cumulate only by the beginning of the period with the function:CUMULATE(Revenues,Month)[Filter: Month.Year = Year."FY 22" OR Month.Year = Year."FY 23" OR Month.Year = Year."FY 21"]I can make it “restart” each year with using CUMULATE(Revenues,Month,Month.Year) but I want to cumulate the last 12 Months onlyLTM Revenue Feb 22 should be starting from Feb 21 and not Jan 21.How can I do that?Many thanks

5402
A
Budding Pigmenteer
K
Budding Pigmenteer
Kamil SobczakBudding Pigmenteer
asked in Questions & Conversations
How to change the Y-axis scale for Bar Chart?

Hi everyone, How can I change the scale on y axis for bar chart? Pigment has set up the scale automatically which is not perfect as I would prefer to see it starting from 0. Is there a way to update this?  

1001
Benoit
Community Manager
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Vertical Waterfall Chart

Hi friendsI am unable to build vertical waterfall chart so, I would like to know how we can build vertical waterfall chart, if it is possible.

1892
abhilashsawla
N
Just Arrived
Nicolas BauvoisJust Arrived
asked in Questions & Conversations
TIMEOUT API EXPORT ExportTableData

Hello,I need to export a Table with API, when I test in Postman my get URL, I have an error 500 after 15 seconds.When I filter my table in Pigment, it works so can we adjust the API timeout ?Thank’s for your help.Nicolas.

1891
N
Just Arrived
MKohli
Seasoned Pigmenteer
MKohliSeasoned Pigmenteer
asked in Questions & Conversations
Looker Import Issues when Pushing All Results

Hi Community,Having a weird issue where when scheduling a webhook push from looker I’m unable to import all the data when setting the delivery to be All Results vs Results in Table. When doing Results in Table i’m able to import everything instantly but when configuring and sending a test for all results it doesn’t seem like any import is kicked off. Wondering what is occurring on the backend and if this a looker or Pigment issue. Setting I need to apply When having it for Results in table the import worked  

2843
MKohli
Seasoned Pigmenteer
H
Newly Minted Pigmenteer
HamzaNewly Minted Pigmenteer
asked in Questions & Conversations
The difference in income between two months

 I need to add a column to calculate the income [ m- (m-1)] in order to get the difference in income between two months do you know how to do it Thanks  

842
H
Newly Minted Pigmenteer
E
Seasoned Pigmenteer
ElodieSeasoned Pigmenteer
asked in Questions & Conversations
Access rights in tables

Hello!I have created AR rules to give a person access to one country only. I have verified the access on all blocks through the impersonate feature and everything seems to be working. However, the person doesn’t have access to some tables (though he has access to the correct data in the metrics composing the table)… This message appears:Could you please help me to understand what is happening here?Thanks!Elodie

1072
Benoit
Community Manager

Badge winners

Show all badges
Terms & ConditionsCookie settings