2 Replies Latest reply: Oct 16, 2014 6:49 AM by Manish Kachhia RSS

    Set Analysis: aggregation issue

    Sifat Rahman

      Hi, I have a table like this:

       

      uniquetradeidType
      11V
      12V
      11V
      13V
      13V
      15V
      15V
      15V
      16V
      17E
      17V

       

      I want to translate the following to set analysis so that I can represent this in both text boxes and graphically:


      E = distinct count of uniquetradeid which has no V in another row with the same uniquetradeid.

      V = distinct count of uniquetradeid which has no E in another row with the same uniquetradeid.

      H = distinct count of uniquetradeid which includes both E AND V in its rows.


      So in the example, the results should be

      E=0,

      V= 5,

      H=1

       

      How can I get this with set analysis both in text box and graphically? Thanks.