Can anyone help determine number of days between orders (and avg thereof) by groups of customers? The filter contexts would be product #’s or categories (I would put them on a slicer).
The data I have are simple and look like this:
<tbody> </tbody>
I also have a related table of just the unique customer numbers and a calendar table.
You can see that Cust # 8 ordered Product #130 in 2005, 2008, 2011 whereas Cust # 13 ordered item #120 in 2003, 2004, 2006. Smaller intervals. I need to determine the avg number of days between orders of a given individual item by all those customers who have purchased that item (presumably multiple times).
I think this will be somewhat complex inasmuch as several measures will probably need to be built up.
Any help is appreciated.
j
The data I have are simple and look like this:
Order # | Cust # | Prod # | Order Date |
340623 | 8 | 130 | 10/14/2011 0:00 |
292834 | 8 | 130 | 10/9/2008 0:00 |
235501 | 8 | 130 | 4/15/2005 0:00 |
215475 | 9 | 100 | 12/12/2003 0:00 |
215474 | 9 | 100 | 12/12/2003 0:00 |
254227 | 13 | 120 | 7/7/2006 0:00 |
216356 | 13 | 120 | 1/12/2004 0:00 |
204725 | 13 | 120 | 3/14/2003 0:00 |
<tbody> </tbody>
I also have a related table of just the unique customer numbers and a calendar table.
You can see that Cust # 8 ordered Product #130 in 2005, 2008, 2011 whereas Cust # 13 ordered item #120 in 2003, 2004, 2006. Smaller intervals. I need to determine the avg number of days between orders of a given individual item by all those customers who have purchased that item (presumably multiple times).
I think this will be somewhat complex inasmuch as several measures will probably need to be built up.
Any help is appreciated.
j