Notification

Icon
Error

Help Desk report charted by Fiscal Year

Posted: Monday, August 12, 2019 11:39:05 PM(UTC)
Tom Londe

Tom Londe

Member Original PosterPosts: 2
0
Like
Hi folks,
I have a bit of an odd request I'm hoping to get some insight on. I'm completely new to SQL, which is making the reporting portion of Lansweeper difficult enough, but now I'm trying to get some non-standard reporting done that may be beyond SQL's abilities to cleanly do.

I'm wanting to create some chartable reports based on the Help Desk... specifically, I'm wanting to get the average time to ticket closure charted over Fiscal Years using the line graph charts. If we were just wanting these reports based on the calendar year, I think that would be easy enough to do without any sort of clever coding, but I'm not sure how to run these reports according to an odd time frame like our fiscal years. Our FY's run from July 1 to June 30 (with July 1, 2019-June 30, 2020 being fiscal year 2020, for example).

If this thing worked the way we're imagining, the Fiscal year would be the Label Axis on the line chart, and the average time to ticket closure would be the plotted point for each FY.

So, does anyone know if there's a way to get SQL to take a date on a ticket, and then dynamically tie that ticket date to a fiscal year value that we use as the label value for a chart? Thanks for any thoughts or insight you might have, and let me know if I need to try and explain this better!
Tom

Active Discussions

Lansweeper Vmware Vcenter and Hosts not scanning
by  pkamacho   Go to last post Go to first unread
Last post: Today at 8:33:17 PM(UTC)
Lansweeper Helpdesk Ticket "On-Hold"
by  Chris1052  
Go to last post Go to first unread
Last post: Today at 7:44:01 PM(UTC)
Lansweeper SNMPv3 Scanning of Cisco Devices
by  Bruce.B   Go to last post Go to first unread
Last post: Today at 7:40:08 PM(UTC)
Lansweeper Object reference not set to an instance of an object
by  Bruce.B  
Go to last post Go to first unread
Last post: Today at 6:33:18 PM(UTC)
Lansweeper New Exchange server feature scanning
by  Thomas D.   Go to last post Go to first unread
Last post: Today at 5:00:51 PM(UTC)
Lansweeper AD Users and email
by  CyberCitizen  
Go to last post Go to first unread
Last post: Today at 12:40:54 AM(UTC)
Lansweeper Distrubution Center workstation Map
by  CGIMana79   Go to last post Go to first unread
Last post: Yesterday at 6:00:44 PM(UTC)
Lansweeper Starting ticket # for helpdesk
by  AEM IT  
Go to last post Go to first unread
Last post: Yesterday at 5:17:22 PM(UTC)