- - Search Insider Guides
  - Insider Guides
  - Technical tips75
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|2 months ago

5570

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

Forum|Forum|1 month ago

2140

Prompting the Pigment MCP Server connection

Forum|Forum|2 months ago

2380

Auditing Your Pigment Workspace with the Modeler Agent

R

Forum|Forum|10 days ago

410

Explore the Community

Recently Active
Help Others
Categories

ChrisAHeathcoteAuthor

Questions & Conversations

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?

60

8 hours ago

ChrisAHeathcoteAuthor

Questions & Conversations

Define a cell as active despite having a zero value

Hi Is it possible to define a cell as in use/active even when the result is zero?I have a filter that distinguishes active cells so can I combine this with the formula so it returns a zero?Thanks,

212

1 day ago

ChahatMaster Helper

Questions & Conversations

UNIQUE/ DISTINCT Function

Is there any Pigment function or keyword available to retrieve distinct/unique values?(apart from COUNTUNIQUEFor Example:There’s a metric of datatype “text”.Dimensionality/Structure of metric: Employee and YearSome values for FY 2025 (Source-metric)E

292

2 days ago

G

Guillermo Puls CruzApprentice Author

Questions & Conversations

Formula switch depending on Dimension value

I have a Transaction List and I want to create a formula that applies logic A when the value in Business Segment Group is value A and uses logic B when Business Segment Group is not value A. Thanks for the guidance!

tjain02Master Author

Questions & Conversations

Shift months while using PREVIOUSOF()

Hi,Is there a way to reference the current month value even while using PREVIOUSOF()? Since using iterative dimension is not allowed, is there a way to shift month values so that value returned by PREVIOUSOF() is the current month value instead of pr

Guillermo Puls CruzApprentice Author

Questions & Conversations

Creating my first metric

Hi,Another simple one.I have a Transaction list with monthly data for revenues for customers, product types and dates.I want to create a metric that adds up the revenue based on the dimensions selected for the metric.The dimensions selected are prese

322

4 days ago

G

Guillermo Puls CruzApprentice Author

Questions & Conversations

ITEM formula

Hi I’m trying to do a simple look up using ITEM.I have Transaction list, which contains customer data and the Product Type. Product Type is Dimension data type.I have created a Dimension that allocates each Product Type to a correspondent Business se

243

4 days ago

C

cshankhdharApprentice Author

Questions & Conversations

To Limit the members in a drop-down menu of a metric having data type as a dimension

Thanks.This is resolved

332

C

7 days ago

ChahatMaster Helper

Questions & Conversations

Check overrides easily

It would be great to have a built-in feature that allows users to quickly identify and display only overridden values by applying a formula or filter. This eliminates the need for manual, visual inspection (side- blue bar) of each entry , improving e

422

8 days ago

T

tjain02Master Author

Questions & Conversations

Recursive Calculation using MIN()

Hi All,Do you know how to implement a recursive calculation using MIN() function? Take this metric for example. The goal is that in a different metric I want the minimum value from TEST 1 except that I want the calculation to be recursive. If I am in

252

T

8 days ago

ChrisAHeathcoteAuthor

Questions & Conversations

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?

60

8 hours ago

ChrisAHeathcoteAuthor

Questions & Conversations

Define a cell as active despite having a zero value

Hi Is it possible to define a cell as in use/active even when the result is zero?I have a filter that distinguishes active cells so can I combine this with the formula so it returns a zero?Thanks,

212

1 day ago

T

tjain02Master Author

Questions & Conversations

Shift months while using PREVIOUSOF()

Hi,Is there a way to reference the current month value even while using PREVIOUSOF()? Since using iterative dimension is not allowed, is there a way to shift month values so that value returned by PREVIOUSOF() is the current month value instead of pr

cshankhdharApprentice Author

Questions & Conversations

To Limit the members in a drop-down menu of a metric having data type as a dimension

Thanks.This is resolved

332

C

7 days ago

ChahatMaster Helper

Questions & Conversations

Check overrides easily

It would be great to have a built-in feature that allows users to quickly identify and display only overridden values by applying a formula or filter. This eliminates the need for manual, visual inspection (side- blue bar) of each entry , improving e

422

8 days ago

T

THAddeparApprentice Author

Questions & Conversations

How to change First day of the week after week dimension already created

How to change First day of the week setting after week dimension already created.its currently greyed out

NiklasApprentice Author

Questions & Conversations

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

Nancy MehrotraApprentice Author

Questions & Conversations

Workiva Integration

Does Pigment have workiva as native integration or non-native integration?

571

17 days ago

G

Guillaume Langlois DTTEAuthor

Questions & Conversations

Automatic generation of multi-entity reporting packs consolidated into one PowerPoint

The requirement is to automatically publish a reporting pack in PowerPoint. This reporting pack must be generated identically for multiple entities. All packs must be consolidated into a single PowerPoint file.

DhirajApprentice Author

Questions & Conversations

Help needed: Dependent Page Selector options not appearing on Board

Hi everyone, I’m trying to set up a dependent dropdown on my Board so that the 'Year' selector filters based on the 'Version' selected, but I’ve hit a roadblock. In the Selector Options menu, I’ve changed the Adaptive Display for 'Year' to 'Dependent

602

D

22 days ago