- - Search the Knowledge Base
Academy
Product Roadmap
Events
Groups

Community
Explore the Community

Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

1047 Topics

Most replies

Most views

Newest first

Isabella Leslie-MillerCommunity Manager

published in Company News

The Pigment Awards are open - submit now!News

We’re thrilled to announce the Pigment Awards 2024, recognizing the achievements, innovation, and leadership within our incredible community. This is your chance to showcase how you or your team have driven change, optimized processes, and inspired others using Pigment!🏅 Award Categories:The Game-Changer: Business transformation project of the year. The Optimizer: Best process optimization initiative. The Trailblazer: Best use of AI in finance. The Visionary: Most innovative use of Pigment. The Bar-Raiser: Celebrating individual excellence.📅 Nominations are open now until December 31, 2024. Winners will be announced in February 2025, with prizes including a celebratory dinner or charity donation.📝 Submit your nomination now!Let’s celebrate the game-changers and innovators shaping the future with Pigment. Will you or your team be among this year’s winners? 🚀#PigmentAwards2024 #CommunitySuccess #Innovation

800

8 months ago

Spandan98Master Author

posted in Questions & Conversations

Resources to become an expert in Pigment

Hello Pigment Community,I’m new to Pigment and eager to become an expert in using the platform. To accelerate my learning journey, I would greatly appreciate your help with the following:Practice Assignments: A list of exercises or projects, starting from beginner to advanced levels, that I can work on to build and refine my Pigment skills. Video Tutorials: Resources or video walkthroughs demonstrating how to implement large-scale projects in Pigment.Having access to these resources would significantly enhance my understanding and hands-on experience.If anyone can point me in the right direction or share relevant materials, I’d be incredibly grateful! Looking forward to learning from this amazing community.Thank you so much for your time and support!

1125

8 months ago

HarshilApprentice Author

asked in Questions & Conversations

Dynamic Variable Not Updating by Scenario

I created a dynamic variable called “TvA Actuals Range” and set it equal to the “IsActuals” date range. The issue is that the date range is not updating based on the scenario. Can you please advise?

431

8 months ago

JDLoveAuthor

asked in Questions & Conversations

Hub Shared Dimensions not showing in Application Metric Settings

Basic newbie question, I have a sample Hub that has the shared dimensions, I am building a test application but I cannot seem to get the shared dimensions to show as options in the Metric Settings. I can see the Hub Dimensions are showing as shared.I can see the Hub Application is showing as shared.Thanks JDLove

492

8 months ago

Spandan98Master Author

asked in Questions & Conversations

Quarter and Year dimensionality problem

How to add a grid on a board with input fields? For example I have data for quarters and I want to set targets of a year which can be entered by the user on a board. How can I achieve this?

492

8 months ago

YaejisMaster Author

asked in Questions & Conversations

Amortization based on start/end dates

Hi Pigment team! I am trying to setup a amortization schedule as following. Can you please help?Orange is given resources Green is the output that I would like to have in the table/metric Blue is just validation for myself which aligns with the orange Total column and doesn’t need to be in the model Following is the formula I used in excel:For 1/31/2023 Column alone, formula is =($V5/$AS5)*((AV$4-$AQ5)+1) For 2/28/2023 and onwards, formula is =IF(EOMONTH($AR264,0)<AW$4,0,IF(AW$4<=$AR264,($V264/$AS264)*(TEXT(AW$4,"d")),($V264/$AS264))) I tried using the following formula in playground for 1/31/2023 column, but it doesn’t seem to work. IF(Month.'Start Date'=DATE(2023,01,1),('RSU Accounting Data'.'Expense Amortized Future'/'RSU Accounting Data'.'Amortization # of Days') * DAY(Month.'End Date')) Thanks for helping out!

4357

8 months ago

BenedikteAuthor

asked in Questions & Conversations

Error: Unknown Block (List or Metric)

Hi,I am getting an error in my metric that is saying that block that I am referring to is not existing, but in fact it is a block that I am using actively in my management reporting. So I do not understand why it seems like the Block is not possible to retrive.Can someone please help me out regarding this? :)Best regards,Benedikte

412

8 months ago

MaxenceGoigApprentice Helper

asked in Questions & Conversations

How to apply a recurring calculation on a metric with a monthly dimension ?

