Apex Code Development You need to sign in to do that
Don't have an account?
Mayank_Sharma Report on Cases
Hi All,
I need a report based on Case. I need to calculate the time duration when the case is in "R&D" and "in Progress" status.
However this report should show the time duration according to the representative.
e.g. there is a case 1
1. User1 change the status from NEW to IN PROGRESS. say at 9am
2. User 2 change the satus from IN PROGRESS to HOLD Say at 10am
3. User3 change the status from HOLD to R&D say at 12 pm
4. USer4 change the status from R&D to closed say at 15 pm
Hence i need report as
User 1 :: Working hours 1(10am-9am) IN PROGRESS
User2 :: Working hours 3 (15pm -12pm) R&D
Any help and suggestion is highly appreciable.
Thanks,
Mayank
Unfortunately, this is going to be a tough ask to address with out of the box functionality.
It might be worth looking at some AppExchange products like WorkIt!
Good luck