Skip to main content

Hi Pigment team,


I need your help on creating a metric that reflects the values of prior period for a given metric, in a flexible way that allows me to change to quarters, months and doesn’t lose accuracy when aggregating.

Thanks for your help :)

Hi Guillermo,

Have you tried using a Show Value As? Next to that highlighted metric, you can click on the three dots to get to the contextual menu, click on Add this metric again. This will add your Cash Closing Balance metric a second time in the view. With that new item, open the contextual menu again and select % Show value as… > Last Year

 

Here’s the result I get with a metric I had at hand.

This should also work with any aggregators!

Hi Guillermo,

Typically the previous function is involved in building a cash flow

PREVIOUS function | Community (gopigment.com)

You can look at my guide on how to use it to do something very similar

Previous value & Circular Reference | Community (gopigment.com)

 

 

Reply


Ask your question here!

Terms & ConditionsCookie settings