You can now exclude specific values when importing into a Metric or list. In Pivoted mode, simply type in the value you do not want to be included in your import and they will be ignored. You can click Exclude another value to add more. 

Values are case-sensitive and numbers with decimals must match exactly.  

Now if we can only invent a way to eat Macarons and exclude the calories.

I felt the need to tell every person I know about our new Personio connector!  Now you can easily import your HR data into Pigment.  Bring your HR data such as names, teams, locations, and salaries, so fast, they will have to update that last one 😉.

Now when taking Snapshots with the Scenario functionality activated, you can pick which Scenarios you want to snapshot.  This allows you to choose the specific Scenario you want versus having to snapshot all of them.

Even though a single snapshot is basically a Polaroid, please do not shake your laptop to get it to develop faster. 

I am not one to be formal, but it's time to button up your Boards! 

We are excited to be introducing Action buttons on Boards, which can be used for navigation to different Boards, launching imports into Blocks, and external links!

• Applying conditional Formatting to KPIs
• Displaying additional cells as CI/SVA
• automatically having side-by-side KPIs when selecting multiple Scenarios
• display multiple metrics of a Table without creating multiple views

Pro tip: Application variables used as CI/SVA KPIs (Variance KPIs) are updated dynamically!

Amateur tip: KPIs stand for Key Performance Indicator.

Now you can apply filters on your Blocks from Block Explorer!   

This will allow you to easily identify Shared Status for Blocks, as well as more advanced features for Metrics and Tables.   

In Metrics, you can identify the Data Type, Formula status, including if overrides are on, and even the Dimensions in the structure.   

Tables allow you to select a Metric and see which Tables it's used in! 

Pigment is excited to release a new connector for Amazon Redshift that allows you to import directly from the database or cluster.   

You can read more about it here or search within our Connectors section on our community!

If you did a search outside our community you might also learn that Redshift is also a term used by astronomers when light is stretched and shifted to the red part of the spectrum. 🌈 The more you know 🌈 

Pigment now has a dedicated Formula Playground Permission that will allow anyone to try their hand at working with Pigment formulas.  Users can be given this permission to explore their data in new ways while also learning about Pigment formulas!

Users with this permission will still need the Configure Block permission to be able to create Metrics. 

Your order is on its way! This time, it's not from online shopping, even better. It's the ability to order your page selectors on Boards. 

When editing a Board, click on the page options icon, then you can drag and drop your page selectors in the order you want them. 

As new page selectors get added they will show up at the end but you can always adjust. The order of page selectors within a widget can be controlled by their order from the pivot of the saved view

Keep your Metric's Inputs and Imports in sync across All Scenarios with this latest setting, Inputs and Imports populate data across All Scenarios. 

Now you can say "Bye Bye Bye" to the days of having to input the same data across every Scenario within a Metric. 

Once activated, your Imports and Inputs will populate data across every Scenario, this I promise you.

This setting works with formula overrides, so overrides are applied to every Scenario.