How to apply pivot in merge query dimensions

Is merge query feature in Looker going to be removed in near future  

pros and cons of using table calculations in looker

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 ...

suppose we have a table belowDate 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...