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: 5
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 Understanding current setup
by  ggarcia   Go to last post Go to first unread
Last post: Today at 12:24:42 AM(UTC)
Lansweeper Remote desktop custom port
by  sefaucher  
Go to last post Go to first unread
Last post: Yesterday at 10:30:49 PM(UTC)
Lansweeper Unable to transfer user's data prior to removal
by  RickW99456   Go to last post Go to first unread
Last post: Yesterday at 9:06:14 PM(UTC)
Lansweeper Unable to access the lansweeper consol for other computer
by  Kudnan Ingle  
Go to last post Go to first unread
Last post: Yesterday at 7:49:32 PM(UTC)
Lansweeper Closing and re-opening of tickets
by  NWHiker   Go to last post Go to first unread
Last post: Yesterday at 3:42:56 PM(UTC)
Lansweeper Wake on Lan Issues
by  woldummy  
Go to last post Go to first unread
Last post: Yesterday at 3:42:07 PM(UTC)
Lansweeper Deploy and start Software
by  EDV_OHZ   Go to last post Go to first unread
Last post: Yesterday at 12:49:08 PM(UTC)
Lansweeper Helpdek Call Re-Opened
by  mouaad  
Go to last post Go to first unread
Last post: Yesterday at 7:30:59 AM(UTC)