A report to show the average number of incidents per user at a certain period.

[Taha_Alawadhi]

Hello!

Can someone help me create a report that will show the average number of incidents/requests submitted per user at a certain period?

For example: We had 2000 employees last May , and we got 10000 tickets that month, so the report should show5 tickets per employee.

Thanks!

[Kalyani Jangam1]

Hi Below filter you can use

[Taha_Alawadhi]

Thanks Kalyani, but unfortunately, that's not what I am looking for 😞 

That's the number of ticket a user submitted in a period of time.
I am looking for the average number of ticket per employee 
so if you have 1000 employee and 10000 tickets submitted last month the report should show 10 tickets per employee for May

[gyedwab]

Hi Taha,

We put together a video on a very similar use case -- there it was incidents per asset, but you can follow the same steps with the user table to get the results you're looking for:

https://www.youtube.com/watch?v=BOvCwR_6Loc&t=1s&ab_channel=ExploreAnalytics

Let me know if you have any questions,

[sarahakers]

The easiest way to do this is to create a field called "user_count" or something like that on the top table. Seems on this it would be on sys_user. Make it an integer. At incident closure you would update the field using a business rule to add one to the existing count.  You can then run reports using that field to average.  

The better way would be to create a metric similar to the group reassignment for incident.  track the metric by user and add the incident created date. you can then report off the metric table for averages, user, time periods based on create.