new

  
Need to substitute part of a text by another ?

The SUBSTITUTE function is for you!

improvement

  
Use the additional options of the "Add Item" button to add any number of Item to your List in few clicks.

new

  
You can update your model 100x faster than before by selecting multiple Blocks in the Block explorer. You are now able to:

• Move multiple blocks to a folder and create a new folder on the fly,
• Share multiple Blocks at once

• Delete multiple Blocks at once

  

improvement

  
Do your numbers vary widely from series to series? Visualise a more appropriate scale for each series by activating the secondary axis option.

Activate Secondary axis option on Combined Charts > Line settings to plot line series on a secondary axis.

---

Read more on Pigment's Help Center

new

  
You knew that you could hover a Block in the formula bar to get more information about it.

Now, you can also hover a function to get its description. And if you need examples, click on Learn more to access our Community.

new

  
Connect Pigment with NetSuite and load any Saved Search data into Pigment.
Configure the connection in the new Integrations Library Page.

And use this connection as data source.

More integrations coming soon!

---

Read more on Pigment's Help Center

new

  
During your modelling, you might realize that a List should have been created in a different Application to better fit your multi-app architecture.

Now you can fix this problem with a single click. Open the List Settings panel > "General" tab and click on "Move List to another Application"

Note: this action will change Access Rights which are applied to this List.

---

Read more on Pigment's Help Center

new

  
To ease up your modelling, 5 new functions have been added to Pigment's formulas:

• MOVINGAVERAGE
• MOVINGSUM
• SHIFT
• ISDEFINED
• DATEVALUE

Check their respective documentation for more details.

new

  
Visualise bars, lines and dots on the same Chart with Combined Charts.

Configure which items are displayed as bars or lines in the Combined Charts Format Panel. Items available in Series are the ones displayed as Rows in the Configure Panel.

You will also be able to choose how you want to visualise line items with the "Line settings display" option: lines with or without dots, only dots or flat lines.

---

Read more on Pigment's Help Center

new

  
So far, when removing the Dimension from a View or when selecting multiple items from a Page Selector, Pigment was aggregating the Dimension using a SUM.

With the new version of the Total panel, now called View Aggregators, you can set any aggregation method allowed for the Metric's Type, like AVG, MIN or MAX for Numbers.

The setting and calculation is done for (1) all the non-time Dimensions (2) the time Dimensions.

With this release we also introduce a shortcut to copy a Total or Aggregator to all other Metrics that have the same Dimension in the View.

---

Read more on Pigment's Help Center