question Help with creating report in Community Central forum

Help with creating report

hollye — Tue, 24 Sep 2024 20:29:19 GMT

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.

Re: Help with creating report

AndersBGS — Wed, 25 Sep 2024 05:57:28 GMT

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

Re: Help with creating report

hollye — Wed, 25 Sep 2024 13:49:57 GMT

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

Re: Help with creating report

AndersBGS — Thu, 26 Sep 2024 05:56:06 GMT

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