Use CDR to report hold time in queue?

General Help
1

I want to use CDR to identify the hold time for each call in a queue.

I’m looking at a result, for example, that looks like this:
App Destination Disposition Duration
Queue 1100 ANSWERED 09:46

Then I see many related calls which look like routing attempts to various destinations:
Dial 515 ANSWERED 06:26
Hangup 501 BUSY 00:00
Dial 515 NO ANSWER 00:10
Hangup 501 BUSY 00:00
Dial 515 NO ANSWER 00:10
Hangup 501 BUSY 00:01

Does that mean the inbound queued call was on hold for 9:46 before answering?

Or does that mean the call was on hold for the ~2.5 minutes before having a 6:26 minute call?

Thanks for any/all help!

2

Queue statistics are best derived from the queue logs not the CDR. There are 3rd party systems for producing reports from the queue logs but there is really nothing in FreePBX to provide these reports.