I really would like to see (although computationally difficult) the median value as an added option of Datalink's calculated data.
We often run into bad data that creates outliers in the overall average calculation (skew) which median values would be more robust than averages (say we are comparing daily averages to a year's data, in which daily averages could be replaced by daily medians.
Workaround: filter the daily averages so that a minimum percentage of good data are met before averaging are done?
Just a thought and to enhance further the Excel's datalink add-in.
Thank you Osisoft!