Hi All,
Using CRXI
ODBC Connection to Remedy ARS 5.1 (Helpdesk)
Query is:
{Data.Logged_Date} = {?DateRange}
or
{Data.Closed_Date} = {?DateRange}
This retrieves anything logged or closed over the selected date period.
What I am now trying to do is Graph the results by date (bar graph over date range for comparison), the issue here is we have 2 sets of dates to graph, one for Logged and one for Closed. From a previous post in 03 it was suggested to use Excel, however this will be a daily report, which will log the progess by Monthtodate, Yeartodate, etc. Any Suggestions?
Cheers!!
Using CRXI
ODBC Connection to Remedy ARS 5.1 (Helpdesk)
Query is:
{Data.Logged_Date} = {?DateRange}
or
{Data.Closed_Date} = {?DateRange}
This retrieves anything logged or closed over the selected date period.
What I am now trying to do is Graph the results by date (bar graph over date range for comparison), the issue here is we have 2 sets of dates to graph, one for Logged and one for Closed. From a previous post in 03 it was suggested to use Excel, however this will be a daily report, which will log the progess by Monthtodate, Yeartodate, etc. Any Suggestions?
Cheers!!