Vandana

Discussions

How to identify unique values in the column
Hello all, I want to label the unique entries in the column as unique and repeated entries as duplicate by using beast mode. Could anyone please help me on how to do this.. Attaching screenshot of the expected result table : Thank you
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) /…

How to identify unique values in the column
Hello all, I want to label the unique entries in the column as unique and repeated entries as duplicate by using beast mode. Could anyone please help me on how to do this.. Attaching screenshot of the expected result table : Thank you
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) /…