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

That is pretty good because you are off by a factor of 96!!! Of course, 24

4 = 96.

The factor of 4 is because you are summing 15 minutes of data (4 values an

hour). Are you trying to get the total kW from the kWh? If so, you will

want to divide by 4 on your spreadsheet since you have 4 samples per hour.

You are right about a conversion factor. PI assumes units per day and

there are 24 hours in a day. To get the total kW per day, you will have to

use a conversion factor of 24 (multiple the total by 24). It appears you

are using an event weighted total for the spreadsheet. This is working

fine since all the data is 15 minutes apart on the spreadsheet so it is all

given equal weight. PI is using a time-weighted total.

Without knowing all the details I would recommend:

Dividing the spreadsheet by 4.

Multiple the PI equation by 24.

Regards,

Dan