Hi, I am trying to set a logic where there are 2 merit cycles, I want to us Previous(year) but also incorporate that cycle 2 is equal to cycle one and editable in case it isn’t.
I’m currently converting a table into Sheets and running formulas on the side to build checks, for example for the Balance Sheet. When I add new rows to the table however, the formulas don’t stay on the original cells. Is there a fix for this?
There are limited graphing capabilities in Pigment today vs. what’s available in Powerpoint, for example.You can not do multi-axis graphing feature today in Pigment. An example of stacked bar of loan balances and then adding the yield trends in %s on top.Even on a single axis graph, you can not do a trend line graph on top of a stacked bar There are some valuable features from Think-cell plug-in to Powerpoint that would be helpful in Pigment (https://www.think-cell.com/en). Below is an example of showing % increase between the stacked bar (a think-cell feature) Also, given that you guys are Pigment, we would have expected more color palette options for graphing but it’s very limited at the moment when we have various data points :)
How do I download an audit log as a csv file into my hard drive?
Hi guys - curious if anyone has tried to do this… I am trying to create a new scenario that is based off of a previous “snapshot” version of an application. This doesn’t show up for me as an option when choosing the “initial source of data” dropdown in the new scenario creation prompts. We use snapshot functionality to catalog our forecast versioning, so if I have a “4+6 Forecast” as a snapshot scenario from 2 months ago that we want to use as a basis for second half reforecast, I’d have to reference that dataset (not the live forecast) for our baseline/starting data. Anyone know how to accomplish this?
I have below metric for selecting the last month of the year.I’m using it as a dynamic variable for Month dimension.I want to use it for YoY% (“Selected Year” vs. Previous Year) headcount variance. But it doesn’t work. How do I make this work? Or, how do I make a similar logic to calculate it for the Year (property of Month) selected from the Pages (being dynamic)?Currently, I’m calculating it for a specific Year (unlinked from the Pages in the main board) like below. P.S. The variable works well in Filter.
Our team is thinking about future Pigment updates, primarily the upcoming AI capabilities. We are looking at bringing in more dimensions into our modeling to help better isolate actionable insights and plan at a more granular level. As a result, our source datasets (which we will bring into Pigment as transaction lists) are going to grow significantly. From millions to perhaps up to 100 million records. Are there any limits to the size of a transaction list? Will overall performance suffer? Just want to get a sense of the possible.Thank you!
Hi! I am trying to apply a calculated item to just one metric in a table and not to all of them. Basically, be able to display this (see photo attached), where I can assign no calculation to some metrics. Do you guys know how to do it? Thank you!
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
Hi there, I haven’t really found something related to this topic, hence this new one. I am fairly new to Pigment and have been working heavily with other planning solutions so far. What I see in every project is the need to easily set up parent-child hierarchies for cost centers, profit centers or products. Those can have many levels (e.g. a 10 level deep cost center hierarchy). In other solutions I would get all node and leaf items from a source system and add the respective parent in a separate hierarchy column (so I need to keep two columns maintained to have a full multi-level hierarchy). What is the equivalent of this in Pigment? Thanks everyone! *Update: my apologies, I was actually referring to parent child hierarchies. Would that change the approach?
Hi Team,Is there a way to update the formatting of all parent rows at once?For example, we have data at the Location level in rows, with Country set as the parent. Instead of formatting each country one by one, can we apply the formatting to all parent rows together?I believe this would help us save significant time and effort.Thanks & Regards,Spandan
Hi everyone,I would like to display both Code and Name of a Dimension, in a Table.Below is the objective which I created from screenshots:In the first row, “CESSION” is the Name of the Code “AU1”, in the “Business Area” Dimension.Thanks !
Hi,I have a set of metrics for wich I want to copy the input from one version to another.Version is a dimension ex: Budget 2025, Reforecast 2025….I have in mind something like using the function “ copy input between scenario” but at a version level.Thanks
Already have an account? Login
Single Sign-On Need help?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.