4 Replies Latest reply on Dec 16, 2016 6:23 AM by vineeth v

    Problem in creating Histogram with Calulated field values

    vineeth v

      Hi All

       

      I am trying to create a Histogram chart, and bins required for the histogram is from a calculated field. Below is details of the issue

      Column 1: Transaction ID's

      Column 2: Date and time of Transactions.

      Column 3: Line number

         

      Transaction ID       Date and TimeLine
      107265918060602221.11.2016 14:01:555001
      107265918060002221.11.2016 14:02:495001
      107265918061002221.11.2016 14:03:185001
      107265918059702121.11.2016 14:04:275001
      107265918060302121.11.2016 14:05:085001
      107265918059102121.11.2016 14:07:175001
      107265918060102121.11.2016 14:07:415001
      107265918058802221.11.2016 14:08:105001
      107265918059802221.11.2016 14:08:395001
      107265918059502121.11.2016 14:10:245001
      107265918059202221.11.2016 14:10:535001
      107265918060202221.11.2016 14:11:45

      5001

       

      I am trying to trying to find out number of transactions that occurred with 0-10 sec, 10-20sec, 20-30 sec, 30-40,... in so on time intervals.

      I used Lookup expression to find the difference in Time and in turn used the values to create the bin Values.

       

      But the problem now is that i am not able to find the count within each bin.

       

      Attached the work book for reference.