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
