ROW_NUMBER OVER (PARTITION BY ...) with a table calc

Hey,

I Have table calc column of yesno type. I want to create new table calc that rank the “Yes”, I mean - the 1st “Yes” will get 1, the 2nd “yes” will get 2 and so on, while the “No” will get Null value.

7844d34a-fdb3-4250-b23f-0aabc78ef1e6.png

How can I do that?

Thanks!

0 1 541
1 REPLY 1

kuopaz
Participant IV

I believe SQL windowing functions can only be used in derived tables in Looker. 

Top Labels in this Space
Top Solution Authors