Latest Queries
Latest
Returns the most recent past value for a given feature
Syntax:
Latest(feature
[by feature(s)]
[where condition]
[after time]
[last duration])
Code Examples:
Latest(ip by user where successful)
Latest(user by ip, user_agent last 10 minutes)
Latest(sku by account where price > 2000 after latest_billing_change)
Data Example:
_time | user | ip | Latest(ip by user) | Latest(ip by user last hour) |
---|---|---|---|---|
9:40AM | anna | 1.1.1.1 | null | null |
10:20AM | brad | 2.2.2.2 | null | null |
11:00AM | anna | 3.3.3.3 | 1.1.1.1 | null |
11:40AM | anna | 1.1.1.1 | 3.3.3.3 | 3.3.3.3 |
12:20PM | anna | 4.4.4.4 | 1.1.1.1 | 1.1.1.1 |
LatestTime
Returns the most recent past event time for the given clauses
Syntax:
LatestTime([by feature(s)]
[where condition]
[after time]
[last duration])
Code Examples:
LatestTime(by user where successful)
LatestTime(by ip, user_agent last 10 minutes)
LatestTime(by account where price > 2000 after latest_billing_change)
Data Example:
_time | user | LatestTime(by user) | LatestTime(by user last hour) |
---|---|---|---|
9:40AM | anna | null | null |
10:20AM | brad | null | null |
11:00AM | anna | 9:40AM | null |
11:40AM | anna | 11:00AM | 11:00AM |
12:20PM | anna | 11:40AM | 11:40AM |