Skip to main content
Rafa Braga 님이 #Tableau Desktop & Web Authoring에 질문했습니다

Hello Tableau Community,

 

I'm facing an issue of blending data in tableau.

 

I currently have two tables:

  1. Table containing all users in a platform
  2. 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!

답변 5개
  1. 2022년 9월 7일 오후 5:29

    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?