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 francoisView original
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!
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)