Pigment Product Updates logo

Product Updates

Fresh from Pigment! Read our latest Product updates and share your feedback!

Subscribe to Updates

Labels

  • All Posts
  • new
  • Improvement
  • Announcement

Jump to Month

  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
Changelog byAnnounceKit

Create yours, for free!

a year ago02/16/2021

Create List from CSV files 📃

new

  

You can now create, configure and load data in your new lists using the Create from CSV… feature.

createlistfromcsv.gif

Avatar of authorPierre Van Roy
a year ago02/12/2021

Formatting negative values

new

  

You can now choose to display negative values with the minus symbol or between parenthesis. This option is available in the Configuration panel, under the Display options:

image.png

Avatar of authorBen
a year ago02/11/2021

Thousands, millions and billions 🔢

new

  

Displaying data in thousands or millions has never been so easy. In just a few clicks, you can format your values as you wish.

Open the Configuration panel, then Display options. You can chose to display your values in thousands (k), millions (M) or billions (B):

image.png

Avatar of authorBen
a year ago02/11/2021

Inverting values ➖/➕

new

  

You may need to use the same metric in multiple tables. But you may want to display it differently from one table to another.
Take costs for example. You may want to display them as negative items in a P&L but as positive items in cost analysis or reviews to ease the reading. On Excel or other softwares, you would need to duplicate your metric and multiply it by -1.
Here, we created a feature called "Reverse signs," in the Display options, so that you can reuse a metric and simply toggle this option if you need to invert values :

image.png

Avatar of authorBen
a year ago02/08/2021

Show value as... %

new

  

When looking at numbers, we often need to calculate ratios. Previously, the only way to calculate a ratio was to create a new block (property of metric) and input the formula ratio in the formula bar.

To make this easier, we created a Show value as… feature. You can now calculate ratios in just a few clicks, rather than using a formula.

To access this feature, right click on the header of any metric:

Screenshot 2021-02-08 at 23.39.35.png

Avatar of authorBen
a year ago02/05/2021

Filtering dates 📅

improvement

  

You can now filter dates using any logical operator (inferior, superior, inferior and equal, superior and equal):

Screenshot 2021-02-08 at 23.43.11.png

Avatar of authorBen
a year ago02/01/2021

New aggregation functions ∑

new

  

When you need to calculate some simple statistics of list items, values in list properties or values in metrics, you can now use a new series of functions called Aggregation functions:

  • COUNTOF
  • COUNTALLOF
  • COUNTBLANKOF
  • COUNTUNIQUEOF
  • SUMOF
  • MINOF
  • MAXOF
Avatar of authorBen
a year ago01/19/2021

Column width improvement ↔️

improvement

  

It was already possible to resize column width using add and drop.
You can now resize each property in lists and each metric in tables independently.

Avatar of authorBen
a year ago01/18/2021

Applying format and style to metrics 🎨

new

  

In the configure panel of any object, you will now see a switch button allowing you to select either Data or Display.

Display options allow you to change the formatting (number formatting and cell style) by metric.

Avatar of authorBen
a year ago01/11/2021

Tagging users in conversations 🏷️

new

  

You can now start tagging users in a board conversation.
In any comment, type @ followed by any letter to search a user in your workspace.

Once your message is posted, the tagged user will immediately receive an email with a direct link to the board that was commented, and access to the conversation.

You'll be notified whenever you receive a message.

Avatar of authorBen