5 Replies Latest reply on Sep 3, 2018 1:27 AM by Tristan Roper-Caldbeck

    Formula for grouping data

    Tristan Roper-Caldbeck

      Hi there,

       

      I am having a problem building a formula in tableau for the below screenshot. I am inputting raw data that I have worked up in Alteryx, however, I want to divide the data in groupings - "Apples", "Oranges", "Bananas" or "Multiple" - depending on whether that truck is supplying 1 type of fruit (take singular name) or 2 or more types of fruit (Multiple).

       

      The next step to the problem is that the truck varies between supplying just 1 product in some locations and multiple in other locations, which I want to capture. For example, Truck 1 supplies multiple items in Singapore (apples, oranges and bananas), but only supplies 1 item (oranges) in Penang.

       

       

      Many thanks in advance for your help on this.

       

      Tristan