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 |