Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
These is a sample of my dataset (two tables):
Table1 (Records of users and when they were created):
User ID | DateCreated | UserData |
1 | 20/01/2019 | ... |
2 | 20/01/2019 | ... |
3 | 20/02/2019 | ... |
4 | 04/03/2019 | ... |
Table2 (Records of users and when they are buying):
User ID | PurchaseDate | Amount |
1 | 25/01/2019 | ... |
1 | 25/02/2019 | ... |
1 | 27/02/2019 | ... |
2 | 25/02/2019 | ... |
3 | 25/02/2019 | ... |
3 | 28/02/2019 | ... |
1 | 01/03/2019 | ... |
1 | 08/03/2019 | ... |
I want to display how many distinct users are buying per month and compare it with the total numbers of user existing.
Following the previous example, it should look something like that
- Blue = Users Puchasing
- Green = Total Users
- Axis = Month(PurchaseDate)
The problem that I am having is that any formula that I try to count the UserIDs is filtered due to the relationship UserID-UserID from both tables. So whenever I try a count, since for example the UserID 4 it's not in the table at all, it doesn't count it.
Any idea how to solve that?