Error in Data diff function
I wanted to find avg daily registrations rate for which the formula will be: on 11th March 2022, we take registration count from Jan 1st to march 11 2022/70. 70 is the which is the total number of days till date. Formula I used: (CASE When `Year` = CONCAT(YEAR(CURRENT_DATE())) then COUNT(`Email`) end) /…
