Introducing Sheet View, combining the flexibility of spreadsheets with the power of Pigment.  Learn more about how to use this great feature or watch the video above.  We know you are going to love this sheet. 

Our Application explorer page can now be displayed as a list, sorted both alphabetically and by date created, as well as filtered by owner.  

These explorer upgrades make finding Applications so easy even Dora the Explorer would be screaming "It's right there!" 

Now when importing into Pigment, you can add an additional value to your source. 

The Additional constant value feature allows you to add a new mappable column with one value to your file.  Within the 1st step of the import, simply name the source and enter the value, then the column and data will be available to map in step 2.

If you are looking for ways to add additional value to your team meetings, try giving everyone nicknames.  Don't worry chief, everyone loves nicknames. 😀 

We have added 3 new Show Value as options.  Now you can show value as a percentage of a parent. There are three new options, % of Parent total, Parent column total, or Parent row total.   

Parent total lets you choose which dimension or grouped dimension's total to use as the parent, while the row and column totals use the location of the dimension within the pivot to define the parent.

Test it out or read our documentation if it's not apparent. 

We made some great updates to our formatting.

• Formatting in the right hand side panel now has the same options as when you right-click on a header or cell.
• New Reset icon returns all static formatting options to default; white cells, black text,  gray headers, and removes all value formatting.
• New focus style that pulses on selected cells.
• New Select all cells option
• Repeated items option to format every instance of an item or metric. 
• CTRL/CMD + Click to select multiple metrics, replaces Metric select dropdown. 

The new Automatically generated unique ID option in Transaction and Dimension lists is here!  Once toggled on, each item in a list will be assigned a unique integer that increases with every new item created. 

This option is only available on unique properties with a data type of Integer.

Heading into the new year, we decided to introduce a new header feature. 

Now you can use cmd/ctrl + mouse clicks to select multiple headers in columns and rows to expand or collapse them at any time.

It's currently not available while directly on a Board, unless you are editing it, but we are working on it!

If your New Year's resolution was to use more Calculated items, I have a nice surprise for you! Now you can create calculated items on stacked or grouped items.

Easily create Calculated items at the Quarter and Year level for Metrics set up on Months. You can also use it when you stack two dimensions in either the rows or columns of a Metric.

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 😉.