Reporting Query

Reporting Query

Hi Guys,

We are trying to generate a report so we can look at tickets logged monthly + time spent on the ticket.

The attached is a great start showing our monthly tickets and which category they are in as a bar chart.

How would I:

 1 – Include time spent per ticket in the chart. So where you can set the amount of time in a work log for example on a ticket, how can I include that?

 2 – Sub categories included in the bar chart if possible (or a 2nd chart?).

Attached are screenshots of my custom report but I'm hoping we can some how incorporate the time spent in the work logs. 


                New to ADSelfService Plus?