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: 1
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 Email attachments
by  krejar   Go to last post Go to first unread
Last post: 8/15/2019 10:15:07 PM(UTC)
Lansweeper HP Printer not showing correctly
by  Fathom  
Go to last post Go to first unread
Last post: 8/15/2019 4:14:55 PM(UTC)
Lansweeper Install LsAgent on Mac
by  Jonnym   Go to last post Go to first unread
Last post: 8/14/2019 10:14:08 AM(UTC)
Lansweeper Asset State Question
by  rtaylor  
Go to last post Go to first unread
Last post: 8/13/2019 5:53:24 PM(UTC)
Lansweeper LSAgent Version
by  roberto.m  
Go to last post Go to first unread
Last post: 8/13/2019 3:33:50 PM(UTC)
Lansweeper Lansweeper and snmp v3
by  Justin5135   Go to last post Go to first unread
Last post: 8/12/2019 7:07:22 PM(UTC)
Lansweeper Hikvision CCTV Cameras SNMP scan
by  thejduk  
Go to last post Go to first unread
Last post: 8/12/2019 2:34:05 PM(UTC)