Joined: 03 Feb 2009
Location: United States
Online Status: Offline
Posts: 13
Topic: average age of help desk ticket Posted: 05 May 2009 at 7:11am
Greetings All.
I am current working in CR XI to generate a report of all our outstanding help desk tickets. The report is grouped by agent, shows a summary of his tickets, total count and I want to show the average age of the summarized tickets
The question I have is how would I create a formula to calculate the average age (in days) based on the created_at field (its a date time field)
George
Edited by ggardei - 05 May 2009 at 7:12am
---------------------------
George W. Gardei
IT CAMS Manager
God's Bible School and College
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 05 May 2009 at 8:50am
Assuming you want the length of time from today create a formula field to get the difference in days then use that to get the average using the SUm function:
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
