Unanswered questions

Hello, Currently I have my sales forecast by SKU and Month. I added to it, the “Switchover date” from Actuals to forecast to have some versioning. Now, I want to import this metrics to another metrics to only have the final version of the sales forecast for each “Switchover date”.  However, we I try to import the forecast for a new “Switchover date”, it only update the values and do not create a new version for the new “Switchover date”. So, how could I create each time a new forecast when the “switchover date” changes? Thanks for your help!Ben

Hi everyone,Has anyone come across the need to sum data across different slices?We have three separate entities, each forecasting under a different scenario (as shown in the table above). We’d like to sum these three combinations together, but we haven’t been able to do this using the Sum function on the View/Board or Add Calculated Items (as it only allows adding two items instead of three)Would really appreciate any advice if you’ve solved something similar.CheersNeo 

Hello,I am preparing input metrics to be filled in by the sales reps for the forecast.In the process they must allocate the “Fit Option” based on percentages by Model.However, for the model “A4”, “B4” and “C4” they can only fill in the “Fit option” “A “or “B” and for Model “D4” and “E4” it is always “3”.So, I was wondering if there is a way to:Only show A and B for Model A4, B4 and C4 and 3 for D4 and E4? Can I automatically fill in 100% for model D4 and E4 option “3”? Is there a way to highlight that each subtotal by model should be equal to 100%?Thanks for your help!Ben 

Automatically manage MTD / YTD / FY time aggregations, together with organisational / consolidated aggregation, for the following data types: “Stock” type – MTD: monthly value, YTD: same as MTD, FY: value of the last forecast month of the year “Weighted average” type – MTD: monthly value, YTD: average of YTD months (excluding blank values), FY: average of the 12 months of the year “Volume” type – MTD: monthly value, YTD: sum or average from the beginning of the year, FY: sum or average over the full forecast year “Calculated” type – calculated based on other data from the same period or from other periods; the metric must follow the Monthly formula logic “Variance” type – calculated as the difference or percentage change versus the selected comparison scenario

Within a single report, display a “Monthly” view limited to the main version  (current Fiscal Year - FY) only (i.e. no monthly view for prior years), together with MTD / YTD / FY / YTG views for three other versions (N-1, Budget, latest Forecast), as well as variances between the current FY and each of these three scenarios (i.e. no variances between those versions themselves, only versus the current FY) Considering the requirement above, manage version labels appropriately by displaying business-friendly names instead of technical names, while also allowing users to dynamically select the versions to view and compare within the report Use selectors rather than dedicated version selection tables for each version displayed in the board

Good afternoon,Is there a way to exclude ‘old’ months from the available items in page selectors? Currently I have a P&L that uses a dynamic variable (‘latest month’) as a source for the YTD calculation in a calculated column. Users can change the value of this variable in their sessions. Like so:  I have my month dimension in the page selector and set the default as the dynamic variable so that the P&L is automatically filtered on the latest month. But the ‘problem’ now is that the visible page selector shows all the available months but I want to limit this to only the last year and current year only. Is there a way to limit the page selector options to only the recent months while keeping the dynamic variable for the YTD calculation intact?  

Does Pigment support scoping an MCP API key to specific applications, instead of to the entire workspace? I understand that MCP only has access to AI enabled metrics, but some apps I want enabled for MCP and others just for native Pigment AI functions.   

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!

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.

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

If we restore an application, can we play around with the Analyst AI/Modeler AI in the recovered application in silo so that we can have a test environment to learn how to use the AI agents and to work on new features? 

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.

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?

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

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

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?