Reporting

[toddp]

Hi All,

I'm working on some custom reports and needed a little help understanding when I should be using length_in_sec and queue_seconds in vicidial_closer_log. Could someone please give me a brief description for these two fields.

I would appreciate any help you can give me.


Thank you,
Todd

[williamconley]

I'm just guessing here, but i'm thinking that the length in sec is the number of seconds the call lasted and the queue seconds would be the amount of time the call waited to get to the closer (but just a guess).

maybe you should make a few "test" calls and check?

[mflorell]

It really depends on what you are trying to report on. We need more to go on here.

Also, of course you have not mentioned your admin.php version and build.

[toddp]

We are using version 2.4-286 build 101106-1850

I would like to report on % of calls answered in different intervals (20, 60, 120 s), average drop time in seconds, average time agent is on the phone ,etc. Those are a few examples.


Again, I appreciate all the help.
Todd

[mflorell]

The first two are easy, those are already included in the inbound report, if you need the SQL just take a look in the source code.

As for the agent time on the phone, you are going to have to explain in more detail exactly what you mean by that.

[toddp]

I was looking at the inbound reports and correct me if I'm wrong
Call time and Drop time is calculated using length_in_sec at the different statuses. Hold time is the time spent in the queue so it uses queue_seconds. Then total talk time is length_in_sec - queue_seconds. But then I was looking at the CLOSER stats report and Call drop time breakdown and call answered time is calculated using queue_seconds. Does anyone know why they are calculated using this value instead of length_in_sec.


Thank you,
Todd

[mflorell]

Because the client that sponsored the building of that report wanted it that way. There are several examples of special reporting formulas like this in the included reports.

Also, the length-in-sec fields mean different things in different tables, as do the seconds fields in the vicidial_agent_log table. They all measure different things, which is why we need to know what exactly you are looking for before we can tell you where to get it.

[gerald_lyc]

Can we have a data dictionary of the different table of Vicidial? I am focus to create new reports. Where are the data kept? Which tables are involved?

Thanks.

[mflorell]

I would love to, but that would take a lot of time to compile, and maintain, and nobody has every offered to assist in doing it or sponsoring it.

[gerald_lyc]

Are there some developemnts in the pipeline for other report and statistics in the report section?

[mflorell]

Nothing currently that I know of. All of our pending development are other feature enhancements.

[gerald_lyc]

Are there some free solutions which are comparable to queuemetrics from which i can build my own reporting for vicidial?

[mflorell]

We have a few clients that use Jasper Reports, that's the only free one that I know of.

[williamconley]

well, unless you count php/mysql and netbeans/eclipse/aptana to modify existing reports ...