SUM with Show value as and Calculated Items
We have added SUM thing new to our Show value as and Calculated Item calculations. Now you can add together two Metrics using Show Value as or two items or item groups with Calculated items.
Fresh from Pigment! Read our latest Product updates and share your feedback!
We have added SUM thing new to our Show value as and Calculated Item calculations. Now you can add together two Metrics using Show Value as or two items or item groups with Calculated items.
We are happy to announce two new finance functions!
IRR (Internal rate of return) and XIRR are used to analyze the rate of return for an investment.
These two new functions paired with NPV and XNPV can be used to formulaically analyze future investments verse trusting your gut and ending up with 1000 Beanie Babies.
The new Formula Wizard, located in the Formula playground, guides you from a Transaction list to Metric results in four easy steps. This is a great way to add structure to a Transaction list to gain insights and master the BY modifier at the same time.
*Pointy hat and wand not included.
**Don't tell your boss you are a wizard on a playground.
Now all Members can export Board widgets as PNGs to be able to easily add to your reporting presentation. You can also copy the widget to your clipboard as a PNG for faster use. Simply hover over a widget, then select the more options button (...) to access to Copy to clipboard an Export as PNG options.
Can't top these new filter options. When filtering with Metric values of integer, number or dates, you can choose to filter items in either the top or bottom brackets.
To apply to a Table or Metric, simply select to Filter on Metric Value, then choose is in the top or is in the bottom, then define the size of your bracket.
Setting your top 8 has never been so easy!
We've expanded the ways all Members can interact with their Boards with this latest upgrade!
Now you can expand and collapse grids directly from the Board, without having to edit the Board. This will put the view into a draft mode that can be saved by those with the relevant permissions.
Try it out! Either click directly on the +/- icons or right click on a header to expand/collapse one or all Metrics/Items!
These new changes have transformed how your views are edited on Boards. Check out our latest article to see all the other ways Members can interact with Widgets on a Board.
We have improved our Board permissions with new additional options. Now Members with the Can configure permission can limit the features available to users with the Can comment and Can open Board permissions.
There are two groups of features that can be toggled off: Block exploration and View customization. Block exploration controls features that allow Members to deep dive into data and View customization controls temporary changes to grids.
I wanted to write a pun but I didn't have permission to.
We are happy to introduce two new finance functions, NPV and XNPV.
NPV calculates the net present value of an investment based on future cashflows evenly spaced for a given time.
XNPV calculates the net present value of an investment based on future cashflows on specific dates for a given time.
You down with NPV? Yeah, you know me!
It's almost Pigment’s FP&A Week: The Rise of the CFO. This March 27th to 31st, attendees can participate in a week of insightful sessions, exploring the people, processes and products leading the FP&A revolution.
Hear from speakers at Netflix, Tableau, Motive, Looker, and Dropbox.
Register now!
Pigment now supports SCIM as a new secure way to manage, add and deactivate users, directly from your Identity Provider. SCIM stands for the System for Cross-domain Identity Management, it does not stand for Secretly Coded In Magic. Feel free to skim through our documentation.