Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Number of closed tickets for a amount of time  XML
Forum Index » Analyzer/Reporting
 
Author Message
[Post New]02/01/2012 21:01:28
    Subject: Number of closed tickets for a amount of time
[Up]
cbowman
SysAider

SysAider from release 7.5 United States
Joined: 23/09/2011
Messages: 3
Offline
The report I want to run is quite simple

a graph with 3 administrators showing how many SRs they closed for a set amount of time.

I can produce a report similar to what I want... but there are never any numbers on the graph (making the graph useless)

[Post New]14/02/2012 16:14:03
    Subject: Re:Number of closed tickets for a amount of time
[Up]
zackiechan
SysAider

SysAider from release 6 United States
Joined: 21/12/2011
Messages: 5
Offline
Hello,

Have you by chance tried the "Opened/Closed requests per administrator" report? This is located at SysAid> Help Desk> Work load> Opened/Closed requests per administrator. I run this one quite often by selecting "All" on the SR Type and changing my Date Range and nothing else. This gives me a detailed portion and a bar graph with numbers.

Best wishes!

ZC
[Post New]19/03/2012 11:39:40
    Subject: Re:Number of closed tickets for a amount of time
[Up]
zehavit
SysAid Customer Relations

Joined: 23/11/2011
Messages: 27
Offline
Dear,

Thank you for this post.

I believe the suggested report by zackiechan, would meet you need.

As the attached screenshot below shows.

Please update us if you require any further assistance.

Zehavit Belo.
SysAid CSS
[Thumb - open close report.png]
 Filename open close report.png Download
 Description
 Filesize 280 Kbytes
 Downloaded:  1 time(s)

[Post New]11/04/2012 19:34:11
    Subject: Re:Number of closed tickets for a amount of time
[Up]
cbowman
SysAider

SysAider from release 7.5 United States
Joined: 23/09/2011
Messages: 3
Offline
This is the one we were using. We don't want it to show Opened on the graph. We want it to show closed for a period of time.
[Post New]12/04/2012 11:55:15
    Subject: Re:Number of closed tickets for a amount of time
[Up]
CarlH
Elite SysAider

SysAider from release 4.5 United States Pathfinder
Joined: 30/01/2009
Messages: 139
Offline
select distinct responsibility, COUNT(responsibility) as closed from service_req where status='3' and close_time [insert expression here] group by responsibility
Forum Index » Analyzer/Reporting
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
    SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Skype account:ilient
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011 		   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use