3 Replies Latest reply: Nov 14, 2012 11:52 AM by svqlik73 RSS

    Plot frequency of date change

      Hi Experts,
      I have a table with order number and the order date field. Order date can change for the same order number. The requirement is , I have to check the frequecny of order date change  and plot them . From the sample below,  there are 3 occurances where order date changed twice and once with 4 times. I have to plot , frequency 2 on X-axis  and corressponding freqeuncy 75% on Y-axis and frequncy 1 with 25% on Y . Greatly appreciate your help in achieving this. I have also attached the sample file if you need.
      Orderorder date
      11111/01/2012
      11111/02/2012
      11111/03/2012
      11111/04/2012
      22211/03/2012
      22211/09/2012
      33311/01/2012
      33311/06/2012
      44411/10/2012
      44411/13/2012