avg method
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);
}