SQL windowing functions in looker

[kuopaz]

I’m sure this question has been asked more than once in the past - but is there any plans to incorporate windowing functions, without using a derived table. They are incredibly useful (I’m using SQL Server), so a big restriction.

With a derived table, you will often want to pass the runtime filters on the explore to it (and there could be many dimensions, with new ones added at any time). A native derived table with the SQL windowing function in a derived column and bind_all_filters get’s around this. But it cannot of course be a PDT so performance will take a big hit.

[kuopaz]

This isn’t a deal breaker - because Looker is so good in many other ways - but it comes close.