lastval

lastval — aggregate function to return the last value from a specified column.

SYNOPSIS

lastval (expr)

DESCRIPTION

This function returns the last non-null value, if any, in the range of values returned by its query predicate.

Expression expr must contain the name of a column in a LiveView table. The returned last value is of the same type as the specified column.

If the query returns no rows, the aggregate returns null.

SEE ALSO

This LiveView aggregate function is based on the lastval aggregate function in the StreamBase expression language.