Sapiens.BI helps you produce effective reports with charts in a fast and easy way. It is a Sugar and SuiteCRM BI plug-in with powerful reporting capabilities, ease of use, elegant design, and a quick and easy setup. This Reporting Tool is easy to use, there is no need for technical knowledge or SQL. The Sapiens.BI tool comes with over 100 pre-built reports.
#1147 - SLA
Can we do date subtract? for instance, i want to know the date the lead was entered into the system and the date it was worked upon( first Modified)
-
"Comprehensive tool that allows all types of advanced reports including audit tables, custom fields and combined reports."
Read More Reviews
- Most Recent Love from Users
lodevlayen- Nesterovaelenav
- carlort
6 years ago
Hello,
If you have in your system both of those dates (probably Date Created and Date Modified), you can add open Report, and then use tab 'Calculated fields' -> add new Calculation and select 'Subtract dates' - then identify whether this subtraction shall be calculated in hours, days, months, years, etc. Please see below:
If you do not have those dates in your system, you can try to use data from the Change Log / Audit Trial. If you have Audit Trial enabled for for these fields, you can do following: Create new report via 'Report Builder' and mark 'Audit' checkbox, -
Then inside of the Report, - you can select changed dates.
Let us know, if you need any more help, or if you would like to schedule a LIVE meeting to look these or other questions together ;). This is free of charge already during the free trial; We are also heppy to offer you a free live web training ;).
Best Regards, IT Sapiens Team