Jump to content

Widget - Top Request Resolver (Day/Week/Month)


dwalby
 Share

Recommended Posts

Hi all,

I'd like to create a widget displaying the 'Top Request Resolver' of the day (and week, month, etc.)

How would I go about doing this so it shows the number of requests resolved as well as the name of the analyst?

Thanks in advance

Link to comment
Share on other sites

@dwalby here is how I would do it:

Top 10 resolvers:

image.png.3faf6370f37515b2a4bbb78c7ef00312.png

image.thumb.png.452e20e05f56d0c05a45a6af9969399b.png

image.png.c24f045b0112b49384841b4ffc9a5364.png

SELECT h_resolvedby_username as Resolver, count(h_pk_reference) as Requests FROM h_itsm_requests where date(h_dateresolved) = curdate() group by h_resolvedby_username order by 2 desc limit 10;

This gives you the freedom to choose what to display as well as how many. change "10" by the number you want.

 

  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...