Add Aggregation function first and last

Dear sir:
we are so excited in the process of using metabase, after multiple trials ,we have an strong need for "Last " or "First" a ggregation funtion, so,Is it possible to add this aggregation function in this project ?
%E5%BE%AE%E4%BF%A1%E5%9B%BE%E7%89%87_20210409164658

Hi @dxw
What is "First" and "Last"? Can you point to the documentation of a database that supports such?

@flamber just like this https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms155794(v=sql.90)
in microsoft report services

@dxw "Last" and "First" functions are not supported in newer versions of MSSQL. They have been replaced with "LAST_VALUE" and "FIRST_VALUE", which would require that we supported windowing.
https://github.com/metabase/metabase/issues/9393 - upvote by clicking :+1: on the first post