CODEWITHSUNDEEP
aggregate-functionstableau-apicalculated-field
June
June

Reputation: 730

How to perform table calculation when blend data using conditional string dimensions

A common use case for my analysis is blend a secondary data source then do a table calculation with various independent measures (thus I cannot apply filters). The condition is offer status = hired, but offer status can contain my different response types.

IF
ATTR([Offer Status]) = "Hired"
Then AVG([Comp_File].[Cash PTM])
Else [Null] END

Since I am blending the datasource, the values must be aggregated.

Here's a link to the notebook: https://community.tableau.com/message/671932?et=watches.email.thread#671932

Upvotes: 1

Views: 1662

Answers (1)

June
June

Reputation: 730

I solved this. I attended a 'Tableau Doctor' session at the Tableau Conference, and the expert confirmed this functionality is not possible on a blend due to the order of operations, with blending happening last on Tableau's processing logic/order of operations.

To solve, use a left join.

Upvotes: 1

Related Questions