Tickets created and closed timeline report
Hello, I have a problem with a report that management has asked for. They want to see week by week, the number of tickets opened, and the number of tickets closed, in a line chart format. I created the line chart report, but the numbers are inaccurate.
Here is the issue that I need help with... For quite a few of our tickets, they are opened and closed on the same day. When I group by request status, ServiceDesk just goes through the current status of the records and reports those counts. This is inaccurate because it is showing very few tickets being created, but a lot of tickets being closed.
Is there a way that I can create a line chart with 2 values (Tickets Created, and Tickets Closed) on one axis, and the date range (in weeks) on the other axis?
Any help would be greatly appreciated.
Thanks.
New to ADSelfService Plus?