Help with creating report

[hollye]

I would like to create a report, that when ran, will show me if someone has had more than a certain # of incidents open, such as more than 3, within a 30 day time period. How could i go about doing that. 

[AndersBGS]

Hi @hollye ,

Are we talking about assignee or about the end-user according to "have more than # number opens in a period? 

You can utilize the related list condition with below when creating a report from the sys_user table. 

This will off course only show the users that have 3 or more incidents. Afterwards you need to add some conditions to the incident table:

Note, that this will only give you the users name - not the incidents. If you need to have the different incident numbers in the report, you should create a database view instead to combine sys_user and incident table. 

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

best regards

Anders 

[hollye]

About the user, so i am using the 'Opened For' field

[AndersBGS]

Hi @hollye ,

Same concept. Just utilize the open for instead of end-user. 

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

best regards

Anders