Recently active topics

Hello,I have a couple of boards that have ‘Month’ as a page selector. By default these are set on the current Month (driven by a variable). Based on the same variable I have some calculated items in tables (for example YTD calculations). In the page selector I can then select a particular month to switch back and forth between months and the YTD calculation changes accordingly. Works fine. But I would like to limit the allowed items in the page selector. At the moment the users have to scroll through a list of months from 2021 to 2030 to select the month. I would like to limit those allowed items to only the current year. The problem is that the month selector (hidden) defaults to the variable, but for the variable (visible) I cannot manipulate the allowed items (greyed out).Any help is much appreciated. I have asked this before in the community, but unfortunately I didn't find the time to really dive into the solution just yet.I have filtered all the tables on the specific board by a

I renamed a metric, and a downstream metric referencing it didn't auto-update — the formula kept the old name and broke with "Unknown Block". Renames usually propagate to dependent formulas automatically, so this looks like a gap specific to the references. Has anyone else seen this?

What is the cleanest formula structure to calculate a Year-over-Year (YoY) moving average across a custom rolling 12-month calendar block?

Hi everyone,I’m looking for some advice on the best architecture for a DRP model.We have around 100k Products and 11 DCs. I’m considering two options:A single Product-DC dimension containing only valid combinations. Keeping Product and DC as separate dimensions and calculating at their intersection.My initial assumption was that Pigment’s sparse engine would make the two approaches fairly similar from a calculation-density perspective. However, I’m wondering whether the higher cardinality of the Product × DC intersection could have a significant impact, especially since the DRP logic uses PREVIOUSOF().Would you recommend one approach over the other in this case? And are there any specific performance considerations I should take into account? Many thanks ! 

When I duplicate a G-sheet Workbook with Pigment connectors, the duplicated workbook loses all of its Pigment connectors and I need to re-establish them. Is there a way to preserve them? It gets frustrating when I’m creating a dozen templates with a dozens of connectors in each template.

Hi,I want to know how much AI Credits usage it takes if we build a frame since its using Modeler agent for this.Because when i looked into my usage it went quite high since yesterday with usage of Frames.Thanks

Is it possible to enter data when the input enabled metric is rendered in a Board but displayed using a Data Slice?  Eg where Data Slice is setup on Version to pull just two versions  

Bonjour, Il serait intéressant que Pigment puisse permettre de paramétrer l‘affichage de Pop Up, notamment pour demander une confirmation avant de valider une action de Validation/Rejet de budget dans le cadre d’un workflow. Cela éviterai aux users des actions trop rapides qui peuvent être lourdes d’impact.  Davina. 

Hi friends, I built a slide editor in Pigment Frame, announced it on Linkedin (here’s the post).I got a LOT of request to share the prompt-result so other people can do the same.So I’m sharing it here.I attached 3 files:slide it code: the code of the frame slide it resources: how this frames plugs into a Pigment app skill.txt: an explanation for Agents how to rebuild itLoad the 3 files to the Modeler Agent and say:build a new app "Slide it Test".Build a frame following the instructions in the attached skill.txtDon't re-invent the code nor the resources of the Frame, take them from the code and resources attached txtI encourage you to build this in a stand alone app to which you will share blocks you need the data connected in your slides. This should give you something like this:  enjoy !

Hello, I'm having difficulties with the Claude MCP server. It can find certain metrics, but it does not seem like it can also peek into the properties for each dimension. For instance: I have a simple text property on a certain dimension, but Claude insists that it cannot see the properties for that dimension.Any idea what that might be and how I can fix that?Thanks, Bas

Love Pigment and want to shape how a global company plans, closes, and reports? 8x8 is hiring a Senior Finance Manager, Systems & Corporate Reporting to own and evolve our Pigment environment: the architecture, the data flows, and the consolidated reporting that runs on top of it.We have a dedicated SEC reporting team, this role is focused on operational reporting and works closely with the CFO. Remote, US-based, Pacific time availability required.More details here, feel free to reach out directly