OSIsoft: Get time-summary calculations with PI Calculated Data function (PI DL 2013 Excel Add-in)

[00:02] What is the PI Calculated Data function?
[00:42] Why use PI Calculated Data instead of MS Excel functions?
[02:06] Add a Calculated Data function: select data item
[02:36] Add a Calculated Data function: Specify start & end time
[03:00] Add a Calculated Data function: Link cell references
[03:25] Add a Calculated Data function: Specify time interval
[03:51] Add a Calculated Data function: Show time stamps
[04:31] Formatting tips for Calculated Data functions
[05:22] Copy & paste Calculated Data functions
[05:56] Speed up your spreadsheet by clearing raw data

The PI Calculated Data function allows you to calculate the Minimum, Maximum, Standard Deviation, Range, Average, Count, or Mean of the PI System's timeseries data.

Video content is copyright of OSIsoft, LLC © 2013. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is prohibited other than for your personal and non-commercial use.

[andytallman]

Thanks for this. Question: What is the difference between mean and average in the Pi calculated data? I would expect them to be the same but I'm getting some very different values and I don't know why.

[veronese]

Hello.
I am having difficulty calculating the average of the last 4 h of the variable 'FIC-02' on the date stipulated in the column 'DATE'. For example:


DATE TAG VALUE 'FIC-02'
01/01/20 06:00 ?
01/01/20 14:00 ?
02/01/20 15:00 ?

[Angkoki]

I have year data that i need to know total time in min that flow have been over 0m3/h (it's to find operation time). How can i do it? I have time to use filter expression but when it comes to concersion factor and calculation mode. i dont sure what to do.