6 Replies Latest reply on Apr 1, 2015 4:29 PM by Shawn Wallwork

    Crated a calculated field base on two conditions

    Diego Monge

      Hello,

       

      I am new to Tableau, but I have used other BI tools before.

       

      I would like to create a field that is base of two conditions from other fields, for instace:

       

         

      OrderProductUSDDeal BucketCalculated Deal Bucket
      1A100Less than 1KLess than 500
      1B100Less than 1KLess than 500
      1C100Less than 1KLess than 500
      2A200Less than 1KGreater than 500-Less than 1K
      2B200Less than 1KGreater than 500-Less than 1K
      2C200Less than 1KGreater than 500-Less than 1K
      3A500Greater than 1KGreater than 1K
      3B500Greater than 1KGreater than 1K
      3C500Greater than 1KGreater than 1K

       

      I need to further split the orders that are Less than 1K.


      IIF [Deal Bucket] = "Less than 1K" AND the sum of USD by Order < $500, "Less than 500",

      IIF [Deal Bucket] = "Less than 1K" AND the sum of USD by Order > $500, "Greater than 500-Less than 1K", [Deal Bucket]))

       

      I saw a couple of post wher somebody was asking for an equivalent in Tableau of the AGGR() function in QlikView, if something like that exists, would be aweome.

       

      So far I have is a normal table created in Tableau, and I am not showing the sum of USD at a detail level, meaning I am showing by Country for instance and then I would need to further brake it down by the needed Deal Bucket.

       

      Thanks for any help.