3 Replies Latest reply on Aug 1, 2018 4:46 AM by none given

    Filtering by Calculated Field.  Multiple rows per ID, want to return all.

    none given

      I have many observations per ID and want to return all of them for specific ID's.  Right now it is only returning the one row, instead of all the ID's rows.

       

      This is what I want returned (in SQL):

       

      SELECT Offered_School, count(ProspectID)

      FROM offers_tableau where ProspectID in (

      SELECT Prospect_ID from players_tableau where Selected_School = Accepted_School)

      GROUP BY Offered_School

       

       

      The output should be something like this (depending on the selected parameter):

       

      Clemson 30

      Alabama 10

      Georgia 5

      Akron 2

      etc...