Cases and Reporting on Dates - best way to do this?
Hi,
I need to create various reports using custom date fields on the Case and in other cases on the activity.
Focusing on the cases, I want to report the avg time to close and avg response time in days
My issues are as follow
1. Any differences in time that are below 1 day (so between 0-23 hours) i want to be counted as 1 day.
2. I want to show these averages by different variable, if possible, so by account by owner and other fields on the case record.
If i create a timestampdif, which I cast as an integer, and make a sum by account, when I add a column selector it obviously always sums by account. How can i get it to sum by the first column? or do i have to make 3 different reports for the same thing?
I need to create various reports using custom date fields on the Case and in other cases on the activity.
Focusing on the cases, I want to report the avg time to close and avg response time in days
My issues are as follow
1. Any differences in time that are below 1 day (so between 0-23 hours) i want to be counted as 1 day.
2. I want to show these averages by different variable, if possible, so by account by owner and other fields on the case record.
If i create a timestampdif, which I cast as an integer, and make a sum by account, when I add a column selector it obviously always sums by account. How can i get it to sum by the first column? or do i have to make 3 different reports for the same thing?
0