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

836 Topics

Most replies

Most views

Newest first

pigment_enthusiastKeen Learner

posted in Questions & Conversations

Highlight the Totals number at each hierarchy level in a grid/table

Follow the steps if you want to highlight your totals:Select the header cell of the row which you want to highlight/color code Click on “arrow” icon dropdown and “Format” Choose “Cells” tab in the mini dialog box and select “Every Instance of my Selection” in the “Apply To” field Choose the color and Border ; select Apply and now all the totals at each hierarchy are highlighted!

12 days ago

Ta-WingNewly Minted Pigmenteer

asked in Questions & Conversations

How to show legend text wrapped in chart

Is there an option to wrap the text of legends in a chart so that it doesn’t get trimmed like the example below?Should be reading “Actuals & Forecast”.

1241

12 days ago

Krete J.Just Arrived

asked in Questions & Conversations

Remove not Filter Blank cells?

Ideally in the metrics we could remove 0 metric values if it is ok with the analysis to remove those cells[FILTER: Currentvalue<>0]Also usually we add the “Hide empty rows and columns” - but is there possible to remove those empty cells by formula? Or does it give something regarding performance wise?

301

13 days ago

Ta-WingNewly Minted Pigmenteer

asked in Questions & Conversations

AI Enable metrics

HiDoes enabling AI for all boards slow down the performance?There is an option to enable all blocks for AI at a click of a button but when it comes to switching it off, you need to do it one by one, is there an option to switch off AI for for all blocks in one go?

321

13 days ago

pigment_enthusiastKeen Learner

asked in Questions & Conversations

Shared Scenario Usages

How to check the usage of a shared scenario?

391

14 days ago

MohanBudding Pigmenteer

asked in Questions & Conversations

Equivalent of Vlookup to return values in number or integer format

Hello, I am trying to perform a vlookup function where I would like to retrieve a value from a transaction list and return to a dimension with same number format. I want to extract the “Weeknum” from Transaction : Calendar Weeks based on unique property Calendar.Date and populate it in under the Week Dimension’s property “Weeknum” based on its unique property Start DateTried ITEM function but i get a lot of data type errors using this formula , ITEM('Calendar Weeks'.Weeknum,Week.'Start Date') thanks

692

14 days ago

DastanSeasoned Pigmenteer

asked in Questions & Conversations

Adding empty rows in Tables

Hi Pigment team, I’m trying to add empty rows into my Table block, so that I can separate some categories of expenses from each other: I tried to create and add empty “Placeholder” Metric, however it requires a name and I can’t simply leave it empty. Is there another way to add such empty rows between items? Best,Dastan

4197

18 days ago

OttJust Arrived

asked in Questions & Conversations

Automated task for "Delete User Inputs in Bulk"

Hi Is there a way to Create Automated task which deletes user inputs in bulk when trigger is met. I’d like to set it up in a way, than when Month becomes from Forecast to Actual, it would delete the new Actual month user inputs which were so far meant for Forecast, but Actual month value should come from formula. I know how to set up task to notify, once this month changes and also how to set up one-time bulk deletion, when Month becomes Actual, but is there a possibility to combine these to so I could stop being middle-man? Best regardsOtt

461

19 days ago

Xia HeNewly Minted Pigmenteer

asked in Questions & Conversations

Unable to find the block to complete the activity

532

19 days ago

LASJust Arrived

asked in Questions & Conversations

How to Dynamically Sum the Last N Months of a Metric

I have a single that needs to essentially aggregate a rolling sum (of that last n months) of another metric. The manual method I have found is:TargetMetric + TargetMetric[SELECT: Month -1] + TargetMetric[SELECT: Month -2](I am incuding the current month in the “last” three months calculation)But if I want to change this to the last 5 months or the last 24 months, I would need to add an n number of selects.How Can I formulaically drive this calculation?

622

19 days ago

Fabien BigeardNewly Minted Pigmenteer

asked in Questions & Conversations

Sort / Ascending-Descending

Hello,I want to sort a table by descending or ascending, depends of my metric value. I don’t succeed. could you help me please ? Thank you in advance. Best regards.

4292

21 days ago

