How to use "periodOverPeriodDifference" with today's date?

[msnehali]

Hi @July
I checked into it and could find a way to represent it in KPI referring Dylan’s calculation, you check this below link:

Period Over Period Calculations

Hello @Ozzy, I totally understand how the period over period calculations can be difficult, so I will do my best to help. Also, thank you for taking the time to put the data into an analysis in Arena, that makes it a lot easier for me to help you. The first thing that I noticed is that your final_report_date is showing as a string field and not a datetime field. I’m not sure if that is the same in your actual analysis, but if it is, it will complicate some of these calculations. Another thing t…

I used the below Calculation:

Lag function to get PeriodOverPeriodDifference (test-popd):

lag({calculated-field},[Timestamp ASC], 1) - {calculated-field}

Using Lag, I could get the previous month value returned, and then I subtracted it from current month value. You can refer to my test below and represent it in KPI using the similar KPI options

Hope this helps! Thanks.