Grouping Dates

[a90210girl]

Hi there-  

Can you tell me if digdb can group dates without using the Excel pivot functionality?  

In example "A" below, I have several different dates in different orders.  There's also another value in the column titled "value" which is a measure of "cycle time to closure in # of days" in the column to the right.

I need to make sure that both columns group by week, month, quarter, etc and I need to be able to average those data points within those groups by average or median.  See example "B" below.


EXAMPLE "A"

Edit Date             Value
9/18/2007 4:48 8
9/10/2007 3:31 0
9/24/2007 1:06 14
9/23/2007 21:40 14
9/17/2007 6:15 7
9/12/2007 5:02 2
10/5/2007 14:01 25
10/5/2007 10:14 25
9/25/2007 13:55 15
9/11/2007 16:09 1
9/25/2007 14:15 15
9/24/2007 6:31 14
9/11/2007 8:18 1
9/10/2007 8:55 0
9/10/2007 6:39 0
9/27/2007 7:17 17
9/25/2007 14:28 15
9/21/2007 14:56 11
9/10/2007 13:46 0
10/25/2007 14:12 45
10/25/2007 11:41 45
10/17/2007 6:37 37
9/10/2007 9:11 0
9/25/2007 0:29 15
9/18/2007 5:35 8
9/10/2007 23:31 1
9/18/2007 5:20 8
9/11/2007 3:21 1
9/25/2007 14:17 15
9/19/2007 9:33 9
9/18/2007 16:37 8
9/18/2007 14:10 8
9/14/2007 12:33 4
9/12/2007 17:02 2
9/10/2007 16:44 0
9/13/2007 7:11 3
9/12/2007 7:07 2
9/11/2007 10:21 1
9/10/2007 13:10 0
9/10/2007 13:10 0
9/13/2007 0:40 3
10/4/2007 10:37 24
9/11/2007 22:10 1
9/10/2007 13:10 0
9/10/2007 13:10 0
9/10/2007 13:10 0
9/11/2007 1:04 1
9/10/2007 13:10 0
9/28/2007 1:22 18
9/10/2007 13:10 0
9/10/2007 13:10 0
9/11/2007 0:59 1
9/17/2007 5:54 7
9/11/2007 9:47 1
9/11/2007 12:28 1
9/11/2007 9:50 1
9/25/2007 0:36 15



Dates Grouped Weekly         Average time to closure
10/1/2007 - 10/7/2007 31.4
10/8/2007 - 10/14/2007 22.3
10/15/2007 - 10/21/2007 25.5

thanks,
Connie

[DigDB Support]

You can use the DigDB->Column->Convert->Date/Time to->Month ... feature to convert the date into the x-th week of the year, this will give you a new column to your data which tells what week is the data for at each row.  Then you can use the DigDB->Roll up function to aggregate by the new "week" column.

The demo for this is here: http://www.digdb.com/excel_add_ins/roll_up_pivot_table_subtotal/#A7

[a90210girl]

thanks!  I'll try it out...

DigDB Support wrote:

You can use the DigDB->Column->Convert->Date/Time to->Month ... feature to convert the date into the x-th week of the year, this will give you a new column to your data which tells what week is the data for at each row.  Then you can use the DigDB->Roll up function to aggregate by the new "week" column.

The demo for this is here: http://www.digdb.com/excel_add_ins/roll_up_pivot_table_subtotal/#A7