function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
NeptuneNeptune 

Reports - Average time between case edits

Is it possible to run the following report with salesforce.

Average time between case edits.  For each case owner for the last 60 days, lists the mean time between editing each case.  This would be filtered to exclude the status closed.  I can tell when the case was last edited, say if it was edited within the last 7 days, just not how many times each case was edited and the average time between edit.





Greg HGreg H
I think you could do something like this by running a report on the CaseHistory object.  However, this object tends to contain a lot of data and if you don't really narrow down the date range on the report it may not complete or take a really long time to come back.
-greg