2 Replies Latest reply: Nov 1, 2016 2:39 PM by Bella Mae RSS

    Grouping Results

    Elisha Thapar

      I have these columns:

       

      Employee IDDatesLocation
      1231/1/2016San Jose
      1231/2/2016San Jose
      1231/5/2016Seattle
      1231/6/2016San Jose


      I want a Table that shows me data in this format:


      Location NameEmployees with more than 2 days of travel in Location
      San Jose1
      Seattle0


      I am struggling with the last column 'Employees with less than 30 days of travel'. Can someone help?