Previous period for metrics

  • 12 January 2023
  • 2 replies

Userlevel 2
Badge +2

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 :)


Best answer by francois 12 January 2023, 20:31

View original

2 replies

Userlevel 6
Badge +13

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!

Userlevel 6
Badge +10

Hi Guillermo,

Typically the previous function is involved in building a cash flow

PREVIOUS function | Community (

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

Previous value & Circular Reference | Community (