Forum Discussion
ddpl
Solution Sage
Solution SageWant to create a table which include date wise unique count of users who are completely fresh
I have table which contains User_ID and Date Column from 1 st of Jan 2022 represent login activity on website I Want to create a table which include date wise unique count of users who are complet...
selimovd
Most Valuable Professional
Most Valuable ProfessionalHey ddpl ,
can you provide an example file?
That would make it easier to provide a solution that works for you.
Best regards
Denis
ddplSolution Sage
Solution SageI have data...
| User ID | Date |
| A | 01-01-22 |
| B | 01-01-22 |
| C | 01-01-22 |
| D | 01-01-22 |
| B | 01-02-22 |
| D | 01-02-22 |
| E | 01-02-22 |
| D | 01-03-22 |
| F | 01-03-22 |
| G | 01-03-22 |
I want output as below...
| Fresh Users | Date | |
| 4 | 01-01-22 | (A,B,C,D) |
| 1 | 01-02-22 | (E) |
| 2 | 01-03-22 | (F,G) |