Selection Criteria Help - Please Advise

[rico7937]

I have this selection criteria that I measure all tickets opened in the previous month and all tickets that are put in a servicerestored status for the previous month. Unfortunately I'm am not pulling tickets that were put in a servicerestored status for the previous month but may have been opened 2,3,4 months ago.

Ex. Ticket xxx Opened in Sept and put in servicerestored status in Dec. This ticket would not show up in my report since it was opened in Sept.

For Open Date Time I use {PROBLEM.OPEN_DATE}
ServiceRestored I use {PROBLEM.SOLVED_DATE}

I would greatly appreciate any advice on what change I may need to do.
Here the selection criteria:


DTSToDateTime(tzcvtConvToLocalDatetimeByName(ToText(DateTime({PROBLEM.OPEN_DATE},{PROBLEM.OPEN_TIME}),"MM/dd/yyyy hh:mm tt"),"Eastern Standard Time"))
In Datetime (totext (Date(DateAdd ("m",-1,Cdate(year(CurrentDate),month(CurrentDate),1)))) & " 00:00:01") To Datetime (totext (Date(DateAdd ("d",-1,Cdate(year(CurrentDate),month(CurrentDate),1)))) & " 23:59:59")
and
{PROBLEM.PROBLEM_CODE} = "[SERVICERESTORED","CLOSED","TRANSFERRED"]
and
{PROBLEM.SEVERITY} = [1.00]
and
not
({PROBLEM.CAUSE_CODE} = ["Duplicate", "DUPLICATE"])
AND
not
({PROBLEM.PROBLEM_CODE} = ["Duplicate", "DUPLICATE"])
AND
(isnull({OUTAGE_DATA.ACTION_TYPE}) or

({OUTAGE_DATA.ACTION_TYPE} <> ["EXEMPT"]))

and
(isnull({PROBLEM.COMPONENT}) or

({PROBLEM.COMPONENT} <> ["NETWORK_HW","POWER"]))

and
({PROBLEM.GROUP_ID} LIKE ["IGS-VF*", "VFC-SD-LOCOU*","VFC-SD-NETW*","VFC-SD-P*","VFC-HLPDSK-EN*"])))

 

[lbass]

Please do not cross-post.

-LB

 

[rico7937]

Understood

 

[MrBillSC]

I think you just need to add the select criteria for the Problem.Solved_Date. Enclose in parenthesis and use an "or" statement:

((DTSToDateTime(tzcvtConvToLocalDatetimeByName(ToText(DateTime({PROBLEM.OPEN_DATE},{PROBLEM.OPEN_TIME}),"MM/dd/yyyy hh:mm tt"),"Eastern Standard Time"))
In Datetime (totext (Date(DateAdd ("m",-1,Cdate(year(CurrentDate),month(CurrentDate),1)))) & " 00:00:01") To Datetime (totext (Date(DateAdd ("d",-1,Cdate(year(CurrentDate),month(CurrentDate),1)))) & " 23:59:59"))

or

(DTSToDateTime(tzcvtConvToLocalDatetimeByName(ToText(DateTime({PROBLEM.Solved_DATE},{PROBLEM.OPEN_TIME}),"MM/dd/yyyy hh:mm tt"),"Eastern Standard Time"))
In Datetime (totext (Date(DateAdd ("m",-1,Cdate(year(CurrentDate),month(CurrentDate),1)))) & " 00:00:01") To Datetime (totext (Date(DateAdd ("d",-1,Cdate(year(CurrentDate),month(CurrentDate),1)))) & " 23:59:59")))

and ...(etc.)

MrBill