Page Comparison

...

This operator requires the lhub_ts column. It first orders rows by the lhub_ts column and then computes the difference between consecutive rows.

Operator Usage in Easy Mode

1. Click + on the parent node.
2. Enter the Find Difference operator in the search field and select the operator from the Results to open the operator form.
3. In the Select Baseline drop-down, enter or select the baseline to pull data from.
4. Optional fields
   Start Time: Enter an offset time or a specific start time to pull the data from. Offset time
   allows you to set time in seconds, minutes, hours, days, or weeks; Specific time allows you to
   select the date and time.
   End Time: Enter an offset time or a specific end time to pull the data from. Offset time allows
   you to set time in seconds, minutes, hours, days, or weeks; Specific time allows you to select
   the date and time.
5. Click Run to view the result.
6. Click Save to add the operator to the playbook.
7. Click Cancel to discard the operator form.

Usage Details

LQL Command

findDiff(table, column)

...

Output
The input table with an additional column with the _diff suffix.

Example

Input

...