Hi everyone,I need help applying a recurring calculation to a monthly metric in Pigment.Here’s the situation:I have a metric called RES_Active Doctors, and I want to apply month-by-month the percentage stored in IN_Churn Existing Doctors - 3YP. The calculation should use the value of the previous month as the base.For example:If the initial value of RES_Active Doctors in Month 1 is 100, and the percentage in IN_Churn Existing Doctors - 3YP is 10%: Month 1: 100 (initial value) Month 2: 90 (100 - 10%) Month 3: 81 (90 - 10%) Month 4: 72.9 (81 - 10%) And so on. I’m wondering how to model this type of calculation in Pigment. Is there a function or method to automate this logic by referencing the previous period?Thanks a lot for your help! 😊

1272

8 months ago

ChahatMaster Author

asked in Questions & Conversations

RANK function - How to handle ties

I have a metric : which has 20, 20, 20 and 15, 11 numbers I need to show Top 2 of the products: It only shows the 2 products with 20 valueIt should show all those products with 20,20, 20 and 15 value20 is a tie number.

29114

8 months ago

William Murray BrownApprentice Helper

asked in Questions & Conversations

Dimensions of "seasonality" argument for SEASONAL_LINEAR_REGRESSION

The documentation for the SEASONAL_LINEAR_REGRESSION function states that the “seasonality” argument can have the following dimensions:No Dimension or Dimensions of Text 1I have two questions about this…When I try to use a metric with no dimensions as this argument, I get the error “Function SEASONAL_LINEAR_REGRESSION requires argument 2 to be a positive integer”. What am I doing wrong? The metric where I’m using SEASONAL_LINEAR_REGRESSION has three dimensions (month and two non-time dimensions). What does “Dimensions of Text 1” mean?

929

8 months ago

DmitriiMaster Trendsetter

asked in Questions & Conversations

Month cohort number calculation

I want to calculate the month count starting from the first revenue month for each tenant. I am trying this formula:MONTHDIF(Tenant.cohort_invoice_M.'Start Date', Month.'Start Date')But I am getting an errorFunction MONTHDIF arguments have incompatible Dimensions: Dimensions of argument 1 must be a subset or superset of Dimensions of argument 2 How to fix this?Tenant.cohort_invoice_M has type dimension Month.

902

8 months ago

AravindApprentice Author

asked in Questions & Conversations

Changing data type of metrics

Hi All,I’m not able to change the data type of ‘User Roles’ metric from Role(local) to Role(Data hub). But when i try to change the data type, I’m getting the following error. Pls advise on this.“Unable to change the structure of a metric used in the security settings. Remove it from the security settings before performing this action.”How do i overcome this error?

431

8 months ago

EvlimeApprentice Author

asked in Questions & Conversations

I want to set up a dimension from a calculation

Hello community, I am creating a PnL report for our company. At the moment it displays revenue (metric), cost (another metric), gross profit ( metric from formula) and so on. The metrics are derived from a transaction table that I imported.Now I would like to show the total USD and in the coloumn next to it I want to display avg per person. I have calculated the Avg per person and managed to create the same table as above from the avg metrics of the above metrics. BUT because these are metrics, I cannot have them side by side in the table. If I add the avg per person to my total table it will just add all the rows below. I can move upp the “metric” in pivot to columns but then that messes up the revenue, costs, gross profit placement etc.I created a dimension called version and was able to attach that as a property to the total metrics and the avg metrics, but haven’t found a way to union the two metrics with the variant dimensions. So my question is, how can I create a dimension from

1023

8 months ago

Ta-WingAuthor

asked in Questions & Conversations

How to set up a Map chart - Exclude countries

Exclude CountriesI’m trying to show the Revenue by Country and where countries have nil/zero revenue, how would you Exclude them so even the name doesn’t pop up? I’m wondering is it because my main data set has all countries with the longitude/latitude.

1142

9 months ago

Sokhna Diarra NdiayeApprentice Author

asked in Questions & Conversations

Revenue Metric

Hello Everyone, I want create a revenue metric. I Create all the dimensions and transaction list. When I add a formula there is no problem of dimension, but the value are only in January month. But in my transaction list the Dimension Month is present. I dont understand why all the values are imported in only one month. Here is my formula ( 'Sales History Unit'.unit [By Sum : 'Sales History Unit'.month, 'Sales History Unit'.Customer, 'Sales History Unit'.'Product Group'] ) Thanks a lot