Spandan98Budding Pigmenteer

asked in Questions & Conversations

Display only the unmarked options

Hello Pigment Community,I need help with automating calculations for specific brands in Pigment. Requirement: For the brands marked (e.g., checked/true), I want Pigment to automatically calculate the values. For the unmarked brands (e.g., unchecked/false), I want to manually input the data. Goal: I would like to filter the view to display only the unmarked brands (those marked as false), so I can easily input data manually. Thank you for your help.

241

21 days ago

Daniel CicakNewly Minted Pigmenteer

asked in Questions & Conversations

Planning Best Practices - Versions & Import via API

Dear Community,we are currently within our FY24 budgeting process. We have the standard setup with Headcount-App, OpEx-App & Topline App.Topline-App & HC-App are connected with source systems with daily uploads to have a proper reporting in place. OpEx-App is manual input only. To avoid that managers have to incorporate changes (Forecast & Budget 24) in two Versions we use our Forecast Version only. For Budget Versioning we copy a Forecast Version as Budget Version 2024 VX.We face the challenge, that the imported data will change our Budget Versions VX as well. A first idea was to take snapshots of the application and connect the Version of a snapshot into the Core-Reporting, but not sure if this is possible? Or does anyone have any other idea how to lock the data without stopping the imports? BR,Daniel

4914

21 days ago

William Murray BrownBudding Pigmenteer

asked in Questions & Conversations

Cannot deactivate library due to block being used... But block usage says it is not used.

I’m trying to deactivate this library:Deactivation is disabled because the “P1 Brand” block is in use... But when I click “view”, it doesn’t show any usage in the application where I’m trying to disable it:Can anyone help with figuring out why the block is showing as used?

402

24 days ago

MisbahFrequent Reader

asked in Questions & Conversations

Queries related to Pigment

Pigment Champs! Could you please help me understand how Pigment is handling DevOps (Or is it still not available)? Is there any Best Practice document on Pigment (Like Planual in Anaplan)? I see many Pigment sponsored apps have hardcoding in the formula. For Example - As Per Pigment: 1+ INP_YearlySalaryIncrease[BY CONSTANT: Month.Year][FILTER: Month.'Month of Year'= 'Month of Year'."February" ][BY CONSTANT: EE_Data_Stand.Region] I want to write it this way - (1+'01. INP Yearly Salary Increase')[BY CONSTANT:Month.Year][FILTER: Month.'Month of Year'= '00. INP Month of Increase'][BY Constant: 'EE Data Stand'.Region], here the inputs can be changed easily and freely. How does Pigment’s engine perform calculations? How many cores does it leverage at the same time? Is there any recommendation about the source data, that it should have a unique key? I understand that transactional dimension does not need one but it means that you would have to delete and reload/refresh the entire transac

2767

24 days ago

MaxenceGoigNewly Minted Pigmenteer

asked in Questions & Conversations

Impact of CSV Uploads on Historical Data in Pigment

Hi,We have a data table on Pigment that we update daily with new data by uploading a CSV file.The CSV contains data from January 1, 2021, and every day the new daily data is added to the file before being uploaded to Pigment.I wanted to know if CSV uploads delete the old data and then completely update everything, or if they only push the new data.For example: If tomorrow the file no longer contains data starting from January 1, 2021, but instead starts from January 1, 2022, will we still retain the 2021 data in our source list in Pigment when I upload this new file, or will it be deleted?If the historical data is deleted, is there a way to push the new data every day without deleting the old one?Thanks in advance!

411

25 days ago

Bill RauschBudding Pigmenteer

asked in Questions & Conversations

Link to Data Import on Board

Is there a way to get a link that I can put on a board to get to the Import Data screen?

3812

27 days ago

Jessica TNewly Minted Pigmenteer

asked in Questions & Conversations

Conditional formatting

Hello,Can you please tell me how I can make a conditional formatting based on another column? Ex: I have column A & B and I want column A figures to change colors depending of it they are greater or lower than column B figures.Also, how can I center figures in a table on Pigment, if that is possible. Thanks.

3774

27 days ago

adhainOccasional Observer

asked in Questions & Conversations

Notification when a change is made

