2 Replies Latest reply on Apr 26, 2018 7:18 PM by Tanzir Ahmed

    Distribution/bins from a single column

    Tanzir Ahmed

      Experts,

       

      I'm after some guide around distribution/bin.

       

      Basically, I have a list of student ID's in one column and would like to do the followings -

       

      1. Count how many times student id's are repeated.

      2. Then group them how many id's repeated once, 2-3 , 4+

      3. Do a bar graph to show the grouping.

       

        This is the source:

      Student_id
      123
      123
      343
      654
      322
      343
      123
      789
      987
      789
      789
      789

      789

       

      I can do unique count -

        

      Student IDUnique Count
      1233
      3432
      6541
      3221
      7895
      9871

       

      I want to group the count under the

       

      group 

      1 :  3 records

      2- 3 :  2 records

      4+ : 1

       

      Lastly, I'd like to plot them in a bar graph like bIns.

       

      Any thoughts?