8 Replies Latest reply on Apr 15, 2018 5:45 PM by mike.czyzewski

    Split column in Data Source, but reaggregate in views (10.5)

    mike.czyzewski

      Hi!

       

      I have attached a workbook with simplified data.  I am primarily looking to build a text block.  In the data, 3 meetings took place.  I am, however, looking for a way to count meetings per participant.  I think the first step is to split the names in the "Assigned to" column into their own columns which is what I did in the data.

       

      I simply need to find a way to return:

       

      NameNumber of meetings
      Joe Smith3
      Jane Doe2
      Kevin Jones1
      Tom Miller1

       

      Any help would be appreciated.  Thank you!