Fresh from Pigment! Read our latest Product updates and share your feedback!
We introduced several shortcuts from headers to increase modeling and reporting productivity. Now and directly from grid headers, you are able to:
Tree View available for Tables and Metrics!
A new layout has been added to Metrics and Tables so that you can display row headers as a tree.
You will now have the possibility to switch between the Tabular Mode and the Tree View Mode.
The Tree View will display within the same column the Metrics and Dimensions that have been selected in the Table. Expand/Collapse functionality is available directly on the row headers thanks to + / - icons.
The option "Show Totals on first row" is enabled by default in this mode and can be disabled from the same panel.
With the new formatting option "Apply to Grid header(s)", you can now format any cell of a grid.
To find this option Right click on any header > "Format cell". Once you configured the formatting you want, check the "Apply to: Grid header(s)" box in order to apply the formatting also to the grid header.
Now the History Tab has a new category "Block settings" which allows you to better track the models updates.
Here is the list of new changes which will be tracked:
Easily highlight key data points on Boards thanks to the new KPI widget. The KPI widget allows you to display a single numeric value in a formatted text and to complement it with a small description.
In order to successfully display a KPI you have to create a KPI view first. There are two ways to create a KPI view:
OR
Once you have created your KPI compatible View, add a KPI widget directly from Boards by clicking on the new KPI widget.
Arrange the layout of Tables based on the Dimensions you really need.
It is now possible to customize the layout of Tables so that Dimensions are only displayed when relevant.
This means that the Pigment platform is now able to display the figures as they are defined on the original Metric. We have removed the previous behaviour that used to implicitly aggregate or split the figures in order to match the Dimensions that were available in the Table.
Use the option "Densify headers" in the Layout panel of Tables to make the row headers as compact as possible, fitting them on the same column. For instance, if your Table contains four Dimensions but each Metric displays only two, the Table layout will only display two row headers instead of four.
You can now have the same dimension in both Page selector AND Row/Column!
This is very useful on board to make sur that all widgets are filtered based on the global page selector even if the dimension is used in row or column.
The multi-dimensional aspect of Pigment's formula language is powerful but sometime can be misleading. Indeed, dimensions of the formula are "aligned" with dimensions of the metric where it's entered.
With the Formula Preview, Pigment offers a tool which allows you to test some formulas in a "sandbox". In Formula Preview, the Type and Dimensions of your block are deduced from the formula.
The data Flow between the different blocks of your application can be hard to understand when you start having lots of blocks.
To help you with this problem, we just released the Dependency Diagram!
To access it you can click on the Dependency Diagram icon on any view or directly from the block explorer.
You can now add Items at a specific position of a List. Click on "Edit List" and then on the three dots next to the position where you want to add the new item to find the actions "Add item above"/"Add Item below"
