Hi @July
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.
2 Likes
