AnsweredAssumed Answered

Summarizing Average Days Between Dates

Question asked by JefferyBrown on Aug 13, 2012
Latest reply on Aug 13, 2012 by JefferyBrown

Title

Summarizing Average Days Between Dates

Post

How can I summarize the following:

 

Database Table

Visitor (Text Field)

Visited (TimeStamp Field)

 

Example Records...

 

Record 1

Visitor = John

Visited = 08/01/2012 12:00 PM

 

Record 2

Visitor = Mark

Visited = 08/03/2012 10:00 AM

 

Record 3

Visitor = John

Visited = 08/05/2012 2:00 PM

 

Record 4

Visitor = Mark

Visited = 08/07/2012 12:00 PM

 

Record 5

Visitor = John

Visited = 08/06/2012 12:00 PM

 

Record 6

Visitor = Mark

Visited = 08/10/2012 10:00 AM

 

I want the following summary result when table is sorted by “Visitor”

 

John

Average Days Between Visits 2.5

 

Mark

Average Days Between Visits 3.5

Outcomes