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

[dwalby]

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

[Lyonel]

@dwalby here is how I would do it:

Top 10 resolvers:

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.

 

[Lyonel]

Another option is to create a chart:

h_status in ('status.resolved','status.closed') and date(h_dateresolved) = curdate()

 

[Lyonel]

Last method I can think of: using a measure

then a chart based on the measure

Giving you something like that:

[dwalby]

Thanks @Lyonel