Unanswered questions

I currently have a table with months and years in the columns and metrics in the rows. I want to have a YoY% appear as a column after each year for all metrics. i.e.    FY26 | YoY% | FY27 | YoY% |Is this possible and if so, how to I go about it?

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  

Hello,I have a question. Hope you guys can help me out. I have a metric dimensioned on week, business unit and version. This is calculated from a TL that is being continually and automatically updated from the source system. However, I would like to ‘freeze’ this data for specific versions. For instance, at this moment in time I would like to freeze the metric for the budget 2026. Later on (in a couple of months) I want to freeze the data for the first forecast of 2026 (but leaving the data for budget 2026 untouched of course). I was thinking along the lines of using a M2M import, but I can't seem to work out a scalable solution on how to import only item A and not item B of the same dimension. Maybe using data access rights? Thanks for your help.Best, Bas 

Hi Pigment - would you please share the difference between Previousbase and Previousof. They look the same from the documentation perspective. Thanks,Louie

Can we integrate Pigment with Python 

Hi,Is there a way to create a master button to import data in mutiple metrics at the same time instead on having to click 20 times (20 metrics) on each import data button ? Thanks for your help

I am trying to export pigment data to PowerBI following the guided steps available on community, but I get an error “404 id not found”. Does anyone know what I could be missing in the setup? I used payload functionality to generate ID for metrics. 

I have a Calendar folder in [01] Data Hub app. As I create additional related apps should I create a new Calendar in each? I know I can open the Data Hub dimension to be shared  Can I dimension-chain my way back to the Data Hub time dimension’s properties? I use the Data hub Time period lists in the structure (dimension format) of Metrics in the related apps, can I reach data hub propts in formulas? 

I want a table that has costs actual ytd, costs budgeted ytd, costs ytd variance, costs full year budget, and costs YTG (i.e. total year budget less actuals YTD).However, my budget is captured as a scenario snapshot. Is this possible?

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

I need help fixing a mission for a variance analysis agent.  I am attempting to make it as dynamic as possible, so I am using a variable called @CurrentMonth which is a calculated metric that pulls the most current month we have transaction data into all my scenarios.   The calculated value for the @CurrentMonth variable for my @Actuals scenario is “0ct 25”.  I have another scenario called “Working Forecast” that has a calculated value of “May 25”.When I run this AI agent, no matter how I write the instructions, it uses the value of “May 25” which is nowhere in the instructions, not even implicity.The only way this works is if I change the variable for @CurrentMonth to be hard coded as “Oct 25”.What am I doing wrong? How would you change it?Mission instructions below,Analyze @Revenue and @Operating Expenses metrics, filtering for: Reporting Time = "MTD" @CurrentMonth  = @Actuals scenario Structure the report in these sections: Conclusion: Summarize the main findings. Key Highlights

In Pigment, we can display the history of a metric (e.g., a cell change by dimension intersection, inserted value). I’d like to know if there is an API that can return this data

Hi,Is there a way to query Snapshot Metadata via API? As I understand every snapshot of an application is a separate application, but when I retrieve Metadata using this post by ​@DamianAtPigment I only get live applications. In API docs I don’t see that I can configure Snapshot or Live, but maybe I’m missing something.Why you might ask? I would like to automatically extract data from the same metric via API, but from different snapshots to show and monitor historic changes. I know that I will have to use text comparison to extract the metric by name, but that’s ok.Thanks!

We are experiencing that if we save a copy of a Google Sheet with Pigment Connector connections, we lose the connections in the copied sheet.  We just want to double-check if there's a way to maintain connections in a copied sheet or is it perhaps on the radar to be supported in the future?  Thank you!

I love the concept of the Prettify Formula, but I don’t love the logic it uses. Having spent a bit of my earlier career in software development, I realized a few things that made my code more readable.When doing if logic, I want the comma separating the logic test and true result placed on a new ling and indented to just past the opening “(“. I do this so I can easily trace where logic changes happen.. and it is a little easier to comment things out or copy/paste into the formula playground for testing.if(Month.’Period Type’ = ‘Period Type’.”Actual”   , Data.Amount[by: Data.Month, Data.Entity]   , previous(Month) * 1.01)For simple formulas, I typically won’t break a line. For formulas where there is a long set of modifiers, I will line break the modifiers and indent them 2 or three spaces past where the previous modifier starts. I don’t need to break each modifier; just enough to fill up a line, as I don’t want to have too many lines, which makes troubleshooting challenging if I have a

Hello everyone,I have created a Clone data in metrics set up on my application settings but when I go to the board to add the action button the Clone data in Metrics form does not appear to let me choose what i want to copy and where..Basically i can only use one preset configuration into the app settings. Am I loosing a step? I also see in the documentation that is clearly possibile but I can’t manage to set it up;Thanks in advance, community, for your help! :) 

Hi We have a scenario where we need to get Grouping data from members management into Users dimensional list.We did grouping based on different roles and permission and We need to get this grouping data based on each user in the members management into User dimensional property.Do we have any option to achieve this? 

When using Pigment Connector in gsheet the date formulas are imported as text