It sounds like HS_Request and HS_Request_History are table names.
Do we have direct access to the database? If so, what is the info needed to access the database (we are using the hosted version).
Or, do you get this via a web service? If so, what is the syntax of the call?
I’m trying to create a report that returns the number of requests per day, grouped by category - that also includes the average amount of time spent on the ticket. This allows seeing what type of problems the help desk is seeing - but also shows which ones are complicated (as defined by the amount of time spent on it) versus ones that are simple to address.
I’m comfortable with SQL, so if I can access the raw data (either directly, or downloading CSV which I can load into my own tables) I should be able to generate a meaningful report.