Question about aggregation

[Bar Shalev]

Hi,
I want to create two column aggregation type:
1.Average.
2.First/Last aggregation column ordered by *another column* and not by
timestamp.
Is it possible? If yes, how?
I read a lot and there is no answer for that in your docs.

Thanks,
Bar Shalev