| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Find the difference in the values between rows and save them in a new column (inputColumn_diff).
...
Output
The input table with an additional column with the _diff suffix.
Example
Input
lhub_ts | bytes_out |
|---|---|
1 | 30 |
3 | 10 |
2 | 20 |
LQL command
| Code Block |
|---|
findDiff(table, "bytes_out") |
Output
lhub_ts | bytes_out | diff_bytes_out |
|---|---|---|
1 | 30 | 0.0 |
2 | 20 | 10.0 |
3 | 10 | 10.0 |
The output table is sorted by lhub_ts, and difference is calculated between consecutive rows.