I'd love to be able to use first or last values to aggregate a mean metric, in addition to sum & max. I know it'd require a window function instead of just group by, but it'd be a helpful alternative to max.

This is in our backlog, thanks for raising it. It does require slightly more complex logic, but I think it definitely has it's uses!