Winn,<br><br>Are you using the RT SQL provided with the system?<br><br>Once you've created a search with RTSQL, you save the search and then it is available to be used in a Dashboard.<br><br>Hope this helps.<br><br>Kenn<br>
<br><div class="gmail_quote">On Thu, Sep 6, 2012 at 7:54 AM, Winn Johnston <span dir="ltr"><<a href="mailto:winn_johnston@yahoo.com" target="_blank">winn_johnston@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:12pt;font-family:times new roman,new york,times,serif"><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-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">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-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><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 <a href="http://u.id" target="_blank">u.id</a> = 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="font-style:normal;font-size:16px;font-family:'times new roman','new york',times,serif">
<br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
Can someone please help?</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
Thanks</div><span class="HOEnZb"><font color="#888888"><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">Winn Johnston</div></font></span></div>
<div style="font-style:normal;font-size:16px;font-family:'times new roman','new york',times,serif"><br></div></div>  </div></div></blockquote></div><br>