Reporting assistance

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

[table]
[tr]
[td][/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[/tr]
[/table]Greetings all:

I am trying to set up a report that takes a user, aggregates all inbound and outbound calls, talk time and the time in and out.
I want it to look like this:

[table]
[tr]
[td]User[/td] [td] Inbound[/td] [td]Outbound[/td] [td]Talk Time[/td] [td]Time in[/td] [td]Time out[/td]
[/tr]
[tr][
[td]Susan Sampleton[/td] [td]8[/td] [td]10[/td] [td]00:12:34[/td] [td]00:45:56[/td] [td]00:34:45[/td]
[/tr]
[tr]
[td]Ford X. Sample[/td] [td]10[/td] [td]12[/td] [td]00:43:21[/td] [td]00:54:43 [/td] [td] 00:32:21[/td]
[/tr]
[tr]
[td]Lance Uppercut[/td] [td]12[/td] [td]34[/td] [td]00:43:21[/td] [td]00:54:43[/td] [td]00:32:21[/td]
[/tr]

[/table]
I can’t figure out how to aggregate the data of each variable. Thanks in advance for any assistance!

2

Reporting module does have the ability to sum.
Which data fields are you using?

3

Direction(whether a phonecall is inbound or outbound

Basically I need two columns for inbound and outbound.
Time in and time out is the duration of each inbound and outbound call summed up.
I don’t know which field to use for that.

4

There are two fields in “calls” called “duration_hours” and “duration_minutes”.

If you need to compound them into one (with total minutes, for example), you can create a new custom field for it, and use an on-save workflow to calculate that field. This way the data will be prepared so the Report is easier to build.

5

Thanks. Is there a way to express integers as units of time(ie 00:00:00)?

6

In the Report? I don’t think so.

You can check the “Calculated fields” documentation, maybe it has something…

https://docs.suitecrm.com/user/advanced-modules/workflow-calculated-fields/

7

Thanks.

8

This is what we’re trying to create on my client’s CRM: