Adding an item to your bucket list has never been so simple! 

Now, when you publish a list to a Board, users with the correct permissions can add items to that List without having to edit the Board! 

Read more about it here.

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.  

Stay tuned for more documentation

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.  

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!

A pun about Linear Regression is where I draw the line. 

Linear Regression is a statistical function that allows you to predict a set of values based on past values or on another set of values. It's a handy metric for forecasting and predicting metrics. 

For more information about the Function and how you can use it in Pigment, please visit this article.

We all have favorites: foods, sports teams, and children. Now you can Favorite Boards or Blocks in your application.  From All Boards or All Blocks you can hover over an object and select the star to add.  You can also click the ellipsis ... next to an object on the sidebar to add!