Menu
SuiteCRM dedicated support by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Reporting assistance

Reporting assistance 4 days 20 hours ago #75322

  • Qwertyuiop43845
  • Qwertyuiop43845's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
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:

[

UserInboundOutboundTalk TimeTime inTime out
Susan Sampleton81000:12:3400:45:5600:34:45
Ford X. Sample101200:43:2100:54:4300:32:21
Lance Uppercut123400:43:2100:54:4300:32:21
I can't figure out how to aggregate the data of each variable. Thanks in advance for any assistance!
Last Edit: 4 days 19 hours ago by Qwertyuiop43845.
The administrator has disabled public write access.

Reporting assistance 2 days 2 hours ago #75381

  • labanjohnson
  • labanjohnson's Avatar
  • Offline
  • New Member
  • Posts: 13
  • Karma: 0
Reporting module does have the ability to sum.
Which data fields are you using?
The administrator has disabled public write access.

Reporting assistance 2 days 2 hours ago #75383

  • Qwertyuiop43845
  • Qwertyuiop43845's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
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.
The administrator has disabled public write access.

Reporting assistance 1 day 22 hours ago #75390

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 8557
  • Thank you received: 1307
  • Karma: 311
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.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Reporting assistance 1 day 19 hours ago #75402

  • Qwertyuiop43845
  • Qwertyuiop43845's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
Thanks. Is there a way to express integers as units of time(ie 00:00:00)?
The administrator has disabled public write access.

Reporting assistance 1 day 7 hours ago #75413

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 8557
  • Thank you received: 1307
  • Karma: 311
In the Report? I don't think so.

You can check the "Calculated fields" documentation, maybe it has something...

docs.suitecrm.com/user/advanced-modules/...w-calculated-fields/

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Reporting assistance 1 day 2 hours ago #75444

  • Qwertyuiop43845
  • Qwertyuiop43845's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
Thanks.
The administrator has disabled public write access.

Reporting assistance 22 hours 58 minutes ago #75450

  • Qwertyuiop43845
  • Qwertyuiop43845's Avatar
  • Offline
  • New Member
  • Posts: 5
  • Karma: 0
This is what we're trying to create on my client's CRM:

Last Edit: 22 hours 57 minutes ago by Qwertyuiop43845.
The administrator has disabled public write access.
Time to create page: 0.085 seconds
Powered by Kunena Forum