You need to sign in to do that
Don't have an account?
Brian Zentner 2
How do I report on the average amount of time between records?
I have a business case where I need to be able to report on the Mean Time between certain records based on some criteria.
Example: I have an object that tracks IT issues and they are prioritized 1 - 5 (1 being Severe to 5 being benign). I need to show Mean Time between the Priority 1 tickets and am struggling to pull that information into report format.
Any suggestions?
Example: I have an object that tracks IT issues and they are prioritized 1 - 5 (1 being Severe to 5 being benign). I need to show Mean Time between the Priority 1 tickets and am struggling to pull that information into report format.
Any suggestions?
Create a report which would summarize Priority 1 cases by dates. If you want to go one deeper level then create a formula which pulls hour out of created date of a record and summarize via hour. Hope this makes sense!