<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><div style="font-size: 12pt; ">All,</div><div style="font-size: 12pt; "><br></div><div style="background-color: transparent; ">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="background-color: transparent; "><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><br></div><div style="background-color: transparent; "><br></div><div style="background-color: transparent; ">What should i be reading to make this happen?</div><div style="background-color:
transparent; "><br></div><div style="background-color: transparent; ">Thanks</div><div style="background-color: transparent; ">Winn Johnston</div></div></div></div> </div></body></html>