Questions & Conversations

I have an integer dimension by month, vendor, and function that has “1” if that vendor was employed in that specific month. How can I cumulate but reset if the employment is blank? I.e. some vendors are employed for 3 cumulative months, then take a 7 month break, and come back for 2 months so I would want the respective values to show 3 cumulated and then 2 cumulated. Thank you!

Hi,I’d need some help to better understand how i can return per employee the average salary of its departement.Thanks 

Hi Pigment - If the dependency is the previous month end inventory, why do we use the incoming order in the formula please.Thanks,Louie 

Hello everybody,Does anybody know if it is possible to use scenario's as an incremental effect to the default scenario? For my use case: I have a default scenario where my users are inputting their baseline forecast for the coming months/ years. I would like for them to be able to also model the associated risks & opportunities as incremental effects to that baseline forecast. So, basically: default scenario + opportunities = best case scenario. And; default scenario + risks = worst case scenario. And: default scenario + opportunities + risks = realistic scenario. I have tried copying scenario inputs from scenario A to scenario B, but that only overwrites the initial data in scenario B instead of data from A being appended to B. Manually copying and pasting all inputs from A to B and then adding additional input in B is too much of a hassle. Let alone that you'd have to keep in mind to update 3 scenario's if you change something in the baseline. It wo

Is there a way for an end user to change a selection of booleans to True or False simultaneously? I would like to select a group of Booleans and turn them all true or all false by highlighting the cells and then pressing a button or series of buttons. Does this series or keystroke exist?

I have set up item variables based on snapshots of my model. is it possible for my calculated items to automatically change based on which item is selected in the board filters?

Hello all - I am new to Pigment and am having some serious difficulty staging up a lease schedule for my client. The client wants to input future forecasted leases as follows:Step 1: Select a region from a drop down menu  The region is already dimensioned via “L1 Geo” Step 2: A lease value column should prepopulate based on default regional values. The “L1 Geo” dimension has two additional columns with default Lease Values and default Cage values.  Step 3: A “Cage Fee” column should prepopulate based on default regional values. The “L1 Geo” dimension has two additional columns with default Lease Values and default Cage values.  Step 4: A rent escalator column should prepopulate with 3% Step 5: A term column should prepopulate with 60 months Step 6: A “Start Date” column should be manually entered Step 7: A monthly view should show two separate calc

Hi All,Does anyone know how “Auto-Input Using Default Page Items” this works?There is metric with data type dimension. Same dimension is on the page selectors. The value of the page selector should also be the value in this metric

My headcount planning app currently uploads a headcount report on a monthly basis and the forecast basically rolls forward after every new month and the only way I can compare changes over months is to take a snapshot and change the switchover month.How should I approach making this update since it seems like I would have to rework the entire application and add a version to every metric? My current thought is that a budget version is tied to a specific months load, so I can do a mapping for load month → version but does that work?Example:Current monthly data by load monthExpected Result if I want to use June load month for BoD Version. The data from Jul onwards would only use data up to the June load and not use anything beyond that.  Any ideas would be appreciated. Thank you!

Hello Pigment Community,Our organisation is currently undergoing a migration to utilise SQL data warehouses on Databricks, and we're looking to transition our connection from Redshift to Databricks. However, we haven't found a straightforward, out-of-the-box solution to establish this connection.Could anyone from the Pigment team or community members who have faced similar challenges provide guidance on the proposed solution for connecting directly to Databricks? We currently have a workaround involving copying our Data Lake models into S3 and then connecting from there, but we're eager to explore a more direct integration.Thank you in advance!

Hi All,Although PREVIOUSBASE() is replaced by PREVIOUSOF(), why am I unable to see that update in my workspace?I am only able to use PREVIOUSBASE and it keeps throwing me circular reference error.According to this documentation - This should be new interface where we don’t need to select a base metric Instead, while setting up iterative calculation to use PREVIOUSOF, this is my current interface Can someone please tell me how I can start using the new update?

 Hi everyone 👋I’m currently trying to build a formula that returns Actuals across different versions.What I’d really like is to have something like a dynamic SELECT[MONTH - X], so it always pulls the correct month automatically.I already managed to create a working formula above, but I’m not fully satisfied — it feels like there should be a simpler and more dynamic way to achieve this. I  tried as below creating a metric to use as a pointer with SELECT: Month = Technical Metric with the function Edate OR  SELECT: Month - Technical Metric but it didn’t work as expected. When I attempt t

Hi community,I have a transaction list that is being shown in a board as a list widget.It contains some qualitative survey answers, which can be extensive. This generates a bad user experience, as I can’t make the rows taller, and the only way the users can see the full content of a cell is by hovering the mouse on top of it.Is there a “text wrapping” functionality I can apply to expand the text-heavy cells automatically? Or is there a way to make the rows taller that I might be missing?I’m also open for other suggestions on how to handle this so it’s more visually-friendly for my key users,Thank you!Andy

In a transaction list sorted by employee and effective date, how do I create a property that shows the next row's effective date for the same employee (or TODAY() if it's the last row)?"

Hi,How can I do a median in Pigment ?Thanks

 I have the following data format in transaction list: Account Name/code Account Code Quarter Product Name Deal Forecast Amount ABC abc Q2 FY 26 Tupperware

Suppose if a base metrics has Dimensions Product and Month with Data type CountryWe wish to have Target metric with unchanged Dimensions Product and Month but with Data type RegionHow can we get to the outcome in Target Metric

There’s a table with 5 input metrics at dimensionality: “Customers”.For one of the input metric “M1”,‘View cell updates’ is showing no results, even if the value is sitting in “Metric M1” for ‘Customer 1’ row.Does “View Cell Update” work on the values which gets uploaded through a button by uploading the CSV file?

Hi,I am facing an issue with the email notifications triggered when a certain criterion is met. I seem to be receiving the emails as expected but the client I am working for is not receiving them. Could anyone please tell me why this could be happening?Thanks!

Hi,I have a dimension formatted property in a transaction list. I want to restrict the items in the dropdowns based on users. Applying data access rules achieves this only partially it seems. While the users cannot see the items that are not assigned to them once they make the selection from the dropdown (the input simply disappears), while making the selection they are able to see all available items in the list. How can I restrict this?

Hello All,I’m currently trying to create 3-month trailing average for multiple dimensions. The formula worked when I only have 1 version dimension but when I tried to create multiple versions, it collapse. Here is my metrics before adding version Metric 1: Trailing 3 months (Boolean) Metric 2: Trailing 3 months calculationSo, you can see Aug 25 is the trailing average for May through Jul Here is what I attempted to replicate after adding version as a dimension.Version DimensioPeriod Type by Mon

Hi all, I'm importing an employee transaction list with historical employment data using a direct connector to my HRIS. I’m creating a new unique ID property from Employee ID + Effective Date. I ran into the following challenge: my source data sometimes contains two events for the same employee on the same day (e.g., a hire and a no-show termination). My question is: is there an automated method in Pigment to identify and remove all rows that share a non-unique key during an import? I want these conflicting pairs of rows to be excluded entirely and I need the monthly import from my HRIS to run automatically without failing. Any ideas on how to set this up? Thanks!

Hi everyone,I have created two scenarios - Budget & Actuals. Now when I am turning on AI Insights on a metric, its showing details of the default scenario, even though I want insights of the Budget scenario. How can I solve this problem? Why are insights not available on Multiple scenarios?The documentation AI is mentioning that AI Insights can compare 2 scenarios but I am not finding any option to change the scenario for Insights.Please kindly help me out, Thanks!Regards,Spandan