2007

9 months ago

Anonymous

asked in Questions & Conversations

companies change, profile stay?

Hi, I did have my profile on Pigment Community/Academy when working with another company and I'd like to assign this new to the previous to one to not to loose all my previous activity.How can I achieve this?Thanks!

991

9 months ago

ChahatMaster Author

asked in Questions & Conversations

Target metric with year dimension

I have a source metric ABC with dimensions: project and year of data type: numberneed to have a target metric with dimension year, current formula in target metric is :SUMOF(ABC)/COUNTOF(ABC), but i want year as a dimension too in target metric.currently, it doesnt have any dimension in the target metric.

2241

9 months ago

NahApprentice Author

asked in Questions & Conversations

Push data from Google Sheets Into Pigment

I successfully connected Google Sheets to Pigment. After initiating the data import from Google Sheets to Pigment, I receive a message indicating that the import was successful, but the data is not imported into Pigment and I get the following error message:"Missing column in CSV Some header(s) in the mapping configuration are not found in the CSV."However, the headers in the imported file are identical to those in the Pigment list.You will find the screenshots below.

1974

9 months ago

NeoAuthor

asked in Questions & Conversations

How to exclude inactive values in a dimension in Page dropdown

Hi Community,How can we exclude invalid values in a dimension from appearing in the Page Selector in Pigment? For example, we have some inactive project codes and cost centers that we’d like to remove from all dropdowns, but they still show up.I believe there’s an option to manually edit the Page Selector to exclude those codes, but that would require updating it on every board and repeating the process whenever new codes are marked inactive.Is there a cleaner or more efficient way to handle this? Thanks,Neo

1072

9 months ago

P_AgrawalApprentice Author

asked in Questions & Conversations

API Import Set up

I am working on setting up an integration between TeamOhana (headcount platform) and Pigment, which needs to be connected through an API request. Using this link, I have been able to set up the API connection and the action button to trigger the integration but I am unsure of where is the data getting pulled into? Do I need to set up a transaction list beforehand and then somehow link API request so the transaction data in Pigment gets updated? Essentially where is my data going if the API request result shows successful?FYI: It is Authentication: Bear <token> set up.

2992

9 months ago

abhilashsawlaMaster Author

asked in Questions & Conversations

Required Detailed example of Textlist Aggregator

Hi,I would like to understand Textlist aggegator in detailed.Where or how to use it in different - different scenario.

3344

9 months ago

Laurence TemamApprentice Author

asked in Questions & Conversations

Pennylane

Hello, we have an affiliate using Pennylane. Have you already implemented the API to import the general ledger into Pigment ? Thanks

871

9 months ago

Cedric LJMaster Author

asked in Questions & Conversations

Remove duplicate leads

Hello,I Have the below list of leads and I want to count 1 in the column Count only for the lastest lead of the company.The goal is to remove duplicate leads of my lead analysis.Thanks

731

9 months ago

Kamil SobczakMaster Trendsetter

asked in Questions & Conversations

Cancellation rate allocation

Hey team, I’m trying to get a dynamic metric where based on the age of added employees I can schedule cancellations as per assumed % however I’m getting an error I can’t solve. TMs_02_Employees_New is a basisCancelled Timing is a dimensionthen assumption and mapping schedule for months. Can you please help?

1394

9 months ago

venitiavMaster Author

asked in Questions & Conversations

2 scenario + 2 year variance

Hello,I am trying to have a P&L comparison with a scenario A on 2024 vs. a scenario B on 2025. Is it possible to have a column scenario A 2024, a column scenario B 2025 and a third column with the variance between both ? When I try to do it, I have 2 columns per scenario and per year and it’s hard to read. Thanks

2594

9 months ago

Page 13 / 42

Badge winners

Soumiyahas earned the badge Pigment Modeling Fundamentals Certified
Soumiyahas earned the badge Pigment Like a Pro
cconrad78710has earned the badge Pigment Modeling Fundamentals Certified
Hugo Cayer-Barriozhas earned the badge Read and Interpret Formulas Certified
RoryChas earned the badge Magic Star

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.