Median calculates the median value in specified period.
The median is the numerical value separating the higher half of a data sample from the lower half. The Median is the "middle number" in a sorted list of numbers.
In practice, Median can be a useful smoothing function to remove erroneous spikes in data more effectively than other moving average functions.
Defines the time series data fed into the function. This can be a sensor ID or another function.
Number of data intervals considered in the function
*Input data is optional in most cases. If Info360 detects that the first input is time series data, it will be applied to the function. Otherwise, the current active sensor's data will be used, which is often the case in Reference Charts.
Example Usage as an Expression:
Median(99): Finds the median from the last 99 intervals
Example Reference Chart:
The following example shows a comparison of pump flowrate data and multiple moving average methods with the same period.
The TMA method displays the smoothest line with the most delay from the original signal, while WMA most closely follows current data.
Regression responds the fastest to sudden changes in measured values, but this also makes it the most sensitive to spikes in data.
The Median function preserves the on/off gradient in the data the best, but it will be offset by half of the selected period. Median is the best for throwing out spikes in data that don't fit the primary trend.
Also note that EMA and TMA provide dampened smooth values for a longer window than the input period.
For information on setting up custom equations and syntax, please refer to Analytical Functions.