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

601 Topics
1,627 Replies

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

601 Topics

Recently active

Most replies Most views Newest first

Cedric LJSeasoned Pigmenteer

asked in Questions & Conversations

Org chart icon not displaying

Hello,I don’t see the format Org chart icon (see first screenshot)Maybe i am missing a metric or something else. Here the current structure of my table:Employee is on the left side.Thanks for your help,

10 months ago

Bill LustgartenNewly Minted Pigmenteer

asked in Questions & Conversations

Calculating directly in a table?

Hello. I have created a table with multiple metrics. The calculations work currently, except the percentages are aggregating or calcing oddly when I display the table. When we’re looking at data at NOT the lowest level, the % is incorrect.In the screenshot below, I basically want the Account Churn % to display Churned Accounts / Active Accounts BOP. So 1%, 4%, 5% etc. I looked into Calculated Items, but doesn’t seem like that would work in this case. Am not looking to alter the metric itself, but rather to add a row for display purposes only.Thanks.

10 months ago

Vamsi KakiJust Arrived

asked in Questions & Conversations

Inbuilt Pigment Application

Hello,Does Pigment Academy has pre-built applications which can be downloaded and use for practice purpose?Thanks,Vamsi

10 months ago

YaejisNewly Minted Pigmenteer

asked in Questions & Conversations

difference vs last 4 years ago

Hello,I am trying to get current month vs 4 years before same month variance. Can you please help?I tried using the offset calculation to offset by 48 months ago, but it is giving me 4 years ago value rather than the difference. So, Aug 23 is 10.9 and Aug 19 is 9.5. So I need to get the result of 1.4 in a new column. Thanks in advance!

10 months ago

rykasaNewly Minted Pigmenteer

asked in Questions & Conversations

Load specific accounts from Quickbooks

Is it possible with the Quickbooks integration to only load specific accounts from the Income Statement? For instance, I only want to import revenue accounts into a block. Is that possible?

10 months ago

Cedric LJSeasoned Pigmenteer

asked in Questions & Conversations

Internal mobility between teams

Hello,I would like to correct the below formula so I can have the team of each employee by month based on his entry date and exit date with no time limitation.The way the formula is currently it does not take into account the fact that I have 2 lines in my transaction list for an internal mobility. It only take into account the latest subteams.Here is an example:‘Dataload HR tool - Employee.’ is my transaction list with all the info by employee.Currently for this employee, i have the following result.But it should be “Finance & Planning” team until jan 24 and from Feb 24 until the end “Product data” The data will be updated each month on the latest version of the ‘Dataload HR tool- employee’. Thanks for your help

10 months ago

Mitch MaxJust Arrived

asked in Questions & Conversations

Excel Connector questions

Great to see this new functionality! 2 questions:Is there a way to preserve formatting in Excel (i.e., to refresh data in a report) I cannot see an option to “push” data, only to pull. What am I missing?Thanks!

10 months ago

Kamya NJust Arrived

asked in Questions & Conversations

Download Academy template apps

How can I download Academy template apps into my company's workspace?

10 months ago

Cedric LJSeasoned Pigmenteer

asked in Questions & Conversations

Count of FTE with internal mobility

Hello, I did the below formula in order to count the number of FTE. It’s works well except for the internal mobility where it counts 0. One of the employee concerned by this case is the below employee: What do i need do to in the formula to take into account the internal mobility ?Thanks in advance

10 months ago

Vamsi KakiJust Arrived

asked in Questions & Conversations

How to create Dimension list and Transaction List?

Hello, How to create a Dimension and Transaction list?and also How to create properties in the lists. Thanks,Vamsi

10 months ago

rykasaNewly Minted Pigmenteer

asked in Questions & Conversations

Employee images from BambooHR

We have employee images stored in BambooHR. Is there a process for downloading those images so that we can upload them into Pigment for the org chart feature? I’m not able to download it through the integration. If not directly through the integration, how can I do this?

10 months ago

Lester ChowNewly Minted Pigmenteer

asked in Questions & Conversations

How do you count unique months in a metric?

How do I get a unique count of months in a metric in a view?For instance, I have Revenue (Dim: Month): Jan23 : 10Feb23 : 15Mar 23 : 20 I’m looking at this metric in a quarterly view, Month > Quarter and I want to annualize this number. So the math would be (10 + 15 + 20) * 12/(3) (3 months in this time frame). I want this to recalc when I view it from a yearly perspective so it would be 12 months. Any ideas on this? I tried doing Revenue [REMOVE COUNTUNIQUE: Month] but that just found the number of uniques in my Month Dim List and multiplied by that.

10 months ago

OliverNewly Minted Pigmenteer

asked in Questions & Conversations

Collapse columns total remains empty

Hi, I have an issue regarding the behaviour of the new expand/collapse columns feature.When I have a summary set to the dimension I want to collapse (Month>Year : LAST for example). If I collapse this dimension the Total column remains empty while it is well displayed when expanded.Do you know why and how to solve this? Thank you

11 months ago

EmiliaJust Arrived

asked in Questions & Conversations

Formula timed out

Hi,Could you please tell me what Formula timed out does mean and how it can be sorted?Thank you!

11 months ago

Cedric LJSeasoned Pigmenteer

asked in Questions & Conversations

# deals signed per month

Hello,I would like to create a metric that count the number of deals per month depending on the dimension below. In order to do so we should use “ ID prm client and “date of first contract signature” from the below dimension.How can i do that ?Thanks for your help.

11 months ago

