Hi, Take a look at SummaryByUser extension. It shows only active statuses, but it's possible to change statuses.
On Thu, Sep 6, 2012 at 6:54 PM, Winn Johnston <[email protected]> wrote: > All, > > I am trying to create a top closers list on the default dashboard. I have > the exact SQL statment i want to use, but i am lost after that. > > select u.Name as User, count(1) as TotalClosedTix from Users u join Tickets > t on u.id = t.owner where t.Status = "resolved" group by u.Name order by 2 > desc limit 10 \G; > > *************************** 1. row *************************** > User: winnj > TotalClosedTix: 6 > *************************** 2. row *************************** > User: dennisc > TotalClosedTix: 3 > *************************** 3. row *************************** > User: royced > TotalClosedTix: 1 > 3 rows in set (0.00 sec) > > > Can someone please help? > > Thanks > Winn Johnston > -- Best regards, Ruslan.
