4 Replies Latest reply on Apr 20, 2018 2:06 PM by Patrick Tam

    Data blending and calculated field

    Patrick Tam

      Hi all,

       

      Is there a way to get around  "all fields must be aggregate or constant multiple data sources" requirement?

       

      I linked 2 data sources using data blending. 1 data source include the status flag (1 or 0) and the other data source have the value metric.

       

      The calculated field go something like this:

       

      if status = 0

      then null

      else

      metric

      end

       

      Then this calculated filed need to be used for other analysis, such as average, max, and min.

       

      The issue with aggregate or constant, Tableau doesn't allow for further use of other calculated functions as it will give an error of "Can't be to user defined aggregate.

       

      Is there a way to work around this issue? Thanks in advance.