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.