Hello!

We are working on a KPI system which should calculate specific energy consumption for time periods.

The AF Attribute would be a good way to do it [Attr1:Energy Consumption(TimeMethode: TimeRange, Total) // Attr2:Feed(TimeMethode: TimeRange, Total) // Attr3:Specific(Function: Attr1/Attr2)].

This calculattion is fine in CoreSight, but our users prefer Datalink+Excel+Excel...+Excel for everything.

So my question is, how AF time context can be handled from Datalink? What Datalink function should we use to get the AF attribute with a given Time Context. Thank You in advance for your help.

I believe you asking for a totalization for a couple of attributes and then a simple ratio.

If so, you can use the Datalink Calculated Function. It has various modes, one of which is total. Datalink is unaware of units of measure (even for AF attributes), so it will need help on the total. It assumes the units are per day. If you have something different you will need to adjust using a conversion factor. Say you had gallons per hour, then the conversion should be 24.

This is explained here for PEs, but it works the same for Datalink. Note in the new Datalink 2015, this is changed to be easier to set.

OSIsoft: Use the conversion factor field when doing a total calculation in PE. v3.4.375 - YouTube

Below is a screenshot of the DL Calculated function using total.