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?