User productivity report (calls, meetings, etc)

[usiw]

We are looking at creating a report in Sugar Pro 6.2 that shows the number of calls and meetings users had fora particular day, along with the duration of calls, but aren't having any luck. Basically the final report should show the username, count(calls), sum(calls.duration_minutes), and count(meetings). The report wizard seems too limited and shows meetings for each call and calls for each meeting which skews all the results (the number of calls and meetings is always equal). Is this possible without having to get the Enterprise version of sugar which includes SQL reports?

We are filtering based on the call.date_end and meeting.date_end equaling today.

Here is what we are looking at producing:

Username      Calls    Call Duration     Meetings
joe           5        12                7
bob           0        0                 3
sue           3        92                17

note - we don't use call hours since it complicates summing the total call length

[christianknoll]

Look at this Document page 15ff ..this describes how our KINAMU reporter handles exactly that request.

christian.

We are looking at creating a report in Sugar Pro 6.2 that shows the number of calls and meetings users had fora particular day, along with the duration of calls, but aren't having any luck. Basically the final report should show the username, count(calls), sum(calls.duration_minutes), and count(meetings). The report wizard seems too limited and shows meetings for each call and calls for each meeting which skews all the results (the number of calls and meetings is always equal). Is this possible without having to get the Enterprise version of sugar which includes SQL reports?

We are filtering based on the call.date_end and meeting.date_end equaling today.

Here is what we are looking at producing:

Username      Calls    Call Duration     Meetings
joe           5        12                7
bob           0        0                 3
sue           3        92                17

note - we don't use call hours since it complicates summing the total call length