Welcome to the Pigment Community!

Headcount Reporting with Variances

Hello, very new to Pigment. I am looking to create a table that shows headcount for CY MTD Act, MTD Bud, MTD PY, Var Act CY MTD vs MTD Bud, Var Act CY MTD vs MTD PY. Then repeat everything for Dec 2026 (compare to Dec Bud and Dec 2025). Looking for a

211

G

4 hours ago

ChrisAHeathcoteAuthor

Mapping into a metric

Hi,Id like to take data from a source metric dimensioned by month, GL, department and project and map this into a P&L line item metric dimensioned by month. However, as mapping metrics must be formatted by the dimension of the target what Im unsu

1464

1 day ago

R

remi fApprentice Author

Date setting in Microsoft edge

Hello, I have set up my Edge browser to English (not English US) and the dates are still displaying with MM/DD/YYYY format.. how to change it?Anybody facing this challenge? Thanks for the supportRemi.

101

1 day ago

Brian MondelloApprentice Author

ISFIRSTOCCURRENCE formula for dimension creation

With the new functionnality to create dimension based on an other dimension/transaction list, I want to create a concatenation of 2 columns in my transaction list but.. Pigment say there is an error because a lot of rows don’t have unique ID. Is it e

GiridharApprentice Author

GreenField BPC implementation

HiWould appreciate if some one can share the GreenField BPC Implementation guide lines and the Do’s and Dont’s.ThanksGiridhar

Variance 5 wrong for one metric and right for another

Hi,I have created a table that contains 5 metrics out of which two are in % form using show value as %of metric feature. Thw view that i created is two versions in column and variance also. The problem that i am facing is variance for 4 metrics is co

111

Y

YaejisMaster Author

Scenario

Hello! I dropped in a table into another application, and somehow the scenarios are not available to choose. Is there anything I need to toggle on? Thanks for checking! Scenarios shown in the original table: In another board page when I click Scenari

343

Isabella Leslie-MillerCommunity Manager

Top Questions of the Month - May

Month after month, Pigmenauts share challenges, ideas, and solutions that help us all learn and grow together.To celebrate this knowledge sharing, here are May’s top 5 questions. We’re highlighting the ones that sparked the most interest and views fr

190

Agentic AI Meets Better Visualizationnewsletter

Catalina IbarraCommunity Manager

Company News

This May, we have exciting news features to share, from formatting improvements, enhanced ways of visualizing your data, to new AI and Agentic updates designed to accelerate your developments. 🚀 Intent Modeling Certification is now live 🌐 Register to

140

7 days ago

N

Current year automated

Hi,I have a metric named current year with year as data type and no dimension. purpose is to automatically update the current year every year. Is this possible to achieve in pigment and how?Thanks in advance

161

7 days ago

J

jjungerheldNew Here

Headcount Reporting with Variances

Hello, very new to Pigment. I am looking to create a table that shows headcount for CY MTD Act, MTD Bud, MTD PY, Var Act CY MTD vs MTD Bud, Var Act CY MTD vs MTD PY. Then repeat everything for Dec 2026 (compare to Dec Bud and Dec 2025). Looking for a

remi fApprentice Author

Date setting in Microsoft edge

Hello, I have set up my Edge browser to English (not English US) and the dates are still displaying with MM/DD/YYYY format.. how to change it?Anybody facing this challenge? Thanks for the supportRemi.

101

1 day ago

Brian MondelloApprentice Author

ISFIRSTOCCURRENCE formula for dimension creation

With the new functionnality to create dimension based on an other dimension/transaction list, I want to create a concatenation of 2 columns in my transaction list but.. Pigment say there is an error because a lot of rows don’t have unique ID. Is it e

Variance 5 wrong for one metric and right for another

Hi,I have created a table that contains 5 metrics out of which two are in % form using show value as %of metric feature. Thw view that i created is two versions in column and variance also. The problem that i am facing is variance for 4 metrics is co

111

Y

YaejisMaster Author

Scenario

Hello! I dropped in a table into another application, and somehow the scenarios are not available to choose. Is there anything I need to toggle on? Thanks for checking! Scenarios shown in the original table: In another board page when I click Scenari

343

N

Current year automated

Hi,I have a metric named current year with year as data type and no dimension. purpose is to automatically update the current year every year. Is this possible to achieve in pigment and how?Thanks in advance

161

7 days ago

ChrisAHeathcoteAuthor

Filtering Metrics in a Table Block

Hi, I would like to filter the metrics in a table so I have the option of only showing totals. User would then toggle between the summary and detailed view via a button on a board. How can it be done?

422

17 days ago

J

Justin.AlpertApprentice Author

Merging Scenarios Cleanly

Does anybody have any advice on on managing the migration of scenario changes back into default plan in a clean way?In other EPMs, multiple scenarios get spun up, different changes are made in each, and then those changes can be cleanly merged back i

NiklasApprentice Author

Audit/History For Exports via API Key

Hi Pigment Community,Is there a way to see information about data exports performed via an API export key?For imports, Pigment provides good traceability: when using an API import key, the application shows which assigned user performed the import (e

Guillaume Langlois DTTEAuthor