Hi All!Is there a way someone can get notified when a change is made automatically?In headcount planning, we want the HR director to be notified when someone has requested a new head. I appreciate there’s the option of writing a comment, but wondered if theres an automatic way?Thanks

1104

27 days ago

Spandan98Budding Pigmenteer

asked in Questions & Conversations

Data Access rights for specific columns in Pigment

Dear Pigment Community,I hope you're doing well!I am currently facing two challenges in my Pigment setup and would greatly appreciate your guidance: Freezing Data Entry for Weekends & Holidays: I would like to restrict data entry for weekends (e.g., 06/01/2024 and 07/01/2024) and holidays (which I will updating in a different dimension) while keeping data entry open for other days. This restriction should apply consistently for all weekends throughout the year. Customizing Date Formats in Column Headers: I want to display the date in the column header in the format: 6th Jan 2024 and 7th Jan 2024 (instead of the default format). This format should be applied consistently across all dates throughout the year. If anyone has suggestions, solutions, or best practices for implementing these features, I would greatly appreciate your input!Thank you in advance for your help!

381

1 month ago

Spandan98Budding Pigmenteer

asked in Questions & Conversations

Date and Employee Mapping in Pigment

Hello Pigment community,I want to map the two tables such that I can map the sales of manager mapped according to their end date and start date, and list their sales according to the employees under them.I am attaching the assignment screenshot below, please kindly help me.Thanks!

261

1 month ago

AdamOccasional Observer

asked in Questions & Conversations

Circular adjustment

Hi, I have the following challenge:Metric 1. simple metric with sales forecast in units with one dimension only MONTH. So let’s say it is Jan: 20; Feb: 30; Mar: 20; Apr: 15 Metric 2. active orders already made e.g. 35 with no dimension at all, just one number. Now I need to adjust Metric 1 with Metric 2 applying the rule that earlier months are adjusted as first. I.e. adjusted forecast would be: Jan: 0; Feb: 15; Mar: 20; Apr: 15How do I do it in Pigment? Regards,Adam

521

1 month ago

Spandan98Budding Pigmenteer

asked in Questions & Conversations

Creating a working calendar with holidays marked in Pigment

Hello Pigment community,How can I create a working calendar with holidays marked as the attached image below.Please kindly help me in this project. I hope you will do the needful. Thanks!Thanks!

283

1 month ago

Isabella Leslie-MillerCommunity Manager

published in Welcome to the Community!

Pigment Community Badge System 🥇🥈🥉

On this page we outline how you can obtain specific badges 🥇Our badges are designed to award different kinds of contributing to the Community. We want to ensure our members receive recognition for their activity and have something to show for their efforts. Badge Name Criteria Author Posts (question, conversation, article): 5 Rare Author Posts (question, conversation, article): 15 Magic Author Posts (question, conversation, article): 60 Legendary Author Posts (question, conversation, article): 120 Helper Answers: 1 Rare Helper Answers: 10 Magic Helper Answers: 25 Legendary Helper Answers: 100 Chatterbox Replies: 10 Rare Chatterbox Replies: 25 Magic Chatterbox Replies: 100 Legendary Chatterbox Replies: 250 Connoisseur Likes given: 10 Rare Connoisseur Likes given: 50 Magic Connoisseur

4603

1 month ago

Spandan98Budding Pigmenteer

asked in Questions & Conversations

Count number of duplicate items in metric

Hello Pigment Community,I’m currently facing an issue with counting duplicate items in Pigment. As shown in the image below, I’ve successfully extracted words from a sentence. Now, I’d like to conditionally format and highlight repeated words starting from their second occurrence.I understand that using a counter to track how often a word appears is key here, but I’m struggling to come up with the correct formula to achieve this.Could someone kindly guide me on how to proceed? Your help would be greatly appreciated!Thanks in advance!

421

1 month ago

Page 2 / 34

Badge winners

Stéphaniehas earned the badge Read and Interpret Formulas Certified
Laszlohas earned the badge Pigment Like a Pro
dovilehas earned the badge Innovator
dovilehas earned the badge Pigment Modeling Fundamentals Certified
Abhayhas earned the badge Pigment Like a Pro

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.