How to extract the number of re-opened tickets and assigned to each team members

[PrasadWT]

am trying to get the  number of re-opened tickets for the month of February. 

And also, with the user IDs, who has worked on those.

i tried to do with the

below 

Definition is MRIM AssignedTo 

Value is one of << user1, user2, user3 >>

but its showing me  " no records to display"

can anyone pls help me to get the number of re-opened tickets.

[AndersBGS]

Hi @PrasadWT ,

In the report designer, you can create a report in the incident table by utilizing below filter:

This will give you the tickets that is not resolved, closed and cancelled which has been reopened.

If my answer has helped with your question, please mark my answer as accepted solution and  give a thumb up.

best regards

Anders

[PrasadWT]

Thanks for your response. Anders. But , for me, when i have tried it with this reopencount , am getting different set of values. So, do I need to add few more filters for achieving this. 

[Alp Utku]

You can try below conditions

Reopen count grater than 0 AND

State is anything AND

Assigned To is not empty AND

Opened between x - y dates (1 - 28th February)

By applying these, you will be able to see tickets which reopened at least one time and assigned to field is not empty. (Ticket was taken over by someone previously) You can then Group By Assigned To field to see people who worked on the tickets seperately.

[AndersBGS]

Hi @PrasadWT ,

When stating that you getting a different set of values - What do you mean? Have you verified the tickets and why you see them? And in relation to this, what filter you then need to create? 

If my answer has helped with your question, please mark my answer as accepted solution and  give a thumb up.

best regards

Anders