KNOWLEDGE BASE

How To Create FIXED in Tableau Prep Not Supporting FIXED


Published: 03 Feb 2020
Last Modified Date: 04 Feb 2020

Question

How To Create FIXED in Tableau Prep Builder Versions Not Supporting FIXED 

Environment

  • Tableau Prep Builder

Answer

How to create {FIXED [Order ID]: SUM([Sales])] after Clean 1
  1. Add Aggregate
  2. Drag [Order ID] to Grouped Fields
  3. Drag [Sales] to Aggregated Fields and set aggregation as SUM
  4. Rename [Sales]
  5. Join Clean 1 & Aggregate 1
  6. Set Join Clauses as Order ID = Order ID
  7. Set Join Type as Inner Join
  8. Remove [Order ID] from Aggregate 1

 
Did this article resolve the issue?