- - Search Insider Guides
  - Insider Guides
  - Technical tips70
Knowledge Base
Academy
Events
Groups

Create post
Login

Welcome to the Pigment Community!

Start Here!

Get oriented, explore resources, learn, and connect with others

Find an Answer

Ask a question and find answers from other users in the Pigment community

Explore Pigment AI

Learn all about Pigment's latest AI features and best practices.

Discover Tips and Tricks

Insider guides and best practices from the Pigment team

Submit a Product Idea

Share your ideas for improving Pigment directly with our product team

Browse the Knowledge Base

Technical documentation to support your day-to-day use of Pigment

Featured topics

Getting Started with the Modeler Agent: Prompting Playbook

The Modeler Agent is at its best when you provide context, a clear goal, and a defined output format. When you nail the prompt, it doesn’t just save t...

Forum|Forum|1 month ago

3010

Architectural Foundations: Dimensions, Sparsity, Scale and the Discipline of Scope

Forum|Forum|14 days ago

820

Prompting the Pigment MCP Server connection

Forum|Forum|1 month ago

1050

Explore the Community

Recently Active
Help Others
Categories

ChrisAHeathcoteAuthor

Questions & Conversations

Transaction List Properties

Hi,Iv heard that it is not best practice to use formulas in transaction list properties due to the performance impact. However, Id like to tidy up imported data; extract dates, identify codes, build hierarchies etc. With other platforms I would impor

100

4 hours ago

A

AmeePAuthor

Questions & Conversations

Recovered Applicants Test Use

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?

kristian.bartel12Apprentice Author

Questions & Conversations

Is there any way to hyperlink a dimension?

Hello, I have a board where I’d like PO Number to be able to show up as a hyperlink to our procurement system. The hyperlink I have set-up and within the PO Number dimension (see image)However, I’m not aware of a way to get that dimension to appear a

402

K

5 hours ago

ChrisAHeathcoteAuthor

Questions & Conversations

Filter a target metric based on the boolean value and a selector metric

Hi,Id like to use the boolean result of a source metric to filter the view of a target. However, I cant seem to be able to set up the filter to take a value from a metric external to the metric to be filtered. Is this possible?If not, is there anothe

225

5 hours ago

DamienEmployee

Company News

Bringing consolidation into the AI era

Financial consolidation is still one of the most manual, time-consuming parts of finance. At a moment when so much of the enterprise is becoming faster and more intelligent, consolidation often remains a bottleneck.Today, Pigment is expanding its con

30

6 hours ago

GawainEmployee

Technical tips

Lifecycle Performance: Views, Snapshots, Testing and Model Hygiene

Introduction Building something that works is not enough in Pigment. The goal is to build it right and to optimise for performance from the first design decision to the last. This guide consolidates best practices from the Pigment Modeling Palette in

30

6 hours ago

ChrisAHeathcoteAuthor

Questions & Conversations

Build a dimension with Pigment

Hi,I would like to create a mechanism to create a dimension from the user selecting combinations of other dimensions in a boolean formatted metric. For example; GL, Supplier and Project. User selects an intersection by checking a boolean. This can th

111

6 hours ago

K

Kevin Leadbeater 2Author

Questions & Conversations

Filter a table based on a numeric metric rather than a value

I set up a filter to display rows where a numeric metric is greater than a value. Is there any to test the numeric metric against another numeric metric, rather than the value input?

MKSMPBAuthor

Questions & Conversations

Budget comparison table with Snapshots

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?

William SeathApprentice Author

Questions & Conversations

Unable to clone data in a metric

Hello, I am trying to give users the ability to initialise data from a statistically generated demand plan using Clone data in metrics. I am using the following set-up, and the clone appears to run, but no data is created in the metric and applicatio

635

3 days ago

ChrisAHeathcoteAuthor

Questions & Conversations

Transaction List Properties

Hi,Iv heard that it is not best practice to use formulas in transaction list properties due to the performance impact. However, Id like to tidy up imported data; extract dates, identify codes, build hierarchies etc. With other platforms I would impor

100

4 hours ago

ChrisAHeathcoteAuthor

Questions & Conversations

Build a dimension with Pigment

Hi,I would like to create a mechanism to create a dimension from the user selecting combinations of other dimensions in a boolean formatted metric. For example; GL, Supplier and Project. User selects an intersection by checking a boolean. This can th

111

6 hours ago

M

MKSMPBAuthor

Questions & Conversations

Budget comparison table with Snapshots

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?

LindsayApprentice Author

Questions & Conversations

Returning zeros instead of null in a Metric

Hi all -- hoping someone can point me in the right direction. I have a board that displays WoW revenue in relation to targets. Both Rev and Target are Metrics. Data for future weeks (based on standard Day) is null in Rev but populated for the Target

211

6 days ago

K

KentiaApprentice Author

Questions & Conversations

Collect the descriptions of the metrics used

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?

1222

1 month ago

A

AlinaMaster Author

Questions & Conversations

How to set up variable and page selectors to work together

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

5615

1 month ago

M

Md SaquibAuthor

Questions & Conversations

Setup an Iterative Calculation

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 U

1731

1 month ago

V

Venkat GowthamApprentice Author

Questions & Conversations

Can we integrate Pigment with Python

1521

1 month ago

I

ItishriApprentice Author

Questions & Conversations

Roadmap Question: Aggregate by Formula Functionality

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 lev

1461

1 month ago

Spandan98Wallflower

Questions & Conversations

Automatically adjust Boards to different screen sizes

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!

3484

H