Derived Table vs Table Calculation

  • 18 July 2022
  • 0 replies

Is it advisable to use the table calculation instead of Derived table as best practice in looker especially when we have to use window function in sql calculation. FOr eg, If I have to calculate running countif of the Date in Prod_count column, then we should use derived table for this or use the looker table calculations 

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


0 replies

Be the first to reply!