Visual hints are now cell status indicators! These handy indicators show if a cell's data comes from a formula or if it has been manually updated. You can turn them on or off as needed on a Board or View. We’ve also tweaked the style: instead of a yellow background, cells that can be manually input or edited now have a gray border.

Powerful cell status conditional formatting

Cell status conditional formatting keeps cell status indicators visible in a specific View, making it easy to identify important input Metrics and manually edited or overridden cells. Input cells have a gray border, while overridden cells display a blue bar. This feature is crucial for clarity and consistency, especially when multiple users with different access rights work on the same grid.

Dive into the new cell status indicators and discover how cell status conditional formatting can supercharge your cells and simplify data management.

We’re thrilled to announce an update that’s going to make your data modeling even more powerful! Say hello to multi-Metric iterative calculations with the brand new PREVIOUSBASE() function! 🚀

Whether you're handling complex cash flow statements or intricate inventory planning, our new PREVIOUSBASE() function is here to simplify your work. No more struggling with circular dependencies across multiple Metrics – just smooth, seamless calculations that take your modeling to the next level. 🙌

Ready to dive in? Check out our latest documentation to learn how these powerful functions can elevate your modeling game.

Happy modeling!

Our new access rights wizard will leave you spellbound. Reduce the learning curve in Pigment security by quickly conjuring up robust data access in your Application. Experienced modelers, all that time you spend configuring access rights is about to be magicked away! 

Read more here.

No more hidden chart labels! Now you can easily see all x-axis labels thanks to the new wrapped chart labels upgrade. Long chart labels will wrap onto the next line, making all labels visible. You’ll also notice that legend labels are now shortened with an ellipsis for clarity.

We’ve also introduced scrollable waterfall charts. If there are too many data points, the waterfall chart lets you scroll horizontally by default for full visibility. Toggle this feature on and off under Waterfall settings in the Format panel. Learn more here.

Pigment filtering just got refined. We’ve upgraded your filtering experience to allow you to jump directly to:

• A Metric, and then filter the underlying Dimensions by the Metric value.
• A specific Dimension and then directly filter its items, or filter its items based on one of its Properties. 

Read more here.

Have you ever set up a native integration in Pigment but then found yourself going back and forth between the connection configuration and import simulation to check your credentials?

Now you can swop going back and forth with one simple button click! You can perform connection testing for all Pigment integrations wherever you need to check credentials input. (Not for OAuth integrations however.) 

So how's it done? When you configure a new connection, or when you edit an existing one, you have the option to click Test connection before saving. Quick and easy! Read more here. 

Profile the calculation paths following specific Updates in Application or Block History in Pigment to understand which parts in your model calculate slowly after a Member completes a specific action.

Easily identify which Blocks in the calculation path take the longest and which formulas need optimization. Profiling helps you understand your model calculation paths to optimize them for better performance times. 

Read more here to add pep to your model performance.

Keeping your Calculated Items organized is no tall order. You can now view and reorder the order of your Pigment calculations within a Table or Metric in the Calculations tab in the Configuration Data pane. Learn more here.

Streamline Block management with the ability to rename Blocks in a single flow. Easily find and replace text within your Block names, or add a prefix or suffix to existing Block names. Learn more here.

Introducing Access Rights on Scenarios in Pigment! Data security can be enhanced by restricting Access Rights on Scenarios to specific Members based on their Roles within the Application.

Read more here.