[rt-users] Query to usein dashboard for timeworked

[Alex Rhys-Hurn]

Hello, 

I am really struggling with the query builder. 

I would like to build a query that is as follows: 

    1. Works for a specific queue i.i. Queue = 'queuename' 
    2. Applies to all activity in the queue since the 1st of the CURRENT calendar month 
    3. Outputs the total timeworked for the queue in that period. 


So, I should get output that says something like 



queue = queuename 
timeworked (for all tickets, totalled) since 1st of current month = xx minutes 


I will then make a saved search and use a dashboard notification to send that around. 


Is what i am asking even possible? 


Many thanks, 

Alex 

-- 

Alex Rhys-Hur n | ITworX Limited 
P.O. Box 1649, 00502, Karen, Kenya 
Tel: +254 (0) 20 2444824 | Cell: +254 (0) 724 972541 
Web: www.itworx.co.ke 





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120508/ae44ee0c/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: webmail_logo.png
Type: image/png
Size: 1057 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120508/ae44ee0c/attachment.png>