Reports

[Graham Pyne]

Hi, I am using the ESPOCRM with the advanced package and may I say it is an awesome product
We use use this to create tickets for customers that report issues with their installed equipment, this works very well

What I would like to do is to create a report on when a ticket/case is opened and when it was closed and the time it took to close the ticket from inception

Is this possible

For example the report would say:-

Opened at 1245 closed at 1400 time taken 1.15 hours

If it can include the user that closed it even better but not essential

[tanya]

Hello,
opened and closed datetime fields you have (as I understand), you need only summation field.

Report can be built only with fields, so you need to create it. If you want to save it into db, you can do it with formula.

https://www.espocrm.com/documentation/administration/formula/

If you need it for report only, you can calculate it from database

https://forum.espocrm.com/forum/general/34663-report-filter-for-comparing-values-of-2-float-fields

[Graham Pyne]

Any chance you could post an example of how to programme this, I have been thrust in at the deep end with programming this up - sorry