2 Replies Latest reply on Oct 25, 2018 4:32 PM by Utpal Kowshik

    Creating Counts based on table contents

    Utpal Kowshik

      Hi All,

       

      I have a question I'm trying to solve an issue where I need to calculate attachment rates of specific line items in an order.

      The data in the table looks like the following table:

       

      But I want to aggregate the values to show an attachment rate every time any Order is attached with the Product ABC.

      Thus, for any order that has the different Product IDs, every time that same Order ID has the item ABC also listed as a line item, ABC gets attached to the other product codes within that Order. Thus the aggregated table should look something like the following:

       

      Any suggestions on how I can accomplish the same in Tableau?

       

      Thanks in advance.