Explore the Community

Hi community,I built an org chart by project where one project has multiple people, and each person has an associated cost. When aggregating to the project level, I would expect to see the sum of the costs, but instead it shows FirstNonBlank, and there is no option to change this.In the grid view, the costs are summed correctly, but in the Org Chart, they are not.I’ve attached a screenshot for reference.Does anyone know if this can be fixed, or if this is a bug?Thanks!

When typing in a date as an input (i.e. a SKU ship date), currently you must include leading 0s (i.e. 01/01/2026). We would benefit from having the data input like Excel where you can simply type 1/1/2026 without the leading 0s. 

I have a metric with Budgeted Headcount at monthly level. I want to achieve the same metric at yearly level but the headcount at yearly level needs to be the headcount as of the last month of the year and not a summary of all months. Need help with the logic to achieve it.

Is there a trick to creating a blank row metric I can use as a spacer inside a grid or table. I am unable to save a metric with a space or special character as it’s name. Is there a way to hide the row header name?

Hello!  Is it possible to sort the view dynamically such that the Month would automatically change to the current month? 

I have a large transaction list that I sync in from Snowflake each day automatically. Today, I made a change and happened to start the new manual import configuration before the prior automatic one had finished. Pigment shows 2 imports running for the same list. Is there a way to halt an import in progress in this situation? The two running at the same time is significantly slower and in the future it would be nice to avoid this. It would be nice to have a page in the app settings that shows imports in progress (may exist, but I haven’t found it) and gives the ability to halt a job in progress.

I would like to write a formula where the intent is for the metric to calculate the average of the prior 3 months of the metric itself.I envisioned the syntax being something like the following, though it says MOVINGAVERAGE doesn’t support recursive mode.MOVINGAVERAGE(PREVIOUS(month),3)I understand that I could use MOVINGAVERAGE without PREVIOUS if the object being averaged was a separate metric, but the use case I have requires the formula to reference metric itself. Is there any solution or workaround for this?  

In the When to Use the Different Types of Widgets on Boards, this caption caught my attentionBEST PRACTICE“Only add Lists to Boards that Administrators and Modelers can access to avoid unplanned changes to your data structure.”Does this mean that if we publish Lists to Boards, anyone that can access the board can modify the data ?Or can we prevent Lists to be changed in the application ?“Use or Add Lists that ONLY Administrators and Modelers can access to avoid unplanned changes to your data structure.” 

In order to quickly and automatically create documentation, is there a way to display the description of all metrics used in a board or in a table?

Hey,Is there a way in Pigment by which we can do the following in the same grid/table:show “FY 2025 column header” for some metrics and “FY 26 ” columns for some other metrics

Following reading this page about how Pigment handles blank cells with metrics with different dimensions (How Pigment Handles Blank Cells), I have the following questions :What is the best practice to maintain both source metrics values (e.g. treating blanks as zeros from the metric with the most dimensions) ?e.g. if I want metric C to hold for Spain Metric A + Metric B = 5 instead of blank for Product A (in the case of different costs sources with different dimensions structures, total cost should always be A+B, not A+ depending whether A is not empty, add B) ? I make do with a simple Metric A + Metric B[Add : Country] Yet I wonder whether this would be the best option in term of keeping balance between performance + sparsity ?Another question : are there plans to modify this default behaviour in the future ?I ask this because it is kind of counter intuitive to account for metric dimensionality discrepancies when dealing with mathematical operations like + and - I creates an additiona

Hi community, I found the article Use Selectors to Customize Context in Views and Boards | Community (the last paragraph How Variable and Page selectors work together) and I want to do the same view for my PnL.  The idea is basically the same. I want to see first Actual, Budget and then dynamic FC version depending on page selector. After that I want to see difference between Bud and selected FC version. I didn’t figure it out how to do it.I’ve done the calculated item and linked it to the page selectors, but I can still see all FC versions and I don’t know how to hide them (=switch based on Page selector (as in original article)).Thanks! 

Hi Everyone,I am looking for a way to visually group and indent independent Metrics on a Pigment Board to create a hierarchy, similar to a traditional P&L view.The Setup: I have four separate Metrics, each calculated using its own formula: Other Operational expenses (The parent/total) Warehouse expenses Transportation cost Other expenses The Goal: I have added these four metrics to a Pivot table. I want to arrange them so they appear grouped together, with the sub-categories indented under the total, like this: The Question: Is there a way to achieve this visual "parent-child" grouping directly on a Board or Pivot table without creating an additional "Reporting" dimension or a mapping metric? I’m trying to keep the model lean and avoid manual maintenance of a consolidation dimension if possible.Are there any "Display" settings or Pivot configurations that allow for custom indentation or visual nesting of independent Metrics?Thanks in advance for the help!

Hi,I’m trying to set up an iterative calculation to use the PREVIOUSOF function to address a circular reference. However, in my application the setup doesn’t appear the same as described in the article “Iterative Calculations Across Multiple Blocks Using PREVIOUSOF.”Instead of showing options for Cycle Name, Iteration Dimension, and Metrics That Can Reference Each Other (as mentioned in the article), it only gives me the option to add an iterative calculation and asks me to select the Base Metric and Allowed Metric. 

I have a learning path within my profile. How can I remove it?

Can we integrate Pigment with Python 

Some of our users do a lot of scratch work in Sheet View. Is there a way to clear all those extra edits out and start from a clean slate?

Hey!I wanted to check if there are any plans to introduce a feature that allows aggregation by formula. Currently, we can aggregate metrics using options like sum or average, but what if we want to display the value calculated by a formula at all levels of the hierarchy? I’ve seen some previous workarounds in the community, such as displaying the metric as a percentage value, but I’m curious if this functionality is expected in the near future.Thanks! :)

Hi teamJust wondering if anyone is facing the same issue. I was able to clone data from version to version (e.g Live Forecast → Forecast Q1) across all scenarios (Default, Optimistic...) but now the clone function only works on Default, and there is no other way to for to select different scenario.I already tried toggling the scenario selection in All Blocks but it isn’t working.ThanksNeo

Hello Pigment community,Is there a way to ensure that Pigment boards automatically adjust to different screen sizes and aspect ratios, so that grids, charts, and other elements remain properly aligned without gaps or distortion?Thanks!

Can we publish the Predictions function on a board?

Hi,I want to be able properly forecast the growth rate through time. Right now for Software, we select what month we’d like to grow the monthly cost and by what %. I’d like the formula to work as following:If the month is in an actual period, don’t grow the software period until the following year (example: if we had a software planned to grow in January, for 2026 we wouldnt see any growth but in January 2027 we would see the growth rate).Right now we have a super complex formula that really slows down the model:  is there a more simplified way to calculate a growth rate %? Below are screenshots for an example calc based on the formula above: thank you in advance for all of the help!