Median of input values.
Syntax
Prefix Median(expression)
- expression: signal expression
- Prefix
- TIME for calculation of the median for all time steps for one entity (default setting, can also be neglected)
- Time Median("x" in "unit") function returns the median i.e. of all the elements within the given time range.
- ENTITY calculation of the median for all entities at one time step (has to be placed in front of function if needed)
- Entity Median("x" in "unit") function returns the median i.e. of all the entities for a given time step.
- TIME for calculation of the median for all time steps for one entity (default setting, can also be neglected)
Example
Time Median("produced water per time increment" in "STB")
alternative version:
Median("produced water per time increment" in "STB")
As you see in the following table the Median function produces following output based on the 'original signal' as input:
Date/Time |
Original Signal |
Time Median |
01.02.2007 00:00 |
8 |
14 |
01.03.2007 00:00 |
0 |
14 |
01.04.2007 00:00 |
15 |
14 |
01.05.2007 00:00 |
22 |
14 |
01.06.2007 00:00 |
24 |
14 |
01.07.2007 00:00 |
13 |
14 |
01.08.2007 00:00 |
27 |
14 |
01.09.2007 00:00 |
6 |
14 |
Entity Average("produced water per time increment" in "STB")
As seen in the following table the Entity Median function produces following output based on the 'original signal1' and 'original signal2' as input:
Date/Time |
Original Signal1 |
Original Signal2 |
Entity Median for signal1 |
Entity Median for signal 2 |
01.02.2007 00:00 |
8 |
#NULL! |
8 |
8 |
01.03.2007 00:00 |
0 |
#NULL! |
0 |
0 |
01.04.2007 00:00 |
15 |
19 |
17 |
17 |
01.05.2007 00:00 |
22 |
12 |
17 |
17 |
01.06.2007 00:00 |
24 |
34 |
29 |
29 |
01.07.2007 00:00 |
13 |
19 |
16 |
16 |
01.08.2007 00:00 |
27 |
15 |
21 |
21 |
01.09.2007 00:00 |
6 |
19 |
12.5 |
12.5 |