2 Replies Latest reply: Feb 20, 2013 1:30 AM by eli iluz RSS

    how to create different bin range using class function

    eli iluz

      hi all,

       

      assuming i have this table:

      col1col2
      A

      272

      A214
      A483
      B457
      B278
      B327
      B363
      A324
      B433
      A153
      B596
      A350
      A153
      B520
      A343
      B325
      A433

       

       

      I want to create bar chart with x-axis as the following bin range:

       

      <200 , 200-250, 251-300,301-350, 351-400, >400

       

      i try the class function (  class(col2,50)  ), but i need the option to create also min range (<200) and max range(>400).

      In the class function it create with final range.

       

      The y-axis  just count freq of A according to the bin range.

      does anyone have a solution (without change or add any data to the DB)?

       

      thnx.