Hi There,
1)In the below sample, im trying to count(and categorize) incidents based on number of days the incidents are open.
The categories are
count/# of Incidents open 1-30 days
# of incidents open 31-60 days
# of incidents open 61-90 days
and incidents open > 90 days
Can anyone help me please.
Incident ID. Days Open
IR-2006-045 76
IR-2006-047 76
IR-2006-016 225
IR-2006-035 133
IR-2006-036 86
IR-2006-057 34
IR-2006-058 17
IR-2006-058 30
IR-2006-022 125
IR-2006-023 125
Thanks
Nate777
[/img]
1)In the below sample, im trying to count(and categorize) incidents based on number of days the incidents are open.
The categories are
count/# of Incidents open 1-30 days
# of incidents open 31-60 days
# of incidents open 61-90 days
and incidents open > 90 days
Can anyone help me please.
Incident ID. Days Open
IR-2006-045 76
IR-2006-047 76
IR-2006-016 225
IR-2006-035 133
IR-2006-036 86
IR-2006-057 34
IR-2006-058 17
IR-2006-058 30
IR-2006-022 125
IR-2006-023 125
Thanks
Nate777
[/img]