6 Replies Latest reply on Aug 19, 2016 9:58 AM by Keith Johnston

    Count same values in multiple fields

    Keith Johnston

      Hello All,

       

      Hoping the group can help with this. I currently am using Tableau Desktop, Personal Edition.

       

      In the attached Excel file, I have two data sources (One is a list of Orders, the other a list of Rules). Multiple Rules are applied to each Order, with different Rule Results.  I wanted to ask two questions:

       

      1. What would be the easiest method to count the number of times a specific rules. The challenge is that the same rule can appear in multiple columns, as shown in the Source 1 tab.

       

      2. Similarly, I'd also like to count the Rule Results, by Rule

       

      The Solution tab contains my intended result, would like to achieve in the most efficient way possible. Any input is greatly appreciated!

       

      Thank You!

      KJ