Skip to Content
0
Former Member
May 20, 2010 at 12:16 PM

counting a characteristic based on its value

435 Views

Hi All,

i have a requirement....suppose i have a characteristic status which has lot of values but only when the status value is equal to 'E0010' OR 'E0008' OR 'E0003' then only i can consider a ticket closed..in rest of all the other statuses the ticket is considered open...

priority open tickets closed tickets

very high 10 17

high 20 3

medium 40 2

low 30 7

How to count those tickets whose status is 'E0010' & 'E0008' & 'E0003' and rest of the other statuses into one

any suggestion would be helpful ...

Regards,

Deadlocks

Edited by: DEADLOCKS on May 20, 2010 2:16 PM

Edited by: DEADLOCKS on May 20, 2010 2:17 PM

Edited by: DEADLOCKS on May 20, 2010 2:25 PM