2 Replies Latest reply on Jan 30, 2014 12:46 PM by Mark ODonnell

    Data Blending Question

    kranti banala

      Is there way to display all the data from both the data sources/tables.

      Please see attached

      Test 1

      serial#NameResukt
      1A0
      2B1
      3C0
      4D1
      5E1

       

      Test2

      snoreason
      1yes
      1no
      2yes
      2no
      2maybe
      3yes
      4no
      5yes

       

       

      What I want to build is

       

      Reason  Serial# Count

      Yes               3

      No             3

      Maybe       1

       

      I tried to blend the data on the sno and Serial#. When I drag data into the chart it displays an * in cases where there are more than one rows for the joining condition. How do I get rid of this