- - Search the Knowledge Base
Academy
Product Roadmap
Events
Groups

Community
Explore the Community
Questions & Conversations

Questions & Conversations

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

278 Topics
757 Replies

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

278 Topics

Recently active

Most replies Most views Newest first

Naomi VriendNew Pigmenteer

asked in Questions & Conversations

Bamboo HR integration error: "Report does not exist"

Hi Pigment Support, I’ve integrated Bamboo with our workforce planning app via API Token.However, when I try to import a report get the error “Report does not exist”.I know the report exists in Bamboo, and I have double checked the report ID which is definitely right.We have also integrated Bamboo with other services we use without issue.Any hints on how to fix this?Thanks!Naomi

1 day ago

Mor KebeJust Arrived

asked in Questions & Conversations

reate the Bonus per month Metric

Month is supposed to be a list demension but if i write t the formula it came like a function.Thats why the formula is false

1 day ago

Anas TahriJust Arrived

asked in Questions & Conversations

HINT feature ON by default

Hello, Is there a possibility to have the Hint feature enabled by default or a conditional format that highlights cells where end users can manually make changes? Thanks in advance,Best,Anas

2 days ago

Jessica TNew Pigmenteer

asked in Questions & Conversations

IF formula modelling

Hello,Can you please help me with this question?I want to do a formula using IF or many IF condition.I am working with a block having months in columns and currencies in rows.Explanation: My formula is suppose to say if at the level of dimension month we select let’s say February month, I am suppose to obtain in January and february each actual rate and for the rest of the months, having february rates. And I am suppose to have the same logic if I select any month.Waiting for your response.Thanks.

2 days ago

Daniel CicakNew Pigmenteer

asked in Questions & Conversations

Salesforce Import Amount Fields

Hi Community,we just started to push Salesforce Data into Pigment.Currently we face the issue, that our Salesforce amounts (Type currency) cannot be imported into Pigment as number, due to the currency symbols.Is there any workaround instead of converting all Salesforce amount currency fields into number fields? (we have a lot)Thanks,Daniel

2 days ago

Jan Veerman PlanadigmJust Arrived

asked in Questions & Conversations

What is the easiest way to check connectivity between Models

If you create 3 Models, what is the easiest way to check which Dimensions, Metrics from one Model are used in another?Case: a copy has been made of a working Model and updated. Too many updates have been made and we want to make the copied Model the new Model, but we need to check which Blocks to reconnect. What is the best way to do that? Dependency Diagram in combination with Settings > Libraries? Or is there a quicker way?

2 days ago

VianneyJust Arrived

asked in Questions & Conversations

Modify a calculated item directly from the dashboard

Hello Pigment community, I am trying to compute a table showing in a column the YTD revenue, but the YTD can not be fixed on a specific month but be variable (if we want to see the YTD for 2 months ago for example). The only way i saw how to do a YTD revenue is to use a “cumulate” in the calculated items, when i add a calculated item on the dimension “month”. But if i want to change my month from the “current month” to another month, like two months ago, i will have to go back to the calculated item in the pivot. Is there a way to change the “item” in “calculated item” easily directly from the pages of the table, so that we can change it directly from the dashboards ? Or if this does not work like that, is there a way for me to be able to get a YTD computation that can be edited directly from a dashboard ? Thanks a lot for your help !

3 days ago

keerthanarameshNew Pigmenteer

asked in Questions & Conversations

Vendor Mapping

Hi!Can someone please help me to find the vendor names from the description of a transaction from a list of vendor list that I already have?Right now, with the help of ITEM function its able to only recognize if the description has only the full vendor name from the list. But I want to populate vendor names by finding the vendor names in the description among other extra texts as well.For example,if my Description is “Amazon.com” ITEM function is able to recognize the vendor name and populate Amazon.com from the list that I have as a dimension. if the description is “Orders from Amazon.com”, its not able to find “Amazon.com” among the other texts in the description.So I’m looking for a way to find these vendor names from the description which has other text apart from the vendor name and populate it.Thank you!

3 days ago

abhilashsawlaAdvanced Pigmenteer

asked in Questions & Conversations

How to define Security Read & Write Access

Hi,I have two applications. Hub (All Dimensions and Security Role.) Budgeting (All Calculations)I want to know how I can define security in budgeting application by using of Hub application role dimension.

3 days ago

nancyEnthusiastic 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

4 days ago

AhmedBNew 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

7 days ago

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

7 days ago

BenedikteNew Pigmenteer

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

8 days ago

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

9 days ago

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

10 days ago

abhilashsawlaAdvanced Pigmenteer

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.

14 days ago

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

16 days ago

KhadijaEnthusiastic Pigmenteer

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:

16 days ago

Team PlanafinNew 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

16 days ago

Guillermo PulsNew 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

16 days ago

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

16 days ago

abhilashsawlaAdvanced Pigmenteer

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.

16 days ago

MKohliEnthusiastic 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

17 days ago

KhadijaEnthusiastic Pigmenteer

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!

17 days ago

JoshEnthusiastic Pigmenteer

asked in Questions & Conversations

As of Date for KPI

How do you create/show a date as a KPI. I want to show the last day of actuals for a data set and bring that into a board as a KPI. Is that possible?

17 days ago

Page 1 / 12

Badge winners

KarlWhas earned the badge Advanced Modeler
Yaejishas earned the badge Aspiring Modeler
Ilya Zhivovhas earned the badge Pigment Modeling Fundamentals Certified
Jan Veermanhas earned the badge Thought Leader 1
Shashankhas earned the badge Pigment Modeling Fundamentals Certified

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.