I want window functions that can be called in the calculated field view. This way you can include them in filters. This is what I mean by explicit.
A Lag or lead function appears nowhere I have looked. It would make assignment log tracking much easier.
Being able to filter by top 5 would help me out quite a bit. Managers and directors love stuff like 'TOP 10 Issues'.