
Hello Tableau Community,
I'm facing an issue of blending data in tableau.
I currently have two tables:
- Table containing all users in a platform
- Table containing all Transactions in the past year
I need to merge these two tables in order to create a new report which sees if an user is active or not.
The tables can merge through the [User ID] and [Company] attribute.
The final calculation that I am trying to get is in table 1, I need a column that is called "# of Transactions". This column should say how many individual transactions ([Transaction ID]) each user had in Table 2. This should range from 0 to N transactions and needs to be in Table 1.
I will then use this number to classify the user. No calculations that I have tried so far have worked. Can anyone help me with this?
Thank you in advanced for any help!
Ok! So, what is the issue you are facing with blending? Are you unable to do it? If so, can you do a join? I will need to see some screenshots to really understand what's going on. If it's some data that cannot be shared publicly, can you share it privately?