Creat reports for each user

Aju1
Tera Contributor

Hi all i want some details to creat a reports for details about the each person how many ticket they are assigned and how many tickets they resolved and how many tickets still bending for them can any one help me

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @Aju1 , 

 

Go to run/view and create a new report based on the table you would like to see. The just add a filter for "Assigned to is <<the name you want>> AND state is <<the state you want to see>>.

 

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

 

Best regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @Aju1 , 

 

Go to run/view and create a new report based on the table you would like to see. The just add a filter for "Assigned to is <<the name you want>> AND state is <<the state you want to see>>.

 

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

 

Best regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Aditya Raute
Mega Guru

I need more info for this. Is this a manager trying to check if the subordinates' number of resolved and pending records - in which case they will have to see all subordinates' data at the same time; or is this for each assignee where, when they come on platform, they should only see their own resolved and pending records? 

For case 1, 
Select the Table you want (e.g. incident)
Select Heatmap report type

Under row, select assigned to field. Under column, select State field or Active field.
You can filter of date or month if necessary.

Press Run.

AdityaRaute_0-1675934060659.png


For Case 2,

You'll need to create two separate reports

Select the Table you want (e.g. incident)

Select single score as the report type

For report 1, in the filter use this condition
`Assigned to > is (dynamic) > Me` AND `Active > is > True`

AdityaRaute_1-1675934226652.png


For report 2, in the filter use this condition
`Assigned to > is (dynamic) > Me` AND `Active > is > False`

AdityaRaute_2-1675934259652.png


P.S. An incident turns inactive when it is closed, and stays active when it is pending.

Hope this helps!