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

LouieAuthor

asked in Questions & Conversations

Dimension lookup

Appreciate your assistance here.... The left screen is the CVS loaded PnL Acct dimension and the right screen is NetSuite Integration. The Coln dimension 'FP&A Category Override' is a user manual input. Is there a way I may do a 'vlookup' in the new table so that we don't have to manually map it again.

2022

11 months ago

SuzzyAuthor

asked in Questions & Conversations

How to make negative amount zero

Hi Team, I have an existing formula for moving average, however I want to add another condition that if the moving average is negative, then the result should be zero.This is my formula right now:IF(Actual?,MOVINGAVERAGE('Actual',3),PREVIOUS('Month))Can you help me how can I add my new condition in this formula? Thank you!

961

11 months ago

venitiavMaster Author

asked in Questions & Conversations

Interns who are converted to permanent contracts

Hi,Do you have a best practice to recommend on how to manage interns who are converted to permanent contracts (=CDI in France) in Pigment?When a trainee is converted to a permanent contract, he keeps the same ID in Workday, which means that when Workay connects to Pigment, and as we base Pigment with the IDs : Pigment doesn't “see”that he no longer has an end date that he has changed contract type that he has a different salary and Pigment doesn't count him as a headcount. My temporary solution is to change the intern’s ID (so I have 1 ID for the intern and 1 ID for the same guy with a permanent contract) but this is very manual, so I was wondering if you had any advice.Thanks

921

11 months ago

VikatzenTrendsetter

asked in Questions & Conversations

SaaS Revenue Model

Hi All, I want to start building a simple saas revenue model in Pigment, with basic assumptions such as type of subscription, cost, number of new customers, churned customers, cohorts, cohorts age, retention rate, etc.Looking for ideas and suggestions from the community of where to start, what kind of recommendations you have, which metrics/dimensions should I use. Any recommendations or examples would be highly appreciated!! :)

1731

1 year ago

ChahatMaster Author

asked in Questions & Conversations

Filtering based on two text properties in dimension list.

In a dimension list, if we have a property of Text format, the only filtering options are:Is Not Contains is not blank is blank does not contain isRequirement: If I have two properties ; both of them are of text format, there should be an option to filter the dimension list based on these two properties i.e. Property 1 != Property 2.I believe, although we can create another property in the dim list for validating this with the above formula, but it would be great if we can have a filter for the same.

561

1 year ago

SuzzyAuthor

asked in Questions & Conversations

Formula for average of specific months

Hi Pigment Community! I’m trying to create a Metric wherein if Actual Months, it will get the Actuals Details, while if Forecast Months (starting January 2025) it will get the average of January to September 2024 Actuals. Then for October to December 2024 it should be zero or blank. What is the best formula for this?For context:January to September 2024 - from my Actuals metrics October to December 2024 - zero January 2025 onwards - average of January to September 2024 I also set up a boolean for the months of 2025This is my initial formula:IF(Actual?, ' Actuals' , (IF('Month.’2025’,…. I should put here the formula for the average, then if it is not 2025 it should be zeroThank you in advance for your help!

1421

1 year ago

SuzzyAuthor

asked in Questions & Conversations

Combining Actuals and Forecast with Different Dimension

Hi! I’m currently working on a table where I need to combine my Actuals and Forecast. For context, these are the dimensions available:ActualsVendor GL Account Country Currency MonthForecastVendor Name GL Account Country Currency Month Project DetailsI’m having an issue because when I combine them, the Project Details dimension is being applied to every Vendor in my Actuals. Is there a way that I can combine them without removing the Project Details? We still want to see it especially if we don’t have an actual vendor yet. Thank you in advance for your help!

1051

1 year ago

SuzzyAuthor

asked in Questions & Conversations

Combining Actuals and Forecast with Different Dimensions

1505

1 year ago

A_GarneriAuthor

asked in Questions & Conversations

How to identify duplicated unique items on a Dimension List?

Hello Pigment!We have a board where the end user can create new items using the 'Add List Item' action. If the user creates an already existing name, is there a way to identify which items are duplicated? or even avoid this? The alert in the app only directs me to the list but not to the duplicated itemsRegards

821

1 year ago

A_GarneriAuthor

asked in Questions & Conversations

Axis labels: any way to improve them?

Hello Pigment!I am currently working with some charts for a board, but I encountered a issue: the axis labels are showing very random values, based on the values I have available: “95,671,103”? why not 95,000,000/96,000,000?“86,103,993”? why not 85,000,000/86,000,000?My first solution was to set the left axis labels to millions, so the information would be clearer:The problem occurs when I apply filters or use the selectors on my board and my values drop below millions; it shows decimals or even just 0: Is there a way to make it dynamic and recommend more appropriate values?Thanks in advance

4431

1 year ago

TatianaWallflower

published in Company News

🎊 Congratulations to our August 2024 Pigment Academy Champions! 🎊

Dear Pigment Community,We continue to publish updates on our Pigment Academy champions to recognize their outstanding achievements and award the Pigment Academy Badge 🏆We’re excited to announce our top performers for the month of August: 🏆 Top 5 Active Users by Course Completions:@Mayur Sejpal : 45 completions Estelle Ribardiere: 42 completions @lukadadic : 41 completions@Johnson Akinpelumi : 40 completions Justin Victor: 36 completions Congratulations! Your hard work is truly inspiring. We're looking forward to celebrating more achievements in the coming months!

1221

1 year ago

A_GarneriAuthor

asked in Questions & Conversations

CUMULATE on Multiple Dimensions (Using "on" operator), based on Ranking Metric

Hello Pigment!We trying to cumulate values on 1 metric based on ranking, but this metric has 2 dimensions on its structure (Customer, Region), so we have the Ranking Metric and To Cumulate Metric, ex: Region (Dimension) Customer (Dimension) To Cumulate (Metric) Ranking (Metric) Cumulate on Rank (Metric) 1 C1 50 5 148 2 C2 20 2 30 3 C3 30 3 60 1 C4 80 6 228 2 C5 110 9 513 3 C6 90 8 403 1 C7 85 7 313 2 C8 38 4 98 3 C9 10 1 10 The current issue its if we try to do that using CUMULATE, we can only set the accumulation through 1 dimension (either Customer or Region) and using 2 cumulates at the same time seems not to be the solution so farAny recommendations? Regards,Agarneri

1312

1 year ago

Moosa MalickWallflower

asked in Questions & Conversations

Locking Version

Hi,I am trying to build a forecast in Pigment which can have multiple versions. Is there a way, we can lock formulas in versions? I know there is a scenarios feature, in which we can have formulas for different scenarios. Are scenarios the preferred way of versioning in Pigment? Thank you

3275

1 year ago

CDALMAYMaster Helper

asked in Questions & Conversations

Change in Fiscal Year once live

Hi community,Has anyone successfully changed the fiscal year for a customer after they've been live for some time?I have a customer who has been live for two years with a fiscal year aligned to the calendar year. However, starting next year, they are shifting to a fiscal year that begins in February. This means Fiscal Year 2024 will run from 01/01/2024 to 01/31/2025, creating a 13-month fiscal period.As a workaround, I considered manually updating the mapping between months and fiscal years to set January 2025 as part of FY24. However, these properties are protected, so I'm looking for alternative solutions until this feature is implemented.I want to keep the past fiscal periods unchanged, so FY23 should remain as 01/01/2023 to 12/31/2023.Thanks for the any suggestions or ideas.

720

1 year ago

A_GarneriAuthor

asked in Questions & Conversations

It is possible to rename selector/slicers on boards?

Hello Pigment,We name lists and their properties according to a specific nomenclature based on the purpose of each list. For example, if we have 2 lists of "Master Data," the first list is called MD01 Master Data List 1, and the second would be named something like MD02 Master Data List 2 and so on.The problem is that these names are not very attractive for the front end. However, on the back end, they are crucial due to the structure of our apps. In the slicers or selectors, the list name with its nomenclature appears, and it’s even more cumbersome if we are using any property of the list as another selector. For example:Selector 1: MD01 Master Data List 1: (ITEM)Selector 2: MD01 Master Data List 1 > MD02 Master Data List 2: (ITEM)Is there a possibility to rename them?Thanks in advance.Agarneri

512

1 year ago

dariousMaster Trendsetter

asked in Questions & Conversations

Aligning Metrics Across Applications: Handling Different Time Dimensions in Pigment

Hi Pigment Community!I'm currently facing a challenge and would appreciate your advice.The Issue:I need to combine two metrics from different applications to create a comparison view for my users. Here’s the setup:App 1: Holds the visual displayed to users and includes a metric titled “Actual & FCST # SQL -> SQP - NBiz.”App 2: Contains a metric titled “# FCST SQL by SQL date - NBiz.” This metric has been shared with App 1, so I can access it there.The problem arises when I try to bring these two metrics together. Since the applications have different time dimensions, I end up with two sets of time dimensions in my final metric, causing the values to not calculate correctly.Additional Context:I've separated the time dimensions in these applications because they have different period lengths.However, the specific data I want to combine should fall under the same period of time.Possible Solutions:I’m considering using the remove modifier or specifying [by: month] to align the metri

1451

1 year ago

BenedikteAuthor

asked in Questions & Conversations

Apply default formatting specified to a role

Hi,I am looking for a solution to create a default filter specifically per user. Today we work across different countries and would like to set default filter per board per person so that Person A see country “Finland” as default and Person B always see country “Germany” in the same board. Any suggesting on how I can implement this?Would really appreciate you help on this topic:)Kind regards, Benedikte

792

1 year ago

ChahatMaster Author

asked in Questions & Conversations

Updates/ History for formatting

Can we see the history/updates of following:formatting done on table’s metrics Aggregators applied on tables

1381

1 year ago

Ramana ReddyApprentice Author

asked in Questions & Conversations

Transactions Bulk Delete

Hello Everyone, I am new to Pigment and started with training recently. I came across a scenario where I had to delete a few items from the transaction list and realized the only option we have is manually selecting them and delete. Is there any way/action that we can create pointing to a Boolean metric which holds TRUE for delete items (with a formula) and whenever we run that action, it will delete those specific items (We can think of deleting a specific months data)Please suggest.Thanks,Ramana

2132

1 year ago

A_GarneriAuthor

asked in Questions & Conversations

Aggregation Cells on Tables with metrics that uses multiple Dimensions

Hello Pigment!We have some scenarios where we use multiple Metrics with different dimensions on the same table, ex: This table has Products and Month on Rows, Metrics as columns. Metrics structures below:Metric Dimensions Formula Product Demand Product, Month - Vendor Product Products.Vendor Planner Product Products.Planner We are aware that a possible solution could be adding “Month” dimension on Vendor and Planner metrics then add “[ADD CONSTANT: Month]” at the end of their formulas, this would lead us to our desired shape: However, this might not be the ideal solution; we do not need to be “calculating” Vendor and Planner every Month, for every Product, since those are properties which are not changing at all (not monthly, weekly, at least). Our apps are quite big, that is why we are trying to avoid that.There is a workaround? Also, there is a way to omit the “Total” rows/columns at all?

1202

1 year ago

Ronit_SWallflower

asked in Questions & Conversations

Changing calendar settings

Hi,I’ve bullied an app and set up the calendar and set the start month to January. Now that everything is set up we want to change the start month to February . Is it possible?Thanks

7966

1 year ago

Jacques d. S.Apprentice Author

asked in Questions & Conversations

Filter by views in a board

Hello, For our monthly reporting we would like to filter by views in the boards we have, is it possible ?For exemple, for our revenues or COGS, in a same metric we have views by clients, countries, cohorts… and we would like to have filters based on these views in our reporting boards.Thank you for your answer. Jacques

702

1 year ago

dariousMaster Trendsetter

asked in Questions & Conversations

Add "Month" to "Month of Year" without aggregation

Hi Pigment Community,I’m working on building a forecasting model and have encountered a challenge that I could use some help with.The core of my model is based on using the "Month of Year" dimension to allow users to input information. However, I now need to incorporate the "Month" dimension for a specific year, which I want to select using a switchover date.The issue arises when I create a new metric and add the "Month" dimension. After filtering for my designated year, the metric aggregates the total values across all columns, leading to an incorrect result. Essentially, the metric isn't giving me the precise data I need.You might wonder why I didn’t implement the "Month" dimension from the start. My goal was to minimize the work required to maintain and update the model as we transition into a new year. In my current setup, the user inputs values for the "Month of Year," and I planned to assign these values to the desired year later, based on the switchover date.My main question is:

1894

1 year ago

Olivia Van Gerven

asked in Questions & Conversations

By Modifier "-> "

Hi, I have a metric with 3 dimensions: Quarter, Products & Employee. I also have a transaction list with the following infoSale XYZ - in Q1 24 (dimension Quarter) - Productclass A - sold by John (dimension employee) - previous product seller is Anna (dimension employee)Sale FMG - in Q1 24 - Productclass A - sold by Maria - previous product seller is John In my metric with dimension quarter, product, employee I am calling in all product sales, but I assign them to the previous product owner so something like [by: -> sale.product.previousseller]. However, in this way all sales get assigned to the last previous seller, whereas I want to assign the sale from John → Ann and the sale from Maria → John because they were at that point in time the previous seller. How can I do this? Thank you very much in advance

971

1 year ago

Antoine-2Master Author

asked in Questions & Conversations

Merging Dimensions Across Applications in PIGMENT

Hi I would like to merge all the items from 2 dimensions of 2 distinct applications in PIGMENT into a new dimension. Is this possible, and if so, how?To give a bit of context, I have an existing application that tracks ongoing projects and those planned for the next two years (updated via an import), and I would like to create a dedicated application allowing users to submit their project requests for the next 2 to 6 years.These requests will be subject to prioritization, and not all will be carried out. Therefore, I would like to distinguish between confirmed projects and future project requests by creating 2 distinct dimensions. However, in the end, I would like to merge them into a single dimension to facilitate analysis of all projects.Thank you in advance for your help.Have a great day,Antoine

1882

1 year ago

Page 16 / 42

Badge winners

ThierryGThas earned the badge Pigment Like a Pro
ThierryGThas earned the badge Pigment Modeling Fundamentals Certified
liuhas earned the badge Partner Solution Consultant Certified
ccifuenteshas earned the badge Pigment Modeling Fundamentals Certified
Filippo Rossihas earned the badge Read and Interpret Formulas 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.