Compare Currently Monthly Flow to Last Months Monthly Flow

I have a display that shows total pump flow for each month using a Trend and Value symbol. It uses last months total as the target. Instead of looking at last months total as the target, I would like to look at the total for last month at the same date as the target - as this gives a much better indication of current total flow compared to last months performance.

 

Example

Current Target

Oct 2, 2024 - 150m3

Sep 30, 2024 (total) - 10,000m3

 

Target = -98.5% ((150-10000)/(10000))

 

Desired Target

Oct 2, 2024 - 150m3

Sep 2, 2024 - 120m3

 

Target = +25% ((150-120)/(120))

 

Is there a way I can create a tag in PI AF for this? Or even a way in PI Vision I can do this?

 


image.png