new

  

Pigment now keeps track of all data updates done on block (List and Metrics) so that users can find who did a specific change and when.

Here are actions tracked:

• CSV import
• Edit (Manual input)
• Formula update
• List Item deletion

---

Read more on Pigment's Help Center

improvement

  

Pivot your data faster thanks to improved drag and drop capabilities that works on:

• Pivoting Dimensions in Metrics and Tables
• Reordering Metrics in Tables
• Reordering Properties in Lists

When dragging a block, the allowed drop placements are highlighted by a blue background color.

---

new

  

Collapse grouping dimensions when you don't want to display the highest level of granularity:

---

Read more on Pigment's Help Center

new

  

We are proud to announce the release of a new chart type: the Waterfall Chart. Ideal to explain variations between 2 data points (scenarios, years, etc.) according to dimensions of your model (country, department, etc.), Waterfall Charts are now super easy to build with Pigment.

---

Read more on Pigment's Help Center

new

  

New shortcuts have been released to improve the navigation in grids:

• press ctrl + keyboard arrows (Win) / cmd + keyboard arrows (macOS) to go to the far end of the grid.
• press ctrl + A (Win) / cmd + A (macOS) to select all the cells of a grid.

improvement

  

New Show Value As are available:

• difference from an item: calculate the difference between the current item and another one, fixed or relative (ex. display the month over month value or the difference with the first month of cohort)
• difference from another metric: return the difference between 2 Metrics in a Table
• % growth from an item: calculate the difference in % between the current item and another one, fixed or relative (ex. display the month over month growth or the growth from the first month of cohort)
• % growth from another metric: return the difference in % between 2 Metrics in a Table

---

Read more on Pigment's Help Center

new

  

You can now use color scale (up to 3 steps) to highlight trends or outliners in your Metrics. Simply right click on a cell or header, then Conditional Formatting and select Color Scale.

---

Read more on Pigment's Help Center

new

  

Calculated items are available and it is a big news 🎉!

Do you need to calculate the variance between 2 scenarios, 2 time period or 2 countries?

Now you can apply calculated items on any dimension of a Metric or Table and directly in Views without entering a single formula.

This feature currently offers 3 operations:

• absolute difference (A - B)
• relative difference (A - B) / B
• ratio (A / B)

---

Read more on Pigment's Help Center

new

  

The new Block Explorer is now providing a lot of useful information for a better modeling experience and Application documentation:

• we replaced the block type filter with a tab-style component
• we added the key characteristics about your Application's Blocks in columns(and more will come in the next releases)
• those characteristics can be sorted and some of them are interactive (you can click on a dimension of a metric directly from the Block Explorer)
• we increased the density of information by reducing the height of each Block

 

improvement

  

• in new Applications, Calendar blocks (like Month, Quarter, etc.) and Security blocks are automatically filled into dedicated folders
• Metrics created from Tables are now also filled into the same folder as that Table
• we changed the coloration of each block for better readability and introduced a new icon for Transactions Lists.

---

Read more on Pigment's Help Center

improvement

  

• Re-ordering List Items can now be done in a single action for all the items of the list by using any property of the list. Click on Edit List and follow the screenshot:
  
  
• We also added the option to add a description to Lists to better document your Applications.