<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">All,</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal; ">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.</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal; "><br></div><div style="background-color: transparent; "><div style="background-color: transparent; ">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;</div><div style="background-color: transparent; "><br></div><div style="background-color: transparent; "><div style="background-color: transparent; ">*************************** 1. row ***************************</div><div style="background-color: transparent; "> User: winnj</div><div style="background-color: transparent; ">TotalClosedTix: 6</div><div style="background-color: transparent; ">*************************** 2. row ***************************</div><div style="background-color: transparent; "> User: dennisc</div><div style="background-color: transparent; ">TotalClosedTix: 3</div><div style="background-color: transparent; ">*************************** 3. row ***************************</div><div style="background-color: transparent; "> User:
royced</div><div style="background-color: transparent; ">TotalClosedTix: 1</div><div style="background-color: transparent; ">3 rows in set (0.00 sec)</div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; font-style: normal; "><br></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; font-style: normal; background-color: transparent; "><br></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; font-style: normal; background-color: transparent; ">Can someone please help?</div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; font-style: normal; background-color: transparent; "><br></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; font-style: normal;
background-color: transparent; ">Thanks</div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; font-style: normal; background-color: transparent; ">Winn Johnston</div></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; font-style: normal; "><br></div></div> </div></body></html>