Now you can update your Transaction list in small sections by deleting existing Transaction list items in a limited scope and replacing them with new items from an import.  

This will allow you to update your Transactions list by a particular month, product, or any other property with a dimension data type!  

Now if only I could delete existing credit card transactions from online shopping while consuming wine. 

Read more about how to Delete existing items in our community.

We have added two great new features around Access Rights. 

Now the Dependency Diagram has the ability to show a user's Access Rights for all Metrics.  Users with Define Application security permission can now activate Show access rights. Metrics will turn green for Full Access, yellow for Partial Access and red for No Access. You can use the dropdown to easily switch between other users.

The second upgrade is that there is now an Access Rights section in the Block's settings panel. Now, you can quickly identify the Access Rights Rules, any metric's where Access rights are being inherited, and the Dimensions applying these Access Rights for a block.  

Read more about the inheritance of access rights

If you ever wanted the ability to quickly search all available blocks in an Application, add new blocks in seconds, or navigate to the latest shortcuts. Well your wish is our command... palette 

Typing cmd/ctrl+k opens the Command Palette. 

Once opened, you can search throughout your entire application, or open at the Workspace level to search for other applications.  

Depending on your Permissions, you can also create Blocks from the Command Palette. Learn more here.  

Now when you select to Automatically add new items to dependent Dimensions during an import, you can select which dimensions you want to create new items in.   

Because sometimes you don't want certain lists to grow. 

Hide and seek is not a game you want to play with your data.

Previously, if you wanted to hide empty rows or columns in Pigment, you had to hide both.  

Now you can hide empty rows or columns separately, the only thing you won't be able to hide is your excitement!

I was tempted to put in a pun for excluded but this time it's left out. 

Pigment now has a new modifier available: Exclude. This modifier allows you to exclude data based on the source block (Metric or List Property) based upon criteria set up in the modifiers parameter. 

Learn more about the different ways you can use EXCLUDE

You've heard of Farm to Table but what about Pigment to Presentation!  The new Pigment Connector for Google Sheets makes updating your presentations easier than ever. 

Simply install the connector to pull data into Google Sheets from Pigment. Next, you can create charts or grids in Google Sheets that are easily placed into Google Slides!   The Pigment connector also allows you to push data back into Pigment!  

Our new multi-cell selection formatting is guaranteed to make you smile!🙂 

Now, you can select several cells and format them at the same time. Just make your cell selection, then right click and choose "Format Cells".

Hold down the Ctrl/Cmd key to make multiple selections.  Then you can format or even paste data into the selected cells!

This is not a drill, it's an update to Drill Down by and Drill to Transactions, they are now available on charts!

You can use Drill Down by to see how your data is impacted by different dimensions used in your chart. 

You also have the ability to use the Drill to Transactions to see which transactions were part of that calculation.

That's right, now you can import a CSV to invite multiple users into Pigment at the same time!    

Finally, you can email the whole company without anyone being able to Reply All.

When inviting new members, click + Invite with CSV, then you can upload a CSV with all the newest members.  We even have a CSV template to make it easier for you!