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.
| Order | order date |
|---|
| 111 | 11/01/2012 |
| 111 | 11/02/2012 |
| 111 | 11/03/2012 |
| 111 | 11/04/2012 |
| 222 | 11/03/2012 |
| 222 | 11/09/2012 |
| 333 | 11/01/2012 |
| 333 | 11/06/2012 |
| 444 | 11/10/2012 |
| 444 | 11/13/2012 |
