Connect with other users, discuss how you're using Pigment, and get inspired
Recently active
Month after month, Pigmenauts share challenges, ideas, and solutions that help us all learn and grow together.To celebrate this knowledge sharing, here are three October questions that sparked thoughtful conversations in the community 💡.Whether you faced a similar challenge or want to learn new tips, these threads are a great place to explore, contribute, and connect. 1. Helping Claude MCP access dimension properties Question - @Bas:“Why can Claude MCP find certain metrics but not see a dimension’s properties, such as a simple text property, and how can I fix this?” Best Answer - @Stef:Check whether Advanced tools on MCP is enabled. Turning this setting on may allow Claude MCP to access dimension properties. Read the full discussion here: 2. When a renamed metric is not propagated to dependent formulas Question - @Min Li:“Why did renaming a metric leave the old name in a downstream formula and cause an ‘Unknown Block’ error, and how can I restore the reference?” Best Answer - @F
We have exciting news to share: Pigment just raised a $250m Series E led by Scaleup Europe Fund with participation from WIL (World Innovation Lab), existing investors including Greenoaks, ICONIQ, IVP, and Meritech, and a planned investment from NVIDIA. The advent of agentic AI has acted as rocket fuel for Pigment’s growth, and over the past nine months, we’ve shipped an incredible portfolio of features. Today, 85% of new metrics on Pigment are created by an AI agent and 84% of accounts use our agents every week. But what’s also been pivotal to our growth has been the trust organizations like yours have placed in us - and for that, we wanted to express our gratitude for your continued support. Thank you for helping us get to this point - the funding announced today will allow us to scale our capabilities even further. To read more about the announcement and our plans:Read our press release Read Bloomberg’s coverage Read our blog post
Welcome to the Pigment Community!You’ve just joined the Pigment Community! Welcome! This guide will help you on how to dive in, meet others, and learn how everything works here.Inside this community, you’ll find proven solutions, insider tips, and direct access to fellow Pigmenteers who’ve faced (and solved) the very challenges you’re tackling. Think of it as your backstage pass to getting the most out of Pigment.We invite you to be curious, look around and discover all we have to offer! To help you get started, here’s your First Steps Checklist ✅:Register and complete your profile. Add a profile picture and fill out your profile details! Say hi! Introduce yourself in the Intro thread Join a local group. Connect with members in your country and exchange insights close to home. Jump in and ask a question, contribute an idea or share your insights! Active participation doesn’t go unnoticed! Our badge and ranking systems showcase your contributions. As you like, post, reply, and support
Hi,I have a metric with many dimensions. I’d like to apply conditional formatting so the forecast months appear in yellow. However, it seems like the metric used to set up the conditional formatting must be populated for every level of granularity, even if it only changes based on the Month dimension.Am I missing something here?
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
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.
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
Big things are happening at Pigment this October! Alongside our $250M Series E announcement, we're introducing smarter Agents, faster Boards, more flexible Data Flows, and improvements to help you build and deploy with confidence. Plus, discover new learning resources and upcoming opportunities to connect with the Pigment Community. Pigment raises $250m Series E You may already have seen the email from our co-founders: Pigment has raised a $250m Series E, led by Scaleup Europe Fund with a planned investment from NVIDIA. Your trust helped get us here, so thank you. The Community post has the full story, as well as the press release and Bloomberg’s coverage. Agents that know more and do more The Modeler Agent got a lot smarter this month. It now chooses your best mode, so it never builds anything before you're ready. It also sees your manual edits to Views and Boards, and can search Views by name, usage or intent. Agents also reach further. Through Agent connectors, connect them to
What does a Pigment user group look like? An engaging half-day that our customers spend with each other: honest conversations, a look at what’s coming next, and time to work through real questions together.At a glanceHear how other teams use Pigment, and what they’ve learned along the way Get a roadmap update from the Pigment team, with plenty of time for questions Join a workshop or roundtable on a practical topic, including Pigment AI Meet people from nearby companies over a mealWhether you’re new to Pigment or years in, you’re sure to find something useful to take away from our user groups! Someone who uses Pigment shares their story: how they got started, what surprised them, what they’d do differently, and what they’re working on now. Speakers range from teams just past go-live to those running mature setups, so there’s a range of experience levels and points in the Pigment journey for you to learn from.If you’re wondering how to do something, odds are someone in the room is too
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 !
Introduction:Hello Pigmenteers! I’m Tom Gilbert (@tgilbert in the community), and I’m the Enterprise Planning Platform Lead at Celonis, based in New York.My day to day is really focused on managing the Pigment platform. That includes the long term roadmap and thinking about where we want to take the platform, but also the day to day work of building new enhancements, troubleshooting bugs, and supporting and enabling our users. You can read Tom’s full interview here: Can you tell us a little about your career journey?I started my career out of college at an EPM consulting company, where I worked on implementations and helped different companies build out their EPM platforms.I enjoyed that work, but I became interested in seeing those projects through for longer. In consulting, you often work on a shorter implementation and then move on. I wanted the opportunity to work internally at a company and think more about the long term strategy of a platform.That led me to join the finance tea
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
When Application A's board displays a metric shared from Application B via a Library/cross-application reference, and that reference is used directly in a view rather than wrapped inside a local formula in Application A — does taking a Snapshot of Application A freeze that displayed value as of snapshot time? Or does opening the Snapshot later still show Application B's current live value for that metric? Does the answer differ if the shared value is instead consumed inside a local formula in Application A before being displayed?
When I load the Income Statement some of the line items don’t automatically show their monthly values (the rows remain blank). The subtotals are correct - the issue is purely presentation. My workaround is to expand and collapse one of the rows and the data then appears.Is there a solution that automatically ensures all relevant data appears automatically?
Starting September 28th, Frames opens to every customer with the Modeler Agent. Describe what you want to build and Frames builds it. No code required. Below: this month's other updates, from AI credit tracking to faster data flows, plus where to catch us on the road this fall. Experience Pigment like never before with Frames Frames are coming to everyone. Starting September 28th, Frames will be available in Open Beta to all customers who already have the Modeler Agent. If you can describe what you want to build, you'll be able to build it - no code required.Think dense, beautiful visualizations built from a plain-language description: Sankey diagrams and tree maps that make complex flows click at a glance, interactive sliders and drag-and-drop controls that turn a static report into a live planning tool, executive-ready presentations that look like they took a design team a week - generated on the spot, running right on top of your Pigment data.Want to see it before you build it you
Hello Pigment Community!I am looking for any documentation on the Pigment Project Management Full Suite. Are there User Guides, Videos, basically anything showing how to set it up and use if effectively?Cheers,Jack
Month after month, Pigmenauts share challenges, ideas, and solutions that help us all learn and grow together.To celebrate this knowledge sharing, here are September’s top 5 questions. We’re highlighting the ones that sparked the most interest and views from fellow members 💡.Whether you faced the same challenge or want to learn new tips, these threads are a great place to explore, contribute, and connect. 1. Can a Data Flow (or any single-click trigger) combine multiple external/connector imports (e.g. Sage)? Question - @shubham:“Can external-source imports, such as Sage, APIs, or connector-based imports, be included in a Data Flow? If not, is there another way to trigger multiple external imports from a single Board button?” Best Answer - @Julien:This isn't currently supported, and there isn't an alternative way to trigger multiple external imports from a single Board button today.However, this exact functionality is entering beta testing, allowing external connector imports to be
Hi,I want to go for the certification of Pro Advanced Model Builder in Pigment. Can someone guide me how can i achieve that.Thanks in advance
Hello,I would like to import data from a PowerBI Dataset - is it possible and if yes, what is the recommended way?Note: the data set combines data from Snowflake, Excel files and managed rules by another planning group and therefore I want to leverage on this, rather than replicate.ThanksRemi.
Hi,I have been facing an issue with my view recently. I created a view with metrics in rows and month in columns and have used pigment Add calculated item feature to calculate yoy for every month ,yoy variance and variance %. The issue is next to it is a Total column appearing which i dent want in my view and i am unable remove it.What i did so farL-1. In the aggregator panel rmeoved the month total2. Right click on total and clicked on hide month total3. No show value as calculation addedshow every subtotal toggle is already disabledPlease let me know what i am doing wrong or missing something
Already have an account? Login
Single Sign-On Need help?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
