IT Sapiens Analytic Reporting Tool helps you produce effective reports with charts in a fast and easy way. It is a SuiteCRM BI add-on with powerful reporting capabilities, ease of use, elegant design, quick setup, and it comes with over one hundred prebuilt reports. This reporting tool is for anyone – no need for technical knowledge or SQL.
#2893 - calculate time totals and other functions etween time fields
the only reason that I am considering the module is to create time reports. We developed a custom time reports module and we store the time in the database as seconds (integer). So the report shows seconds, no a formatted time. If we can create another field of type TIME (hh:mm:ss) to store the time - will the report recognize the TIME field and will be able to calculate totals or any other functions?
The main goal is to create daily time reports (sum of time/user/day or week/month) and display the trend within a period of time week, last 7 days, last 30 days...etc
please advise. thanks
Other add-ons of interest
Analytic Reporting Tool Basic
Dynamic Reports and Interactive Charts.
Powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is for anyone, no need for technical knowledge or SQL. Comes with over a hundred prebuilt reports.
Does your CRM have calculated fields and logic hooks that your business depends on for reporting and business logic? Unfortunately those rules only run when a record is saved. Background Updater runs in the background to ensure your records are regularly updated so you can be sure your data is up to...