Recently active topics

When exporting raw data from a Table or Metric, you have the option of filtering rows using AND/OR logic within exportFilter. This article provides guidance and examples. How to write the exportFilter query tree Required keys by type Examples Use exportFilter to filter rows when exporting a Table or a Metric. It lets you combine Dimension and value conditions with AND/OR logic. For example, for a “Revenue” Metric with Dimensions “Month” and “Account”, you can build queries like: Filter on Month = [“May 2025”] AND Revenue ≥ 100,000 Filter on Month = [“May 2025”] AND (Revenue ≥ 100,000 OR Account = [“Acme Inc”, …])  ℹ️ NoteThe legacy filters field is deprecated. If you send both filters and exportFilter, they’re combined with an implicit AND. How to write the exportFilter query tree Sketch out your exportFilter logic as a recursive tree. Every node needs a type: Use a Dimension node to filter on Dimension values (for example, filter on specific Months or Accounts) Use a Value node to

Hi,Can someone please tell me about the best practice for Data Cloning in metrics from one version to another such that even data which is the result of a formula gets cloned when new version is added? This is my find with regards to data cloning:1) In formula driven metrics with manual override on, only manual inputs get cloned. Data resulting from formula does not get cloned.

 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 this, I get the following error:    The strange thing is that both metrics do share the same dimensions (Month + Version), so I’m not sure why Pigment doesn’t allow the SELECT here. What’s the best way, in your opinion, to dynamically retrieve data for different months using SELECT or other approaches ? Thanks a lot for your help !

I have a rather large transaction list (roughly 5M rows) with several dimensions.  I need to map the combination of these unique dimensions to assign my data into user managed groupings.  To do that, I need to do a 2 part calculation by first concatenated the various dimensions and then matching it to the grouped dimension.MATCH('_ Subscriber Activity'.'Account Type'.Name &"-"& '_ Subscriber Activity'.'Product Group'.Name &"-"& '_ Subscriber Activity'.'Product Subscribe Group'.Name &"-"& '_ Subscriber Activity'.'Device Sub Cohort'.Name &"-"& '_ Subscriber Activity'.'Device Type Cohort'.Name &"-"& '_ Subscriber Activity'.'Marketplace Cohort'.Name &"-"& '_ Subscriber Activity'.'Customer Subscribe Category'.Name,'_ Product Attributes'.Name) The problem is that I get an error that is: “Product Attributes: Formula timed out (> 3 minutes)”.  I’m not sure how to work around this error with a more optimized approach.  Any help will be much app

Hi Pigment - would you please share the difference between Previousbase and Previousof. They look the same from the documentation perspective. Thanks,Louie

Hi Everyone, We are looking for a Director of FP&A to join us at Qualified! This is a critical role in shaping our company’s financial strategy - perfect for someone who loves SaaS finance, thrives on building scalable models and frameworks, and wants to partner directly with our executive team and GTM leaders to drive growth and efficiency. And most importantly, someone who loves Pigment! We recently completed our implementation (and love it so far!), so you’ll have the chance to shape the way that we use Pigment at Qualified to measure, monitor and plan the business! You’ll get to:Own forecasting, planning, and reporting across the business Work cross-functionally with our executive team and senior leaders across the company Build scalable models and processes that support decision-making Deliver insights to the C-Suite to shape company strategyHere’s the link with all the details + how to apply: Director of FP&A at QualifiedIf you know someone who might be a good fit, I’d lo

DescriptionReturns the cosine of the given angle in radians. SyntaxCOS(Number) ArgumentsArgument Type Dimensions Description Number (required) Number Any Dimensions Angle in radians for which to compute the cosine.  ReturnsType Dimensions Number Dimensions of Number  ExamplesFormula Result Description COS(0.524) 0.866 The cosine of π/6 radians is 0.866. COS(0.785) 0.707 The cosine of π/4 radians is 0.707. COS(1.571) 0 The cosine of π/2 radians is 0. (1-COS(3.1416))/2 1 The output of this formulation is the haversine.  Related articles: SIN function

