3 Replies

I get the part about adding a DB Table.
The answer to that is NO, you can't just add a table to the DB heresay. If you played with the DB any future SW updates would overwrite them. You can certainly add custom fields which you probably already know and create reports for exporting.

This part is hard to understand.You wrote: with work hours and days and compare that values the tickets creation and update to export statistics?

This is a strange request as Tickets are usually based on Hours/Days they are open and not by the number of hours an employee works and most employees work a set number of hours. If various employees work different number of hours then it gets tricky........... Mmmmmm.

Are you sure you want to do this :-)

Suggestion Only: The best way that I (personally) can think of woking that would be to create a report with the Ticket Opening Date and Time PLUS Closing Date and time and User managing Tickets.

Export this report as a CSV.

Now create a Template to your liking in Excel (assuming you use it) along the lines of deducting the non working hours of each employee based on the CSV data.
This way it only takes a sec to export the CSV report each time (futurewise) and have excel import or link to the CSV data.

Not sure I have expained that well. Perhaps others can suggest other methods however I won't suggest trying to create that within SW as (although possible) its just easier in exporting to Excel

0

This discussion has been inactive for over a year.

You may get a better answer to your question by starting a new discussion.