Difference (Analytic Filter)
Description
The Difference filter is used to calculate the difference between the minimum and maximum value in each row of your data.
Parameters
| Name | Default | Meaning |
|---|---|---|
| Column | Difference | The resulting column name |
Example
<filter type="Difference"> <column>DiffTemperature</column> </filter>
Calculates the maximum difference between the columns and places it in the DiffTemperature column
Incoming
| Index | Random Field | More Random Field |
|---|---|---|
| 07:00:02 | 25 | 33 |
| 07:01:02 | 29 | 35 |
Outgoing
| Index | DiffTemperature |
|---|---|
| 07:00:02 | 8 |
| 07:01:02 | 6 |