DescriptionReturns the sine of the given angle in radians. SyntaxSIN(Number) ArgumentsArgument Type Dimensions Description Number (required) Number Any Dimensions Angle in radians for which to compute the sine.  ReturnsType Dimensions Number Dimensions of Number  ExamplesFormula Result Description SIN(0.524) 0.5 The sine of π/6 radians is 0.5. SIN(0.785) 0.707 The sine of π/4 radians is 0.707. SIN(1.571) 1 The sine of π/2 radians is 1.  Related articles: COS function

Is there a way to make the dashboard load faster ?E.g. There is a dashboard having a grid with 50 metrics (all of the metrics are with ‘Customers’ dimensionality) and 10 filters on top of the board.If only 1 filter is selected, it doesn’t load the view/grid

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 Closed 1000 ABC abc Q3 FY 26 Tupperware Ommited 2000 PQR pqr Q4 FY 26 Coke Closed 3000  I wish to have a output view as below  Account Name Account Code Product Name Quarter Deal Forecast Amount ABC abc Tupperware Q2 FY 26, Q3 FY26 Closed, Ommited 1000,2000 PQR pqr Coke Q4 FY26 Closed 3000  Thanks in advance for help 

BETATo write effective instructions for the Analyst Agent, you need to guide it step by step, using explicit and structured language. Your instructions must specify which of the supported tools and capabilities the Agent is to use.Essential and optional instructions Instruction optimization Supported tools and capabilities Contribution analysis Variance analysis Filtering Time Series analysis Loops Charts Advanced calculations Dos and Don’ts Essential and optional instructions Your instructions must contain the following: What data to analyze. Which analysis steps to follow. How the output should be structured. Optionally: Include examples of how the Report’s wording should look. Specify a tone and style for the Report (e.g. concise, executive-friendly, bullet-pointed). Define a language for the Report. The instructions can be written in any of 50 widely-spoken languages, and you can ask for the Report in any of the 50 languages. Identify a destination Metric for the R

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

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 would be great if there's an eleg

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?

You can now use Recovered Applications to restore one or more Applications to a previous point in time, helping you quickly use a previous version of an Application as reference in the case of accidental changes or technical issues. This article covers how to recover, manage, update, and delete recovered Applications. Recover an Application as a Member You need to invite your Pigment Support Account to be a Security Admin in your Workspace when submitting a restore request, as Application recovery is currently implemented by Support. To recover an Application as a Member:1. Go to Recovered Applications in the sidebar.2. Select Raise a request to open a ticket with Pigment Support for Application recovery. The designated owner of the recovered Applications can view and manage Recovered Applications from the Recovered Applications page. For more information, see the next section, Manage Recovered Applications.Note the following about recoveries:You can have three active recoveries in pro

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 Month (by version)Create a new 3-month trailing boolean for each versionBut when I replicate the output, this error popped up Any help would be appreciated! Thanks!

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!

When a formula refers to other Blocks to iterate over all the items in a Dimension, care is needed to avoid circular dependencies, which risk creating an infinite loop. For more information on circular dependencies, see Troubleshoot circular dependencies.This page looks at the second of Pigment’s tools for creating iterative calculations, the PREVIOUSOF function, which replaces the PREVIOUSBASE function. It explains how to optimize its use in the context of multiple Block iterative calculations. The first tool, the PREVIOUS function, is for single Block calculations. See Iterative calculations within a Block using PREVIOUS for more information.Multiple-Block Iterative Calculation Limitations Create an Iterative Calculation How does it work? Optimization Debugging Formula Errors Learn more Multiple-Block Iterative Calculation A multiple-block iterative calculation configuration is made up of two things: an iteration Dimension a list of allowed Metrics When you create an iterative calc