AnsweredAssumed Answered

Dashboard KPI development

Question asked by AlbertoColombo on Nov 7, 2017
Latest reply on Nov 9, 2017 by AlbertoColombo

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?

 

Alberto

Outcomes