avg method

Expression<DateTime> avg(
  1. {Expression<bool>? filter}
)

Return the average of all non-null values in this group. To only consider rows matching a predicate, you can set the optional filter. Note that filter is only available from sqlite 3.30, released on 2019-10-04. Most devices will use an older sqlite version.

Implementation

Expression<DateTime> avg({Expression<bool>? filter}) {
  final avgTimestamp = unixepoch.avg(filter: filter).roundToInt();
  return DateTimeExpressions.fromUnixEpoch(avgTimestamp);
}