I need to get the average time taken by each case worker to close a case in reports. I am not sure which record type is needed to be used.
I tried using Case History record type, but each case record is repeated twice. I am thinking its because it tracks every change to status and owner.
What i actually need is to have report where i group against each case worker show the cases against this case worker and the time taken to close each case and in the grouping have a avg time against the case worker.
something like this but without the cases repeating