CODEWITHSUNDEEP
tableau-apicalculated-field
shyam iyer
shyam iyer

Reputation: 57

Tableau Calculated fields with data blending

I have 2 different data sources DS1 and DS2

DS1 has week #( 1 to 49) , corresponding sales , ID

DS 2 has week #(50 to 52) , corresponding sales , ID

I did a data blending using ID as the relationship.

Question :

  1. How do I draw a graph between week # and sales for the complete data (week 1 till week 52)

  2. Does calculated field provide functions to get this done ?

Thanks in advance !

Upvotes: 1

Views: 3082

Answers (1)

Stephen Berndt
Stephen Berndt

Reputation: 433

I'm going to enter this as a proposed solution rather than a comment. A union in the tableau data source screen is 100% the best way to go. If the 2 datasources have the same columns, you shouldn't need to re-pull the data. All of the work is done in Tableau.

Drag the "new union" pill into your data source pane and select the tables that you want to bring together, in this case DS 1 and DS 2.

The one caveat is that you have to be in v9.3+ like @AlexBlakemore said.

Upvotes: 1

Related Questions