Display always total records without reading X-Axis in bar
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.