2 Replies Latest reply on Aug 20, 2015 10:09 AM by 1362797

    Plot number of days against range

    1362797

      Hi All,

       

      I have 2 date fields in my reports Date 1 and Date 2. I am calculating different between the 2 dates which is giving me number of days.

       

      Date1

      Date1Date2Difference(Date1-date2)
      6/25/2015 5/27/2015-23
      5/26/20155/8/2015-14
      5/14/20155/8/2015-6
      5/29/2015 5/27/2015-2
      5/29/2015 5/27/2015-2
      5/29/2015 5/30/20151

       

      Now i have range like this:

      RangeBinFrequency(count the above difference based on Range defined in this table)
      between -30 and -15-301
      between -15 and 0-154
      000
      between 0 and 15151
      between 15 and 30300

       

       

      Now i want to plot graph of Frequency and Bin like this:

       

      Y axis:Frequency

      X Axis:Bin

       

      Any help in this appreciated.