Question

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

  • 24 July 2022
  • 1 reply
  • 152 views

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.

How can I do that?

 

Thanks!

 

 


This topic has been closed for comments

1 reply

Userlevel 2

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