Fresh from Pigment! Read our latest Product updates and share your feedback!
The new KEEP modifier lets you specify exactly which Dimensions to retain—automatically removing all others. Combine KEEP with aggregation operators to transform data, such as returning Revenue by Month while all other Dimensions are automatically averaged. Shorten your syntax and boost formula-writing efficiency with KEEP!
You can now leverage a consolidated, real-time view of populated cell volume across all Applications, Recovered Applications, and Snapshots using the Storage page. Quickly monitor storage trends, spot unexpected increases, and understand where usage is concentrated. It’s a faster, clearer way to maintain healthy Workspace hygiene and support more informed modeling decisions.
With the new Pigment Connector for PowerPoint Add-in, you can seamlessly insert Pigment charts and grids into your slides, preserving your View formatting and keeping every Item connected to its source data.
Refresh a single View or your entire presentation in one action to ensure your numbers stay accurate as your Pigment data evolves. Bring real-time Pigment insights straight into every presentation with ease, helping teams stay aligned and up to date. Now available on the Microsoft App Marketplace.
With Data Slices you can compare just the data you need without juggling multiple selectors. They are designed to hide the complexity of multi-Dimension version management from end users. Each Slice represents a meaningful combination of items—like “Actuals 2025” or “Forecast 2026 V1”—and are ideal for any analysis that spans Versions, Years, Scenarios, or Snapshots. You can add them to any View directly from the Pivot panel!
You can now connect your Databricks Tables directly to Pigment to enable secure and efficient data imports across Azure, AWS, and GCP. This integration uses the Delta Sharing protocol to provide seamless data sharing—no manual exports or maintenance required.
There is a new time Dimension available for your Calendar: Half! Pivot your data into first-half and second-half results with this native Dimension, or use it with time and date functions such as INPERIOD(), PRORATA() and TIMEDIM().
If your sales, accounts or other business cycle have a half-yearly cadence, add Half and set up your other Time Dimensions as Properties. Learn more.
From today, Pigment’s product documentation is getting a fresh look in a new dedicated site! The user experience has been updated with a modern design and a streamlined interface to help you find what you need, faster. Apologies in advance while the site is under maintenance.
Now you can transform values in radians into sine and cosine equivalents using simple syntax. Whether you're modeling demand or cyclical interest rates, or calculating the haversine distance between coordinates, with the new SIN and COS functions you can add oscillations into your planning. The new functions are part of Pigment's suite of math utilities, which includes LN, LOG and EXP.
Learn more about the SIN function and COS function.
Spacer widgets let you add empty space or a horizontal divider between widgets on a Board. Use them to separate sections, improve layout clarity, and make complex Boards easier to read. Learn more.
We're excited to introduce Mapped Dimensions—a powerful new way to analyze and group your data flexibly, without redesigning your entire model. You can leverage complex relationships between Dimensions, such as mapping Employees to Teams, or SKUs to Suppliers, even if they evolve over time. This unlocks dynamic reporting and analysis, enabling you to compare and aggregate your data with just a few clicks.