Guillermo PulsBudding Pigmenteer

asked in Questions & Conversations

The latest Month

Dear Community, I have a transaction List and have a Property which Type is Dimension (Month) Text.I’m looking to create a metric that tells me the latest month on that property. How can I achieve that? Thanks in advance :D

11 months ago

Guillermo PulsBudding Pigmenteer

asked in Questions & Conversations

Counting through a Boolean

Dear community, This is a quick one. I have a Boolean metric with one dimension (Employee). The metric shows a list of employees with the tick box marked.I am struggling to generate a KPI that show me the number of employees in the list. What’s the best way to approach this outcome?Many thanks in advance :D Metric: if(Transaction List. Bolean property'[by firstnonblank: Same Transaction List.Employee Name],true) I obtain a list like

11 months ago

Cedric LJSeasoned Pigmenteer

asked in Questions & Conversations

Average MRR invoiced per cohort

I tried to calculate the average MRR invoiced per cohort but it’s not working.i tried to drill down but dit not find the solution.For example: MRR by cohort for Cohort 14 in jan 23 is equal to 4315€ and '# MRR invoiced by client is equal to 6.The calculation should do 4315 divided 6, but it’s not.Can you help me ?Thanks

11 months ago

KLIUJust Arrived

asked in Questions & Conversations

Creating Customer Count metric

I want to create a Metric for Customer Count. We have ACV $ and Churn $s, do you know you and/or someone on the Support team can help / work together to make sure I am doing it right? Can we jump on a quick 30min call? TY

11 months ago

YaejisNewly Minted Pigmenteer

asked in Questions & Conversations

Org Chart Hierarchy setup

Hello!I am trying to build an org chart for my company. Most part is good to go, but I noticed that the “Position <> Manager” metric for Reporting seems to confuse the overall structure at the end. When looking at below snapshot, I clicked the ‘Strategic Finance’ team and employee A” is our CFO. My goal is to show “B” and “C” employees underneath “A” employee only because this flow is for the “Strategic Finance” department, However, it’s showing +6 who are NOT part of “Strategic Finance” department. Is there any way to fix this? Thanks!!

11 months ago

Cedric LJSeasoned Pigmenteer

asked in Questions & Conversations

Last quarter calculated item not displaying the right amount

Hello,I have used the LQ calculated item to create a table but the amount displayed in April 2023 LQ is the amount of jan 23 actual. Can you help me ? Thanks

11 months ago

KatiePJust Arrived

asked in Questions & Conversations

Google Sheets Connector & Data imported not matching format or filters set in saved view

When building & refreshing an existing connection to Pigment, the view I have saved does not pull through to google sheets in the format that I saved the view. It also does not pull through all the page filters that I have, specifically the years page filter.This causes the whole import to pull through for all existing years for all scenarios that I am pulling in. It also pulls through all data rows even if there is no underlying data. For example I am pulling a full P&L and instead of pulling through just the Revenue Accounts for Account L1 Net Revenue it also pulls through every Opex, CoR, etc. account L0. This causes a ton of extra useless empty rows in our google sheet. This is a lot to scroll past & causes noise in our workbooks. Is there a better workaround here? Right now I have one tab just for the Pigment connection & then have to manipulate the data on another tab to get the format cleaned up.

11 months ago

Sofia CostaBudding Pigmenteer

asked in Questions & Conversations

reducing values in a droplist | transaction lists

Hello community, I’m creating a transaction list to be inputted manually by an end user.How can I have a reduce list for a certain dimension?eg: in a country dimension with all countries, the list available needs to be only the European countries. As a workaround I’m creating extra lists to have these sub-lists. But it will not be a very clean strategy in the end. Does anyone have another way to overcome this?Thank youSofia

11 months ago

KevinSeasoned Pigmenteer

asked in Questions & Conversations

Creating an Identity Matrix

I have a dimension that is a number (30 Day Cohort). I think I will need an identity matrix for some calculations later in my model. Is it possible to create a metric that has the 30 Day Cohort x 30 Day Cohort? Here is a simple example of what it would theoretically look like.I have tried playing around with the Value function to convert to numbers and do some sort of comparison to the dimension but it doesn’t return what I would like:IF(VALUE('30 Day Cohort'.Name)<VALUE('30 Day Cohort'.Name),0,1)[BY SUM: '30 Day Cohort']Any ideas or things to try would be much appreciated. At the end of the day, the 1s in the matrix will eventually be values calculated from other metrics but I think I need this matrix to do those calculations. But then again I may not given Pigment’s various functions and how it handles dimensions. So any and all ideas are welcomed :) Thank you in advance!

11 months ago

KevinSeasoned Pigmenteer

asked in Questions & Conversations

How to replicate the MAXIF Excel function

I have a metric that has two dimensions that have pasted values from another source. What I would like to do is return the last month that there is a value > 0 for a specific row in the metric. In Excel terms, this would be done with a MAXIF function where I would return the max month with the condition that “Net Installs” is > 0. From the screenshot below I want to return the month dimension value of Dec 24Can this be accomplished using just the BY modifier and the MAX aggregation method? Any insights are very much appreciated. Thank you in advance.

11 months ago

Page 11 / 25

Badge winners

debapriya.a.guhahas earned the badge Pigment Modeling Fundamentals Certified
PatrickWhas earned the badge Partner Solution Consultant Certified
Benjamin Lhas earned the badge Read and Interpret Formulas Certified
PaulThas earned the badge Pigment Modeling Fundamentals Certified
Colmhas 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 E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

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.