Hi, I am new on PI AF development and I am developing a dashboard to show some KPI.
I need to develop a running KPI which shows "consumption saving" year (2017) over year (2016) of a "consumption" data series. So, I should calculate:
running KPI = [Total Consumption for 2017 = sum of value from Jan-1 2017 until 'today')] - [Total Consumption for 2016 = sum of value from Jan-1 2016 until 'same day of today in 2016')
I made some try with Analysis and Formula, but i am looking for the best way to develop the KPI without any hard coded value to have a valid KPI also for 2018, 2019 and beyond without any huge amount of changes.
Can someone suggest me the best solution to use?