Question

how to use partition by windows functions in Looker instead of derived tables

  • 18 July 2022
  • 0 replies
  • 50 views

suppose we have a table below

Date Prod Prod_count
18-07-2022 C 1
18-07-2022 A 2
19-07-2022 A 1
19-07-2022 B 2

 

I want to calculate the output in Column Prod_count which is simply giving the running countifs over Date column. How can we achieve this in Looker using table calculation 


0 replies

Be the first to reply!

Reply